Sqlite Is The Most Used Database 

It’s maintained by 3 people and they don’t allow outside contributions? Huh.. I hope they don’t go on road trips together.

We went from "NoSQL will replace SQL" to "there are more SQL DBs than people"

Chromium browsers History is stored in a SQLite db. That already makes a few dozen billions probably

100% code coverage because it's stipulated contractually / by managers is crap that devs will avoid using every trick in the book. 100% code coverage because some spartan gigachad devs are thoroughly committed to the reliability and security of a product they wholeheartedly believe in is a win.

"It's just faster than fopen()" - creators of sqlite

That meme about 1 dev holding up a trillion dollar industry in Nebraska is, like, not a joke. :'D

SQLite has the incredible levels of testing because Richard Hipp heard about the DO-178B standard for aviation products, which requires 100% MCDC, and used that as an inspiration for their test suite.

Local DB on mobile devices. :)

3 Contributors: one for the father, one for the son, and one for the holy spirit.

• 100% code coverage: Drake nope • 600 tests for every line of code: Drake yep

"squeal-lite"

its not baked into PHP, its added via an extension... that extension however has been shipped with and enabled by default since like PHP 5 so kinda close enough..

Too be fair setting up a DB and then having to make a table and so on sucks, while SQLite is just inside the app and creates basically itself.

I totally use sqlite...it's great. Don't have to deal with connectors and drivers...you just build it right in. All of my game servers have sqlite dbs for their stage 1 databasing.

I used to work as embedded device engineer for home appliances and we always use sqtlite for our db. That on itself is huge amount.

SQLite is an in-process DB, that's why it's everywhere (including programming languages). It's easily embedable.

SQLite is my favorite db by miles. Can't be topped

SQLite is the Chic-fil-a of software. Not bad, not supar amazing. Clearly, God has caused it to grow to be way more popular than it should. It's proof that God is still at work in this world.

I haven’t finished watching this yet but the reason they don’t allow contributions is stated clearly on their website, and it has to do with it being released into the public domain and they don’t want copyright issues there.

In multiple companies I've worked at: 1 PG/MySQL/MariaDB production database, 1-2 staging dbs of the same make, and then every single dev runs tests against sqlite DBs locally. So yeah, figures.

"Do not steal" Programmers: well, fuck...

sqlite is just fantastic. It's also not difficult to write own extensions

I use PHP. I had absolutely NO IDEA it was baked into the language. I’ll have to look it up.

Sqlite is great for the right use case. No network hop or layers between makes it super fast. It also doesn't require network configuration, DB configuration, installation, dockers or anything to install. A few limitations though, the schema doesn't enforce typing. Type a column as an int and put a string or blob in it no problem. This means your code has to protect against this while developers are used to the database doing it. The locking mechanism is very course-grained. The entire DB file gets locked. There are ways around this such as splitting up database files or using the write-head-log. Table modifications can be challenging as you often have to create an entirely new table and copy the data over to it. But it is amazing how much it is capable of. I used it on a project where we planned on supporting both Sqlite and a database server; we were able to push it further than expected and delay using a database server.

Python mentioned...let's Go!!

I quite like the general idea of a Code of Ethics: "This is what we aspire to, but do not expect or demand from anybody else. We may fall short, but this is a statement of the shared values we strive to embody." It's a cross between a Code of Conduct (which is a more binding set of expected minimums) and a Mission Statement (which is project outcome oriented), but more fundamental and internal. It would be interested to see different cultures produce these documents. We often assume that other open source authors approach life in the same mindset, but several times (like Chinese state backdoors, or the "just commit anything to get a job" concept), that has proven to be a bad assumption.

Why would it be "fragile"? I think it's a nonsense modern idea that everything needs to be maintained with constant updates. It's a mature product that works. And since it doesn't run like a server you could connect to, but instead it's file based, there are arguably no data security risks.

The tzdb thing re: 2 people is... misleading, it's not that fragile lol. And SQLite is correctly labeled opensource; source being open refers *explicitly* to the license. "Public source" is more apt to e.g. Terraform and Redis' licenses. (Don't confuse "open source" with "open source *development model*"; they're wholly different things with no relation.) Lastly, BASED SQLITE TEAM

I do feel Turing got treated worse than Babbage. He might not have minded the shafting as much tho.

Ada Lovelace gets the cred because she is the one with the epiphany that the numbers being calculated with these machines could represent other things that transcend pure number crunching purposes. As symbols for anything, not just quantities. Numbers as letters that form words, such as ASCII? Numbers as pixels that form an image? Numbers as an array of tensors that represent states of AI thought? Numbers in a series of voltage values to a speaker over time that form audio samples? As FSM states? As DAW music sheet notes? As elements of a vector representing points in 3D space and their connectivity into triangles to represent 3D shapes? As enumerated IDs for different Pokemon and their various learned abilities? All that and more are tied to her realization. Plus, she's a great example of women in STEM; historically, there's only a small handful, but they're all amazing.

