![]() SQLite is a great little database for all kinds of personal data storage. Not only does it have drivers for all current programming languages, but it also works without the hassle of creating a server to host it. Today I give you a quick overview on 3 no-code tools to explore your SQLite databases.ĭB Browser for SQLite runs on Windows, Mac, Linux and FreeBSD. SQLite Studio is a free and open-source database manager. You can connect to an existing SQLite database or create a new one. SQLite Studio is a handy tool that was designed in order to assist you in managing the contents of your SQLite databases. Steps to install SQL on both Windows and Linux environment, Creating your first table. To view the data in your table, right-click on the table and select “ Browse Table” or go to the “ Browse Data” tab and select your table in the drop-down list: A speciality of this tool is the create table script you find next to each table: The database structure tab gives you an overview on your tables and indices. SQLiteStudio is very similar to DB Browser for SQLite. It runs on Windows, Mac and Linux with a more polished user interface and a higher update frequency. Download the binary package, and then unpack it with: tar xvf sqlstudio-X.Y.Z.tar.xz where X.Y.Z is the version number 3.0.7 at the time of writing and SQLiteStudio is ready to use. As I tried it the first time, I was a bit annoyed for the extra step to run the generated SELECT script. SQLiteStudio is available via the project website 2 in the form of 32-bit or 64-bit binaries for Linux, Mac OS X, and Windows, as well as a source tarball. With a bit more time to learn the tool I found the “ Data” tab that shows you the rows in your table without a detour to SQL:ĭataGrip from JetBrains allows you to access a wide range of database systems from various vendors. It also runs on Windows, Mac and Linux but offers significantly more features. Those extra features come at the price of €89.00 for the first year. If this is done, you can access your database: It is the only tool of the 3 that needs the extra step of downloading the driver to access your SQLite database. ![]() Select the database, then go to Diagrams | Show Visualization to see how your tables are connected (or not): One of the many helpful tools in DataGrip is the ER diagram viewer. The Northwind example database is not the most interesting one for this feature. Unfortunately, I do not yet have a more interesting example I can show you.Īll 3 tools do a good job to access your data in an SQLite database.
0 Comments
Leave a Reply. |