Pay attention to what the AUTHORS of SQLITE tell you
Literally over & over DO NOT DO THIS DO NOT RELY ON IT
4 Likes
I’ve talked myself hoarse in that forum.
- You don’t connect directly to a database if you don’t have 100% control over the transport path.
- You never insert variables directly into an SQL string. Ideally, you never write raw SQL at all - because you’re using a good framework that abstracts it away.
- You don’t use SQLite over a network (unless you build an API for it).
- You learn how a database actually works before you start coding against it.
Unfortunately, that’s when all the self-proclaimed gods show up and insist that everything is completely different.
That’s why I just don’t post there anymore and leave them to their little paradise where everything is peaceful and perfect.
1 Like
He has it on a network drive like a drive of an internal file server / NAS System. This makes already a problem with sqlite. Exactly that. Nobody would place an sqlite database onto a public running server. For what? Makes no sense.
They want an easy way to share it
And sqlite EXPLICITLY says “do not do this it WILL eventually corrupt your database”
Just like the person experienced
Sometimes you cannot tell a person that it will break
They have to see it for themselves
And then when it does you’re a baddy for saying “See ! They told you so”
1 Like