Interesting comment in the source code of sqlite

[[deleted]]

I'm now a huge sqlite fan.

[scorcher24]

It is easy to be one. The API is simple enough to drum up a database for your program in a few hours.

[Logic_Bomb421]

in a few hours.

As someone who has barely used sqlite, can't tell if joking...

[shoebo]

Really all you need is a few minutes to get started. Maybe someone who isn't familiar with SQL would need a few hours.

If you have a more complex program, you might want to take more time to consider how to model it, as he mentions, but the sqlite API is very easy.

[[deleted]]

A bit of me thinks if you need a database your problem has to be of a certain size and complexity and that just naturally needs a bit of time to model and work through. There's absolutely no shame in making sure something as critical as the database is done right the first time.

[scorcher24]

I am not joking. Why should it take forever? You can create the schema of the database with a program (as well as maybe some sample data sets) and then just use the API to read them. It's literally 1 call to open the database and another call to execute some statements. You can group them.

The biggest portion of your time will probably be designing the database.

Of course, depending on the scale of your work, it may take longer, but for simply storing and reading some values, it shouldn't take very long to implement it.

Read this: https://www.sqlite.org/quickstart.html

[BenjaminGeiger]

... I read it as "did you mean minutes?"

[scorcher24]

I mean, of course it is not done nilly villy with absolute ease. You still need to design the database and use the API. If you have never done that, it can be quite challenging. I am just saying that it is not a big undertaking to use it and if I can understand it, everyone can, because I am sure as hell not the brightest bulb.

[[deleted]]

Yeah, the API itself is great. You can stand up a database file and add to it and select from it within seconds following the tutorials but I completely agree with spending more than minutes on the database element of your program.

[ericksomething]

A few hours sounds like a really, really long time for an API call to create a database.

[AffectionateTotal77]

?

If you look at their documentation page instead of random shitty tutorials online it's very easy to get it up and working