![]() ![]() Tip : If you could not find the file there, use the “locate” statement to determine the location of “libsqlite3.so.0”. You’ll now find the SQLite library in the following location: /usr /lib /i386-linux-gnu /libsqlite3.so.0 (Note: for Raspberry Pi 2 model B /usr /lib /arm-linux-gnueabihf /libsqlite3.so.0): Sudo apt-get install sqlite3 libsqlite3-dev You also have to keep in mind that, unlike more advanced SQL servers, you manually have to commit changes. Single User implies that the database file can be opened by one application at a time only. I did a lot of testing with different database engines, but SQLite is clearly the winner when you’re looking for a tiny single user SQL based database engine available that is available on multiple platforms.įirst of all, SQLite stores all it’s data in a single file and is intended for single user only – as with most embedded SQL engines. ![]() SQLite can be found on numerous platforms, anything from Android, Apple MacOS X, Apple iOS, Microsoft Windows, Linux, etc. Both of these actually have an embedded version as well, but are much more complex to install and use, much more resource hungry and not as widely supported as one would hope. Typical use of SQLite is when you’d like to use an SQL database to store application data without the need to run a large SQL database like for example MySQL (my favorite) or FireBird. ![]() Airbus even uses it planes (for more famous users see Well-Known SQLite users). Well known companies like Apple, Adobe, Microsoft, Skype, Mozilla, and Google use SQLite for some of their products. SQLite is a small SQL database engine used in more applications than you’d think – you’re probably using SQLite already without even knowing it.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |