Any long term plans to add MySQL support?

[danielrosehill]

Hi everyone,

Thought I'd open this up as a discussion.

I've always had the impression that SQ Lite is best avoided for "serious" applications although the all-knowing-oracle (taht's my nickname for ChatGPT) lately set me straight, informing that SQ Lite is actually more scalable than is commonly perceived and even used in avionics.

So I guess, as always, we have two lines of thought:

1. If it ain't broken, don't fix it. So far, I've found the default implementation to be very performant and nothing seems out of sorts.

2. I would still probably feel more confident in having a MySQL DB just because ... I just inherently trust MySQL and Postgres more and know my way around basic scripting for them.

Perhaps as a middle ground there could be a separate docker compose for MySQL for those who wanted to go down that direction.

In any event ... thought I'd put it out there for consideration. Not a pressing priority for me, but wouldn't mind working on a feature "down the road" if others saw potential value.

[101br03k]

It is being developed, check out the pr #332 or the branch nvext-storage

[tankerkiller125]

To be specific we will support Postgres, MySQL support simply isn't reasonably supportable given 2 formats will already be pain enough, plus it seems like the Go implementation of MySQL isn't all there/a real PITA from what I could find when I was working on trying to implement it.

[thevortexcloud]

informing that SQ Lite is actually more scalable than is commonly perceived

This is "wrong". It really depends on what you mean by "scalable". SQLite runs entirely locally in memory (which is possibly a good thing as well). Which means it can't be scaled up across many machines like large distributed databases can be (and therefore lacks fancy features like eventual consistency, load balancing, etc). Which also means it can't handle millions of requests a second (unless you have some very powerful computer to run it on). But for the vast majority of use cases people use it for, it's fine. It's fully ACID compliant as well.

even used in avionics.

It's used everywhere because of how easy it is to use. You don't have to fiddle with setting up servers and what not, or even accounts. It just works. Every single android device for example has native support for it.

https://developer.android.com/training/data-storage/sqlite

just inherently trust MySQL and Postgres more and know my way around basic scripting for them.

ANSI SQL should work in all SQL databases. But knowing what extensions each provides can be very useful.

[tankerkiller125]

ANSI SQL should work in all SQL databases. But knowing what extensions each provides can be very useful.

Except for the fact that SQLite does not support updating tables, but instead you have to create a new one, copy all the data to the new table, and then delete the original table, and finally rename the new table to the old table name.... And there are a bunch of other weird oddities with SQLite that I've seen and encountered working with it.

[thevortexcloud]

Which is why I said should. Not all databases follow ANSI for various reasons. But in general you can assume they do. Anyway, renaming tables should work fine on any modern version of SQLite https://www.sqlite.org/lang_altertable.html

[tankerkiller125]

Postgres support is now released as part of v0.18.0