Good, Bad, or Ugly?
SQLite embedded in your application
Cameron Morgan
Easton Martinez
I do this with C all the time
Parker Howard
Do you ever muck with the internals of SQLite or do you go to Richard Hipp and his crew for that?
Carter Ward
greatest db system ever made
not good for big scale ofc
Ayden Thompson
Why wouldn't I just do it myself?
Aaron Cruz
Very good for desktop stuff or light daemons. If you need something bigger, go PostgreSQL.
Liam Jones
I'd really love to use it in one of my data science or data analysis projects at work but sadly, so far I haven't met a use case where I either needed faster on-disk db performance or didn't have access to a regular database server. I suppose the only valid use cases for SQLite are applications and distributed IoT stuff.
Dominic Moore
Define "big".
An SQLite database is limited in size to 140 terabytes but stores the entire database in a single disk file so the filesystem might be the limiting factor. SQLite can support multiple users at once. It does however lock the whole database when writing, so if you have lots of concurrent writes it is not the database you want.
Christopher Clark
Henry Collins
>SQLite embedded
What does this mean? Like in the binary?
Chase Rogers
David Nelson
Isn't this what most uses for SQlite would be implicitly? What kind of application requires the user to maintain their own database by hand?
Sebastian Parker
I use it for most of my non-web applications, sometimes web stuff too if it's a small site that I know no one besides me and maybe a few friends are gonna be using.
Connor Thomas
There is an SQLite command line client.
>What kind of application requires the user to maintain their own database by hand?
Applications that access PostgreSQL, for example.
Eli Flores
The SQLite developers seem to focus on quality and sound software engineering practices.
youtube.com
Have you ever maintained a long-lived project incorporating SQLite?
Camden Peterson
First years CS studen here. I am currently using SQLite for my Python project. Gonna check the videos in this thread to learn more about it because so far I have just been copy pasting SQLite commands from the internet and want to learn more and make my program inmmune to SQLite injection attacks.
Liam Gutierrez
Nathan Gray
Good. It's estimated to be the most installed piece of software on the planet. Dr. Hipp is a god among men. You're retarded and should be recycled.
Levi Howard
if its just hobby tier "programs". yes its really bad
Joshua Morales
ITT: people who don't build software.
Logan Peterson
Because you would make it worse you idiot.
Joshua Stewart
sqlite.org
Looks pretty amateur lol.
Samuel Lopez
sqlite.org
criticism I've heard: few bad defaults (foreign keys checking, WAL journalling, incremental auto-vacuum, ), can be fixed with pragmas, however pragmas are scoped in application with connection to the database and not embedded in the database file itself.
I'm planning to look on other Hipp's projects:
Fossil SCM - more like a sane subversion than very distributed git, less complex model, comfy features such as subview commits, ad-hoc server, wiki, tickets and bugtracker, central management of all repos on machine; the criticism toward git it that it doesn't really have the notion of main repo
Lemon parser generator - alternative to yacc or bison, allegedly less error-prone, some libs to replace lex as well
Tcl/Tk
Levi Evans
If I need a database, I may as well just use PostgreSQL.
Isaac Fisher
Any decent embeddable db to C program other than sqLite?
unQLite looked nice but people have commented that it's actually shit.
Whitedb looks nice.
Luke Campbell
Why not mysql/mariadb?
Jeremiah Bell
>mysql
nigger
Jason White
This
Nathaniel Rivera
replaced with realm realm.io
Parker Morgan
>commercial dbms
fuck off nigger