6:47 daaaaammmnnnnn and I thought my app having the Golden Rule on our code of conduct page was heavy.

I did not expect to see the Ten Commandments in a software Code of Ethics.

It's just a fancier and better spreadsheet.

0:14 because its deployed with apps.

"I'm subscribed to you" was the sickest burn ever 😂

I love SQLite

I don't think you're right that no one knows Babbage. But even then. Charles Babbage didn't finish the difference machine. A museum have made a working model of it (ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-BlbQsKpq3Ak.html). It works on a crank and requires a lot of manual work to use. It was supposed to be even bigger, but he had problems with his workforce and couldn't get funding for version 2 when version 1 never finished. I think the visions of Ada Lovelace can not be underestimated. She looked at the automatic looms and her work with Charles Babbage and talked about how it would change the world. The loom became the hole punch reader and one of the first ways to program. (documentary from bbc about Ada Lovelace: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-QgUVrzkQgds.html)

You can almost certainly say that the entire software industry is being kept on float by some random opemnsource library that is being maintained by one elderly man in his free time

Haha, I just designed, implemented and deployed a Sqlite database based solution which uses Kubernetes persistent volume (with ORM, code first migrations, etc). I'm still kinda terrified, but looked into it a bit deeper (previously I only used it for testing), and Sqlite is quite robust. Its main limitation is concurrency.

this was a rabbit hole and a half

As someone who is genuinely interested in Interpreters, Compilers and DBs but currently cant make time to look into them, I appreciate these vids so much! Got the books btw hopefully I got some free time again in a couple of months! Thanks for the discount, saw the books being recommended in a couple of places!

ThePrimeChirstTime

especially by people who don't know they're using a database

Just think someone might upload the entire Bible labelled "Code of Conduct" 😂

I am going to put "Do not murder" in any code of conduct I'm responsible for

i think i'm never using sqlite again, those rules are so yikes

With great power comes great responsibility - and sqlite devs are a testament to that

«I store all my data in memory» Like if computer needs some data, Devon AI sends me a message in skype, then I remember and answer him? 2030 programming

People don't remember Charles Babbage? Everyone I know in computing knows Charles Babbage. This might be just American thing

I’m amazed that one of my favourite DB is designed by legit Christians and detached from the trending rules. Instead they insist the way it was started. Do the right thing in the right way.

"Bury the dead" - is that why Prime went to React Miami?

Funny the rule of do not murder when you know the history of ReiserFS, good that Linux does not have that rule.

"be nice to people" prime: wow look how awesome these things are! "sell your soul to christ" prime: *no comment*

72 ... DEFINITELY this is way older and based on Pythagoras 'Carmen Aureum'.

Christ is King

Imagine having a software using a legacy thing called: DBASE database file or .dbf. To give you an idea, the file type was introduced in 1983. Sqlite was released in 2000! There have never been any issues with dbf. Ever. /s

Not only the most used, but faster db too

I had no idea, the when I clicked on a SQLite video, that it would turn out to be a sermon.

I want to know what type of coffee beans you use to make your morning coffee? Damn dude. ❤

Id put money on the fact that almost nobody knows who Ada Lovelace is and doesnt know who Charles Babbage is. A few will, her dad was Lord Byron after all, but the vast majority know the pair. She might get mentioned more frequently cause she was up against a unique set of challenges, had a more interesting family, is a comparatively rare role model, and Lovelace is an objectively more awesome name than Babbage...

19:05 While probably not as shafted as Charles Babbage, Konrad Zuse was also quite shafted.

Those saying the commandments are "Christian rules" are wrong. Those are Jewish rules that were also adopted by Judeo-Christians over a 1500 years later.

i think the Charles Babbage vs Ada Lovelace thing is Ada has a cooler name.

"squeal"...jesus that hurt my ears

Just curious if there's a code of conduct that permits murder? Asking for a friend. 1. Love God fully and your neighbor as yourself. 2. Avoid sinful acts like murder, adultery, and stealing. 3. Practice self-denial and moderation; cherish fasting and simplicity. 4. Support the needy and comfort those in distress. 5. Stay humble and avoid earthly pleasures and pride. 6. Be truthful, patient, and forgiving; avoid deceit and grudges. 7. Seek eternal life, fear judgment, and always be mindful of God’s presence. 8. Maintain a disciplined spiritual life through prayer, reading, and guarding against sinful thoughts. 9. Respect authority, live righteously, and be peacemaking. 10. Always rely on God’s mercy and strive for true holiness.

