Sqlite tops 1 trillion instances

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

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.

Skill issue

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.

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