Home

Extend

Hashnode Pro
Hashnode for Agents

Resources

The foreword
Hashnode gql skill

Buildful - AI coding agent that delivers frontier-level results at a fraction of the cost Bug0 - The AI-native e2e QA regression testing Hackathons Changelog Brand @hashnode on X Hashnode on LinkedIn Support - hello+support@hashnode.com Code of Conduct Terms Privacy Sitemap

Search Hashnode

Search posts, tags, users, and pages

Discussion on ""Poor Man's SQL": Accessing the PicoLisp Database with SELECT" | Hashnode

Feed/

Discussion

Mia Temma

Nov 15, 2021

"Poor Man's SQL": Accessing the PicoLisp Database with SELECT

In the last post, we have seen how we can do complex queries on the PicoLisp Database with help of Pilog. Now we will see an alternative way that may be more convenient for same cases: The select function with a similar syntax to the SQL language. U...

picolisp-explored.com3 min read

#sql #databases #functional-programming

Responses1

Markdown supported · ⌘↵ to post

Nehal Singhal

Jan 25, 2023

Nice! How did this come: : (select dat fin nm (mate nm) +Person nm "Edward" job "King")

Explain slightly more if possible.

As per this line of code, the first three attributes after select are parameters for comparison, then the class to be seen and thereafter data that function select supplies for comparison to look into family DB? That's the sequence?

Nehal Singhal

Jan 25, 2023

Mia Temma

Feb 5, 2023

Hi Nehal Singhal, right, so "dat fin nm (mate nm)" are the attributes of the requested output, e. g. birthday, death day, name and partner's name. And this is followed by the actual filter request: '+Person nm "Edward" job "king"', e.g. "find a person with the name Edward and job king".

Sorry that it was not clear! Maybe it helps if you check the corresponding SQL request one line above, that's more close to conversational English.