In Android support is native.. so any app can use sqlite databases (can even be multiple dbs per app), i think each such instance = an app counts as 1.. so millions of Android devices * 5-10-20 apps .. + web apps can also use it natively, and there are 1 billion sites. On iOS, i know they have own persistence shit.. but it would be funny to find out, that some proj use too (say they want 1:1 code with Android counterpart). I even think it make sense even for backend, for small projects (say you have not that many users / records / connections) So, it probably make sense to be most used DB engine.

Hey, don't make fun of Christians like me! 😄 We are well aware of shameful sins in the past (Inquisition, ... 'nouf said) but have also done good things for humanity. At least they have a code of conduct ... while software engineers in the (cough, cough) financial services industry have a culture of misconduct.

I'm pretty sure most people (in cs) know who Babbage is

Completely disagree on the end part. Databases, compilers, OS are created by geniuses. Your typical web dev can not compare. I actually think you are trolling. In the past, before the internet, when they were only building this fundamental shit, the level of skill and passion was much higher.

To be fair, people didnt give 2 fucks until the xz incident, and xz only had 1 person So realistically, i'd trust SQLite's internally-controlled system than public open source projects

Platforms like sqllite deserve that test coverage, because they have a massive blast radius. If you're developing something smaller like an API, or single page app, then you don't need such extensive testing.

Imagine going through hell to get into that super tight group of SQLite contributors for a few years, to only get kicked out because you decided to cremate your aunt Judy, who you never visited.

sqlite is so popular, it even inspired the 10 commandments ;) Damn, I kinda like "be a stranger to the worlds ways" though, Jesus wants you to be a rebel.

As a soyderp who only codes in Python I confirm that SQLITE is part of the standard lib. I didn't know it was even a thing outside of Python akshully.

why would they even allow contributors if they are succesful ? contributors come when you are building not when you finished and they want a piece of pie or sabotage it behind the scenes and certainly not for others to copy-paste and benefit from their work without any form of reward in return

I donno Ada Lovelace, however in India we have always been taught Charles Babbage to be father of modern computing. Since 40 year atleast.

I do tend to add in extra tests even for things that aren't strictly necessary because I can just tell AI to make them, so I have the coverage without the effort; it's just a "I might as well"

So essentially Linus tor olds and the SQLite crew are responsible for almost as much if not more software than Apple and Microsoft…. And probably better at it as well

Babbage had a popular video game store named after him in the 80s/90s. Unfortunately, it's now called GameStop.

I don't get the weird babbage ramble. Maybe recently Ada lovelace gets more attention but when I learned about computers in the 80s they never mentioned her, just babbage.

Makes sense that a Squeal company would have a code of ethics that is a ‘long list’ SELECT * FROM [Ethics];

One more statement that people are arguing that Testing is not necessary. Tell me then , can you prove your app to me as End user?. "Trust me bro", is not acceptable 😅😅😅😅

Most devs are skilled enough to write DB code (given enough time) but almost nobody is persistent enough to actually make a good DB.

I feel no pity for Babbage. Ada Lovelace is one of the few times anyone can actually name a woman in the field of computation. Let the women have something. Lol.

13:05 You should at least test that the features you want to support work as intended. So everything not covered by a test is just “unsupported” functionality

I have to use SQLite at work currently and it ways of handling schemas and foreign keys is... interesting.

The fact that it's written in C and doesn't accept contributions isn't scary at all. I'm sure there aren't any serious vulnerabilities to worry about.

That code of ethics is simply crazy! To be honest, though, ReiserFS could have made good use of point number 3.

working with data at finance dept, I use SQLite sińce day one of my adventure with Python... and I love it 😊

Bout to go pitch my GDD web and mobile services to the local clergy! 😇

tbf Babbage's Difference Engine was never constructed in his lifetime Ada Lovelace is goat for creating algorithm in a never-before-constructed computing machine

WRONG. Everyone knows the most widely deployed database engine in the world is Excel spreadsheets. 😏

Testing is not necessarily only for security, but for stability, accuracy, fidelity and feature compatibility. 😢

Saying SQL as Squel is the ugliest way of saying this I ever heard so far

I gonna add that code of conduct to my project.

It works... it runs locally... it does not even need to be maintained by anyone at this point, if no new features are added.

100% coverage is bad as a primary goal, but it's great if you get to 100% simply as a consequence of how extensive your test suite is.

I can easily imagine that there are on the order of 1 trillion SQLite databases. I would be surprised if there were NOT at least 100 instances of SQLite databases on my computer at this moment. It's like a half-step up from using files for data storage in apps. Do you use Chrome? Firefox? Edge? They ALL use SQLite for histories, cookies, session information. Chrome has at least five SQLite databases it uses: Cookies, History, Login Data, Web Data, and Favicons. iTunes, Skype, use SQLite, ... More instances. It's all over the place. It's typically better than using files, because it's ACID.

Maybe a bunch of people wrote a bunch of scripts that made a bunch of dbs

Did not expect a squeal lite lore dump today.