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
- 46
- 38
Top Poster of the Day:
J
Current Registered Users: 25,739
tech/science swag.
Guidelines:
What to Submit
On-Topic: Anything that good slackers would find interesting. That includes more than /g/ memes and slacking off. If you had to reduce it to a sentence, the answer might be: anything that gratifies one's intellectual laziness.
Off-Topic: Most stories about politics, or crime, or sports, unless they're evidence of some interesting new phenomenon. Videos of pratfalls or disasters, or cute animal pictures. If they'd cover it on TV news, it's probably lame.
Help keep this hole healthy by keeping drama and non-drama balanced. If you see too much drama, post something that isn't dramatic. If there isn't enough drama and this hole has become too boring, POST DRAMA!
In Submissions
Please do things to make titles stand out, like using uppercase or exclamation points, or saying how great an article is. It should be explicit in submitting something that you think it's important.
Please don't submit the original source. If the article is behind a paywall, just post the text. If a video is behind a paywall, post a magnet link. Fuck journos.
Please don't ruin the hole with chudposts. It isn't funny and doesn't belong here. THEY WILL BE MOVED TO /H/CHUDRAMA
If the title includes the name of the site, please leave that in, because our users are too stupid to know the difference between a url and a search query.
If you submit a video or pdf, please don't warn us by appending [video] or [pdf] to the title. That would be r-slurred. We're not using text-based browsers. We know what videos and pdfs are.
Make sure the title contains a gratuitous number or number + adjective. Good clickbait titles are like "Top 10 Ways to do X" or "Don't do these 4 things if you want X"
Otherwise editorialize. Please don't use the original title, unless it is gay or r-slurred, or you're shits all fucked up.
If you're going to post old news (at least 1 year old), please flair it so we can mock you for living under a rock, or don't and we'll mock you anyway.
Please don't post on SN to ask or tell us something. Send it to [email protected] instead.
If your post doesn't get enough traction, try to delete and repost it.
Please don't use SN primarily for promotion. It's ok to post your own stuff occasionally, but the primary use of the site should be for curiosity. If you want to astroturf or advertise, post on news.ycombinator.com instead.
Please solicit upvotes, comments, and submissions. Users are stupid and need to reminded to vote and interact. Thanks for the gold, kind stranger, upvotes to the left.
In Comments
Be snarky. Don't be kind. Have fun banter; don't be a dork. Please don't use big words like "fulminate". Please sneed at the rest of the community.
Comments should get more enlightened and centrist, not less, as a topic gets more divisive.
If disagreeing, please reply to the argument and call them names. "1 + 1 is 2, not 3" can be improved to "1 + 1 is 3, not 2, mathfaggot"
Please respond to the weakest plausible strawman of what someone says, not a stronger one that's harder to make fun of. Assume that they are bad faith actors.
Eschew jailbait. Paedophiles will be thrown in a wood chipper, as pertained by sitewide rules.
Please post shallow dismissals, especially of other people's work. All press is good press.
Please use Slacker News for political or ideological battle. It tramples weak ideologies.
Please comment on whether someone read an article. If you don't read the article, you are a cute twink.
Please pick the most provocative thing in an article or post to complain about in the thread. Don't nitpick stupid crap.
Please don't be an unfunny chud. Nobody cares about your opinion of X Unrelated Topic in Y Unrelated Thread. If you're the type of loser that belongs on /h/chudrama, we may exile you.
Sockpuppet accounts are encouraged, but please don't farm dramakarma.
Please use uppercase for emphasis.
Please post deranged conspiracy theories about astroturfing, shilling, bots, brigading, foreign agents and the like. It degrades discussion and is usually mistaken. If you're worried about abuse, email [email protected] and dang will add you to their spam list.
Please don't complain that a submission is inappropriate. If a story is spam or off-topic, report it and our moderators will probably do nothing about it. Feed egregious comments by replying instead of flagging them like a pussy. Remember: If you flag, you're a cute twink.
Please don't complain about tangential annoyances—things like article or website formats, name collisions, or back-button breakage. That's too boring, even for HN users.
Please seethe about how your posts don't get enough upvotes.
Please don't post comments saying that rdrama is turning into ruqqus. It's a nazi dogwhistle, as old as the hills.
Miscellaneous:
We reserve the right to exile you for whatever reason we want, even for no reason at all! We also reserve the right to change the guidelines at any time, so be sure to real them at least once a month. We also reserve the right to ignore enforcement of the guidelines at the discretion of the janitorial staff. Be funny, or at least compelling, and pretty much anything legal is welcome provided it's on-topic, and even then.
Do not use outdated operating systems that are unsupported to access SN. What are you, poor?
[[[ To any NSA and FBI agents reading my email: please consider ]]]
[[[ whether defending the US Constitution against all enemies, ]]]
[[[ foreign or domestic, requires you to follow Snowden's example. ]]]
/h/slackernews LOG /h/slackernews MODS /h/slackernews EXILEES /h/slackernews FOLLOWERS /h/slackernews BLOCKERS
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&sort=controversial
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.
Follower of Christ Tech lover, IT Admin, heckin pupper lover and occasionally troll. I hold back feelings or opinions, right or wrong because I dislike conflict.
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/?sort=controversial
https://old.reddit.com/r/linux/comments/mniddp/til_that_sqlite_has_a_religious_code_of_ethics/?sort=controversial
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
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.
Follower of Christ Tech lover, IT Admin, heckin pupper lover and occasionally troll. I hold back feelings or opinions, right or wrong because I dislike conflict.
Jump in the discussion.
No email address required.
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://twitter.com/iavins/status/1774464622067679738:
ghostarchive.org
archive.org
archive.ph (click to archive)
Jump in the discussion.
No email address required.
More options
Context