Hello database experts.
I'm a self-taught programmer and my knowledge in database programming is weak. I understand how to use MS Access, TParadoxDataSet and TDbf. I rarely build programs using database and I do not build commercial programs. That's why I usually use TDbf which seems enough for my needs, although I know it has many limitations.
But I'm thinking to learn and use the 'better' options in the future. After some research, it seems SQLite is the best for me. But there are somethings I'm not really understand.
1. How to deploy programs that using SQLite?In this page, it said SQLite needs client lib:
http://wiki.freepascal.org/DatabasesBut in these pages, they said SQLite is zero configuration and no need to deploy any additional library:
http://wiki.freepascal.org/SQLitehttps://sqlite.org/serverless.htmlSo, I'm confused. Which one is correct, or can you please explain how deploy programs that build using SQLite?
2. Is it free for commercial projects?I know SQLite is free, but is it also free for commercial usage? Do we need to pay license if we use it in commercial projects?
3. Is SQLite too overkill?
Programs I built are simply, single user without network connectivity. Sometimes I think SQLite is too overkill. For example, now I planning my game builder program which user can load all needed files (audios, images, etc) from different sources and save them in a single location or database. What do you think? Should I use SQLite or TDbf or write my own module using TZipFile?
4. How is MySQL compare to SQLite?MySQL is very commonly used in web hosting (I'm a web designer). Is it easier or better?
5. Any other suggestion?My requirement is simple:
- Easy deploy, preferable no install and no lib file
- Free, ok if not free for commercial but it should not be expensive