[a / b / c / d / e / f / g / gif / h / hr / k / m / o / p / r / s / t / u / v / vg / vm / vmg / vr / vrpg / vst / w / wg] [i / ic] [r9k / s4s / vip] [cm / hm / lgbt / y] [3 / aco / adv / an / bant / biz / cgl / ck / co / diy / fa / fit / gd / hc / his / int / jp / lit / mlp / mu / n / news / out / po / pol / pw / qst / sci / soc / sp / tg / toy / trv / tv / vp / vt / wsg / wsr / x / xs] [Settings] [Search] [Mobile] [Home]
Board
Settings Mobile Home
/g/ - Technology


Thread archived.
You cannot reply anymore.


[Advertise on 4chan]


File: sqlite.jpg (42 KB, 314x680)
42 KB
42 KB JPG
HAPPENING: SQLite finally makes it to beta!

will this software ever become usable? or will it remain a free softwarre toy project database forever?
>>
>>106758877
It’s a one man effort so I guess it will reach nirvana when that person dies and then it will slowly fade away replaced by slower and less effective alternatives
>>
Are you sure you're on the official SQLite Git?

https://github.com/sqlite/sqlite
>>
>>106758877
That says it's Turso DB, whatever that is. SQLite is fully usable and stable
>The SQLite file format is stable, cross-platform, and backwards compatible and the developers pledge to keep it that way through the year 2050.
When did this board get so retarded
>>
Where do people even discuss databases here, or there's nothing to discuss?
>>
>>106762395
>Where do people even discuss databases here
Sometimes in /wdg/.

>or there's nothing to discuss?
The correct answer in 99.999% of the cases is "SQLite or Postgres". Start out with SQLite and move on to Postgres if you have a lot of concurrent writes. SQLite is going to be the best option in most cases because it's going to be the most performant and the simplest.
>>
>>106762840
Cool, thank you!
>>
>>106758877
huh never knew. seems to be used everywhere
>>
>>106758877
https://sqlite.org/testing.html
sqlite is one of the most reliable services you will ever run
>>
SQOWNED
>>
>>106758877
just use postgres
>>
>>106761546
it will be released next week, it's not yet official
>>
>>106758877
wtf didnt know it was still in alpha ive been using it in production system for like 8 years or something its based
>>
>>106758877
>OP is a lying nigger faggot or mentally retarded
another shit thread I see.
>>
>>106762840
Even in write heavy, it has to basically be all writes til it becomes a huge problem and usually you can cope with batching techniques. I agree with this overall though. Postgres is the next logical step. After Postgres, you could just use some other cloud db because anything more complex than Postgres on a giga machine is too complex to manage unless you have godly IT staff.
>>
OP forgot to explain the joke so i'll help you faggots out
he's purposefully talking about SQLite but shows screenshot of Turso
Turso is a full from scratch rewrite of SQlite in /g/'s favorite language
>>
>>106767078
>in /g/'s favorite language
emacs lisp?
>>
>>106767086
that's right
>>
>>106762883
it's not even a service. the database is just a single file, it's really convenient
>>
>>106765608
>I made it up



[Advertise on 4chan]

Delete Post: [File Only] Style:
[Disable Mobile View / Use Desktop Site]

[Enable Mobile View / Use Mobile Site]

All trademarks and copyrights on this page are owned by their respective parties. Images uploaded are the responsibility of the Poster. Comments are owned by the Poster.