Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?
 
PerlMonks  

Re^4: [OT] Re: Get unique fields from file

by erix (Prior)
on Jan 11, 2022 at 17:38 UTC ( #11140382=note: print w/replies, xml ) Need Help??


in reply to Re^3: [OT] Re: Get unique fields from file
in thread Get unique fields from file

so this is really just an exercise for our own edification and enjoyment.

So let me just enjoy some more light quibbling:

Hipp, SQLite-man extraordinaire:

"SQLite was a spin-off of postgres, a conceptual fork"

"We continue to look up at postgres as our mentor"

(which makes sense, why invent the wheel? I saw (just a few days ago) that the SQLIte devteam/Hipp are implementing some JSON operators, taking the example from postgres. Good!)

More fun: a youtube talk by Hipp (admittedly talking to a postgres-audience, at PGcon 2014):

PGcon 2014 talk by Hipp

  • Comment on Re^4: [OT] Re: Get unique fields from file

Replies are listed 'Best First'.
Re^5: [OT] Re: Get unique fields from file
by Marshall (Canon) on Jan 11, 2022 at 20:14 UTC
    Well....I don't know about the postgres foundation for SQLite...check this interesting story out from Richard Hipp: Origin of SQLite

    My SQL-Foo is weak. OMG this can get complicated!
    As an example, I present jaro-winkler.sql - this is so far above my SQL pay grade, I get a nose bleed just thinking about it!:

    I have a tutorial on postgres that I am slowly working my way through. SQL is a complex subject. Admin of a DB is a complex subject. I have certain tasks that I want to learn how to do in SQL. But this is very much a "work in progress". I am now able to do simple SQL tasks and I have found that the combo of Perl + SQL is super powerful. SQLite is my "go to" DB because there is no admin or installation hassle.

    I like this Hipp quote: "Fortunately, I didn’t know any experts — and so I did it anyway.”

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://11140382]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others exploiting the Monastery: (2)
As of 2022-05-21 00:54 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Do you prefer to work remotely?



    Results (76 votes). Check out past polls.

    Notices?