Sqlite tops 1 trillion instances

https://twitter.com/iavins/status/1774464622067679738
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.

iirc the soys chimped out at their code of ethics because of the christianity references lmao: https://sqlite.org/codeofethics.html :soyjaktantrum:

Jump in the discussion.

No email address required.

Jump in the discussion.

No email address required.

I think that was a joke picking fun of CoCs.


Follower of Christ :marseyandjesus: 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.

Jump in the discussion.

No email address required.

It's the best kind of joke, the one that's also serious.

Jump in the discussion.

No email address required.

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.

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.

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.

>sqllite

>not enforcing types by default

:marseyno:

Jump in the discussion.

No email address required.

Skill issue

Jump in the discussion.

No email address required.

you can use an orm :marseyteehee:

Jump in the discussion.

No email address required.

>trusting application devs

:marseypuke:

Jump in the discussion.

No email address required.

bloat

Jump in the discussion.

No email address required.

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 :marseyandjesus: 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.

Something to do with types being weird I can't entirely remember

Jump in the discussion.

No email address required.

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 :marseytom: based :marseyshreddedmanletrentfree:

Jump in the discussion.

No email address required.

The rules encourage users to love God and their neighbors and to forsake overeating, laziness, and grumbling, among other things. L

No wonder it pissed off the ledditors.

:marseyangel:

Jump in the discussion.

No email address required.

:marseykneel: :marseyandjesus:

Jump in the discussion.

No email address required.

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.

It has a code of ethics?

Jump in the discussion.

No email address required.

!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.

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.

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.

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.

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.

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 terminal

Jump in the discussion.

No email address required.

Kind of freaky imagining how much of the world economy depends even if slightly so on these three losers doing this job :marseymindblown:

Jump in the discussion.

No email address required.

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.


:#marseyklennycross:

Jump in the discussion.

No email address required.

I hate e notation so much

Jump in the discussion.

No email address required.

even chemists hate using e notation academically

Jump in the discussion.

No email address required.

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?

>Dismantles arguments about how Macs are useless because “MUH VIDYA”

>Dismantles arguments that iPhones are walled gardens as many methods of sideloading existing

>Explains how ARM architecture allows Macs to perform better than competing Windows devices while using less power

>Explains the entire history of Apple devices BTFOing the competition

>Explains how repairability is the fools strawman issue

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.

>inb4 sage

>inb4 DURRRRRR ITODDLER

>inb4 someone says Linux is superior because muh schïzo privacy feature or like that

Actually refute these arguments… I'll wait.

Snapshots:

https://twitter.com/iavins/status/1774464622067679738:

Jump in the discussion.

No email address required.

Link copied to clipboard
Action successful!
Error, please refresh the page and try again.