fun fact: SQLite is the most deployed and most used database. There are over one trillion (1e12) SQLite databases in active use.
— v (@iavins) March 31, 2024
It is maintained by three people. They don't allow outside contributions.
Sqlite tops 1 trillion instances
https://x.com/iavins/status/1774464622067679738
- 46
- 38
Jump in the discussion.
No email address required.
Also they have a crazy comprehensive test suite. The most prominent project running on sqlite is a bot for rdrama called bard_bot
Jump in the discussion.
No email address required.
A less prominent one is crosstalk pm, and soon oregon trail
Jump in the discussion.
No email address required.
More options
Context
More options
Context
iirc the soys chimped out at their code of ethics because of the christianity references lmao: https://sqlite.org/codeofethics.html
Jump in the discussion.
No email address required.
!chuds check out this wrongthink from a year ago:
https://old.reddit.com/r/programming/comments/vljfp3/the_sqlite_code_of_ethics/idzftlc/?context=8
Amazing it didn't get mopped
Jump in the discussion.
No email address required.
More options
Context
I think that was a joke picking fun of CoCs.
Jump in the discussion.
No email address required.
probably but you'll find people getting mad at it lol
https://old.reddit.com/r/programming/comments/vljfp3/the_sqlite_code_of_ethics/
https://old.reddit.com/r/linux/comments/mniddp/til_that_sqlite_has_a_religious_code_of_ethics/
Jump in the discussion.
No email address required.
More options
Context
It's the best kind of joke, the one that's also serious.
Jump in the discussion.
No email address required.
More options
Context
yeah there was a period of time where every small project was getting blasted if it didn't have a code of conduct saying they wouldn't oppress bipocs or whatever
Jump in the discussion.
No email address required.
More options
Context
CoCs are a joke, if someone could make something in a hot path twice as fast I wouldn't give a shit about their ethics
Jump in the discussion.
No email address required.
More options
Context
I think that they write somewhere that it's a box-checking exercise for organizations that want them to include a copy of their "code of conduct" or equivalent. Might as well have a little fun with it.
Jump in the discussion.
No email address required.
More options
Context
More options
Context
More options
Context
sqlite is the GOAT
95% of the time the average person or business doesn't need anything more than sqlite
Jump in the discussion.
No email address required.
Jump in the discussion.
No email address required.
Skill issue
Jump in the discussion.
No email address required.
More options
Context
you can use an orm
Jump in the discussion.
No email address required.
Jump in the discussion.
No email address required.
More options
Context
bloat
Jump in the discussion.
No email address required.
More options
Context
More options
Context
More options
Context
I heard sqlite did some weird shit so I use duckDB instead since it's apparently the same thing, but better
https://duckdb.org/
Jump in the discussion.
No email address required.
What weird shit? By all accounts it's an amazing project.
Jump in the discussion.
No email address required.
IT'S TRANSPHOBIC!
Jump in the discussion.
No email address required.
More options
Context
I never dug whole file locking. I get it, but i hate it... i have to build my own controller to do io
Jump in the discussion.
No email address required.
More options
Context
Something to do with types being weird I can't entirely remember
Jump in the discussion.
No email address required.
More options
Context
More options
Context
Are you talking about sqlite's dramapilled Code of Ethics?
https://sqlite.org/codeofethics.html
Jump in the discussion.
No email address required.
Holy fricking based
Jump in the discussion.
No email address required.
More options
Context
No wonder it pissed off the ledditors.
Jump in the discussion.
No email address required.
More options
Context
Jump in the discussion.
No email address required.
More options
Context
This makes me feel like monks code sqlite in a monestary.
Jump in the discussion.
No email address required.
It's actually written in Holy C
Jump in the discussion.
No email address required.
More options
Context
More options
Context
It has a code of ethics?
Jump in the discussion.
No email address required.
More options
Context
More options
Context
!codecels is duckdb any good?
Jump in the discussion.
No email address required.
it's better if you're doing large searches of unindexed data
Jump in the discussion.
No email address required.
Is it good if I'm doing a small search of indexed data?
Jump in the discussion.
No email address required.
no sqlite is better for that
Jump in the discussion.
No email address required.
What about when your indexed and unindexed data needs to be searched together?
Jump in the discussion.
No email address required.
More options
Context
More options
Context
More options
Context
More options
Context
never heard aboot it
Jump in the discussion.
No email address required.
Ya neither have i and i aint clicking on it to figure out why. Sqlite is like default in php and only a touch behind it in other languages. Super easy to pick up
Jump in the discussion.
No email address required.
More options
Context
More options
Context
I find it very useful to chew through large csv files. Much more convenient than writing a one-time python script to manipulate the data
Jump in the discussion.
No email address required.
More options
Context
It's great for dealing with data sources that are different format and schema. I don't know about using it as an actual DB though.
Jump in the discussion.
No email address required.
More options
Context
yes yes yes yes god yes it's so good use it use it use it.
it's like sqlite+++ for OLAP/data analysis
USE IT
Jump in the discussion.
No email address required.
Huh, looks like I r-slurred into picking the right technology.
Jump in the discussion.
No email address required.
More options
Context
More options
Context
More options
Context
More options
Context
I have no experience with it because every library that interacts with a database allows you to use a real DB instead if you're capable of typing
docker run postgres
into your terminalJump in the discussion.
No email address required.
More options
Context
More options
Context
Kind of freaky imagining how much of the world economy depends even if slightly so on these three losers doing this job
Jump in the discussion.
No email address required.
More options
Context
It's hard to believe it's possible to be so mid-90s IQ that you'd use e-notation for a 12 digit number to look smart, but it really does happen
Jump in the discussion.
No email address required.
Came here looking for the comment pointing this out, left satisfied.
Jump in the discussion.
No email address required.
More options
Context
I hate e notation so much
Jump in the discussion.
No email address required.
More options
Context
even chemists hate using e notation academically
Jump in the discussion.
No email address required.
More options
Context
More options
Context
What is it about Apple that makes chuds seethe so much? Is it envy?
To add more salt in the wounds of these chuds… did Apple just BTFO all the chud's iToddler bullshit?
How do (You) refute all these arguments? They literally actually have the brain to back their arguments up instead of the chud "iTODDLER" + red hair tranime pics.
Actually refute these arguments… I'll wait.
Snapshots:
https://x.com/iavins/status/1774464622067679738:
ghostarchive.org
archive.org
archive.ph (click to archive)
Jump in the discussion.
No email address required.
More options
Context