As I tried it the first time, I was a bit annoyed for the extra step to run the generated SELECT script. 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. If you just want to work with SQLite, DB Browser for SQLite and SQLiteStudio are good choices. Both tools offer similar features for the casual user and do not require any preparation to access your database. The more you want to do, the more I suggest you use SQLiteStudio.ĭataGrip is a good choice if you work with many different database vendors or you do that much work that the massive feature list is an asset and not an obstacle. In my opinion you need to learn too much for just accessing SQLite. However, that initial effort is quickly compensated when you just need to learn one tool instead of 3 or 4.Īll 3 tools allow you look into your SQLite database. If one tool does not fit your needs, do not hesitate, and take another one. The great benefit of having multiple tools to your disposal is that we do not need to work with tools that stand in our way.Summary: in this tutorial, you will learn step by step on how to download and use the SQLite tools to your computer. To download SQLite, you open the download page of the SQlite official website. SQLite provides various tools for working across platforms e.g., Windows, Linux, and Mac. You need to select an appropriate version to download.įor example, to work with SQLite on Windows, you download the command-line shell program as shown in the screenshot below. The downloaded file is in the ZIP format and its size is quite small. Installing SQLite is simple and straightforward. First, create a new folder e.g., C:\sqlite.Second, extract the content of the file that you downloaded in the previous section to the C:\sqlite folder.Quit c:\ sqlite> Code language: CSS ( css ) Install SQLite GUI tool You should see three programs in the C:\sqlite folder as shown below: However, sometimes, you may want to work with the SQLite databases using an intuitive GUI tool. There are many GUI tools for managing SQLite databases available ranging from freeware to commercial licenses. The SQLiteStudio tool is a free GUI tool for managing SQLite databases.
0 Comments
Leave a Reply. |