SQLite vs PostgreSQL or MySQL

[BrunoBernard-knvt]

I think SQLite is for most use cases for small businesses.

Using WAL journaling you can get around 10K write simultaneously.

Not every saas, has a target to get 1M users. If you are around and below 1K users. You should be fine to do anything that other db can do.

SQLite can do more than you can think of. 🎉

Also... SQLite is so flexible than you can easily migrate to MYSQL or Postgres Later :)

[thunder____]

I think it's worth mentioning that a given SQLite file can only have one active connection at a time, which adds some complication for use on a web server where there may be multiple applications trying to connect to the file at once. It also does not support password protection, so it is not suitable for use with sensitive data on a web server.

[jhh]

Very helpful video. Thanks! Keep at it.

[denysolleik]

Just make sure whatever database you go with supports the types of data you might want to query (and index). I don’t believe JSON and spatial are supported.

[HowWebsite]

I am trying to learn how to build out my own server and run things like appflowy on it. Then share it with a small team to manage projects. Could I interview you? I'm looking for advice.

[codecaine]

I love using python. People are like but it is a slow Language. Most the time the bottlenecks will be the database. Most IO operations are written in C for Python so there is not much performance difference. Then you have other c libraries like numpy, pandas etc... Sometimes I use multiple languages together it just really depends on the project I am working on.

[HomeEngineer-wmfg]

So what does "Better-SQLite"