Beefy Boxes and Bandwidth Generously Provided by pair Networks
go ahead... be a heretic
 
PerlMonks  

Re: Databases made easy (interview Richard Hipp)

by erix (Prior)
on Jul 04, 2021 at 09:41 UTC ( #11134627=note: print w/replies, xml ) Need Help??


in reply to Databases made easy

OT, perhaps, but I thought this was fun: an interview with Richard Hipp, the creator of SQLite, with lots of details from the early days of SQLite. A podcast, but with transcript (July 2021).

SQLite with Richard Hipp

PS

As a postgres aficionado, I especially like his story about the huge test-suite of SQL-statements that crashed all RDBMS-comers *except* PostgreSQL. But it also shows how well tested SQLite is. Hipp:

"Shane Harrelson did this for us about 10 years ago. He came up with this huge corpus of SQL statements, and he ran them against every database engine that he could get his hands on. We wanted to make sure everybody got the same answer, and he managed to segfault every single database engine he tried, including SQLite, except for Postgres. Postgres always ran and gave the correct answer. We were never able to find a fault in that. The Postgres people tell me that we just weren’t trying hard enough. It is possible to fault Postgres, but we were very impressed.

We crashed Oracle, including commercial versions of Oracle. We crashed DB2. Anything we could get our hands on, we tried it and we managed to crash it, but the point was that we wanted to make sure that SQLite got the same answers for all of these queries."
  • Comment on Re: Databases made easy (interview Richard Hipp)

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others meditating upon the Monastery: (5)
As of 2022-01-24 14:30 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    In 2022, my preferred method to securely store passwords is:












    Results (64 votes). Check out past polls.

    Notices?