I’m going to make more tutorials on how to use this SQLite database, soon. Pressing Connect, the connection was successfully created:Īnd I can see the file created in that folder, with zero KB of size: This is radically different from PostgreSQL, and MySQL and other big DBMS. SQLite is pretty cool because the database is contained in a file, which you can put pretty much everywhere you want. I choose test.db, in the /Users/flaviocopes/ folder: You select a name, and type a database path. You create a new connection, choosing SQLite: I know there are macOS, Windows and Linux versions. It comes with a free trial that’s perfect for our usage, because it’s not time-based but rather it limits the amount of concurrent connections you can make to the database.ĭownload it from. DB4S uses a familiar spreadsheet-like interface, and complicated SQL commands do not have to be learned. DB4S is for users and developers who want to create, search, and edit databases.
You can upgrade SQLite using Homebrew, but for the sake of simplicity, I’m not going to cover this.Ī great software we can use to interact with a SQLite database is TablePlus. DB Browser for SQLite (DB4S) is a high quality, visual, open source tool to create, design, and edit database files compatible with SQLite. My macOS with Mojave comes with SQLite 3.24, and the latest version (at the time of writing) is SQLite 3.30. This is a feature that once you found it exists, you can't leave it!įor me, as a iOS developer, SQLiteFlow help me deal with SQLite database in iOS simulator seamlessly without need to handle the fact that a same file (SQLite database) 's path in iOS simulator is changeable.Press ctrl-C 2 times to exit the SQLite executable. You need to select an appropriate version to download. Handle database file name or directory changes automatically. SQLite provides various tools for working across platforms e.g., Windows, Linux, and Mac.
And it also allows you copy the data in data viewer to CSV.Ī query editor which support code auto completion, syntax highlighting, format query, copy query to almost any language's quoted string after some configuration.Īn alter table GUI tool which can help you maintenance your database structure without any pain to write alter table query, instead it can generate the query for you after you tell SQLiteFlow in UI that what need to be changed.Īttach opened databases directly through UI is a useful feature if you deal with attaching database thing in your daily work, very convenient, save your time from writing ATTACH DATABASE commands. A data viewer which allows you view, edit, add or search table's data directly through UI without any code.It has features that most SQLite editors or managers that suppose to have. SQLiteFlow is a very great GUI tool for SQLite on macOS. If you purchase via our webstore, use the promo code STACK25 to save 25%. There is a seven day trial available via the website. The results grid can be searched (either via the Cmd - F keyboard shortcut or by right clicking the results grid and choosing find).Favourite queries can be stored and reused.A query history browser so that you may see queries run in the past.Tables can be imported & exported from/as CSV, XML or JSON.SQLPro for SQLite allows you to add/update/delete:
When primary keys are detected you can update results & delete rows directly from the grid. Primary key detection in the query results.
Some of the neat features it includes are: You may like my app SQLPro for SQLite ( App Store).