It's a far cry from the other graphical tools mentioned here, but I've found that I prefer interacting with my SQLite databases with the built-in command line tool, sqlite3: $ sqlite3 test.db SQLite version 3.6.12 Enter '.help' for instructions Enter SQL statements terminated with a ';' sqlite create table test (a, b); sqlite insert into test values (2, 3); sqlite insert into test values (4, 3); sqlite insert into test values (4, 5); sqlite select. from test where a.schema CREATE TABLE test (a, b); The best part is that it's built into Mac OS X and is completely, 100% free. (No seriously, the code is in the ). You may like my app. Some of the neat features it includes are:.
Syntax highlighting & Autocomplete (sometimes called intellisense). Customizable themes allowing the query editor to be completely customized. The ability to run multiple queries at one time (and a customizable run query shortcut).
Primary key detection in the query results. When primary keys are detected you can update results & delete rows directly from the grid.
Sqlite database is saved in.db,.db3,.sqlite, or.sqlite3 file, depending upon the application in use. The sqlite forensics browser will examine the sqlite database structure and will give preview of data saved in it. Sqlite database of any platform can be investigated.
Errors in queries will be underlined. There is a full schema designer.
SQLPro for SQLite allows you to add/update/delete:. Tables. Indexes.
Foreign Keys and. Triggers In addition:. Tables can be imported & exported from/as CSV, XML or JSON. A query history browser so that you may see queries run in the past. Favourite queries can be stored and reused. The results grid can be searched (either via the Cmd - F keyboard shortcut or by right clicking the results grid and choosing find).
There is a seven day trial available via the website. If you purchase via our, use the promo code STACK25 to save 25%.
Disclaimer: I'm the developer. ($2.99) SQLiteFlow is a very great GUI tool for SQLite on macOS. It's intuitive, stable and reliable. It has features that most SQLite editors or managers that suppose to have. Including:. A data viewer which allows you view, edit, add or search table's data directly through UI without any code. And it also allows you copy the data in data viewer to CSV.
A query editor which support code auto completion, syntax highlighting, format query, copy query to almost any language's quoted string after some configuration. An 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. Attach 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. Handle database file name or directory changes automatically.
This is a feature that once you found it exists, you can't leave it! For 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.
Base is an application for creating, designing, editing and browsing SQLite 3 database files. It's a proper Mac OS X application. Fast to launch, quick to get in to and get the data you need.
Base starts with all the basic features you need:. Schema viewing. Table contents viewing/editing.
Custom SQL queries. Command logging Then makes it all even better:. Support for viewing and editing ALL column- and table-level constraints. From simple default values, to complex foreign keys, Base can handle it. Advanced table designing and altering.
No need to manually type CREATE TABLE statements, from a single sheet you can add, edit and remove columns & constraints to your heart's content, maintaining or moving the original data within them. Quick data find & filter. Build lengthy SELECT statements with a few clicks, previewing results as you go.
Easy SQL editing, with clear syntax highlighting and useful SQL autocompletion. Store your commonly used SQL as snippets for easy re-use later. Easy import, comprehensive export. Bring in data from CSV or SQL files. Export to SQL, delimited text, XML or Microsoft Excel-compatible formats. This is primarily a bug-fix release.
This is primarily a bug-fix release. Changes include:. Failed CSV imports now report where and why failure occurred. Tabbing between fields in the data browser now wraps from line to line. Tables where a column name is an unquoted SQL keyword now display correctly. Table list filtering no longer loses focus after each keystroke. Table list filtering is now case insensitive.
The custom SQL split view now remembers its last position. The applicationid pragma can now be viewed and set in the database options. Updated SQLite to 3.7.17. 2.4.4 May 17, 2013.
⚠ This is an important update! Read on for details. There was a bug in the previous version of Base which prevented users running Mac OS 10.7 from making changes to their databases. This update fixes that problem by temporarily removing sandboxing from Base.
If you are running 10.7, you really should update to this version. The next update will require Mac OS 10.8 or higher as Base will re-enable sandboxing. This update will come within the next two months, so please do download this version soon.
If you have any queries, please email [email protected] Other changes:. Trying to open a file that is not a database now shows an error instead of crashing. Fixed a bug causing the string 'NULL' to be displayed as a null icon. Fixed a bug where entering 'NULL' into a field would result in a string being saved instead of a true null. Fixed a bug where constraints containing an empty string would stop the table schema being fully displayed.
Custom SQL query results now have alternating background colours like other tables. 2.4.2 Jan 2, 2013. Base 2.4.2 is a bugfix release. Users on Mac OS 10.7 (Lion) should.not. update to 2.4 as it contains a crash-on-launch bug. Please wait for 2.4.1 which fixes this problem. Users on 10.8 (Mountain Lion) are not affected by this problem.
Base 2.3.1 is a bugfix release. Added retina-quality icons. Fixed a crash when toggling the snippets view. Corrected a graphical glitch when toggling the snippets view. Fixed a bug causing the last parenthesis of an SQL statement to not be displayed. Fixed a crash when using undo in the custom SQL view.
Constraint popovers will now be in the right place on MacBook Pro with Retina Display. Improved the speed of operations which load table schema Please note that this will be the last update to support 10.6. Future updates will require 10.7 or higher.
2.3 Mar 24, 2012. Base 2.2.1 is a bugfix release. Massively improved table schema parsing reliability and speed. This fixes several schema display bugs. Data viewers now auto-detect data types and show the appropriate preview type.
BLOB data type is now auto-detected where possible and the proper file extension/icon shown ready for dragging. BLOB data in the data browser is now shown as a placeholder icon. Filtering of NULL values in the data browser now behaves correctly. Improved display of NULL values.
Check out the app preferences for details. Base 2.0.2 is primarily a bugfix release:. Enabled support for the SQLite R.Tree module. Fixed a hang which occurred when selecting certain tables. Larger font sizes no longer cause clipped text in the autocomplete box.
Editing and dropping of shadow tables is now not possible through the interface (note that if you want to, you can still shoot yourself in the foot by running the SQL yourself). Editing the default value for a column no longer nests quotes repeatedly. Schemas with identifiers in backticks are now parsed correctly. 2.0.1 Mar 10, 2011. Base 2.0 is a major upgrade, free for all Mac App Store users! Nff22d7, Base 2.0 is a fantastic SQLite GUI It is a major improvement over the 1.x version in speed. It nicely handles 1M+ record SQLite files now.
It now has more sophisticated features such as column renames and schema changes (these are not natively supported in SQLite, so they have to be explicitly programmed by the developer; it's a real timesaver over manually recreating a db). I find that I turn to it for all the SQLite files I handle now.
It's a nice, simple, clean, fast SQLite GUI. And the price is awesome! I'll throw in one suggestion; allow NULL fields not only to be marked with user selectable text, but also a user selectable background color; I find that makes it much easier to browse through to see where the nulls are instead of WHERE 'foo' IS NULL queries. Nff22d7, Base 2.0 is a fantastic SQLite GUI It is a major improvement over the 1.x version in speed. It nicely handles 1M+ record SQLite files now.
It now has more sophisticated features such as column renames and schema changes (these are not natively supported in SQLite, so they have to be explicitly programmed by the developer; it's a real timesaver over manually recreating a db). I find that I turn to it for all the SQLite files I handle now. It's a nice, simple, clean, fast SQLite GUI. And the price is awesome!
I'll throw in one suggestion; allow NULL fields not only to be marked with user selectable text, but also a user selectable background color; I find that makes it much easier to browse through to see where the nulls are instead of WHERE 'foo' IS NULL queries. Kerri Shotts, Latest Version feels Quirky There's some problems that I've been running into in the latest version that are frustrating to get around. For example, if there's an error in the SQL, the app warns you, but you can't dismiss the dialog, which means you have to quit the entire app. There's abundnant quirkiness when creating tables (field names not being saved, not remembering column attributes); so much so that I finally gave up and did it via commandline.
So it's a nice app for viewing your data and simple interaction, but not for playing around with SQL statements or anything advanced. Which is unfortunate, because I really, really, really like the app. Kerri Shotts, Latest Version feels Quirky There's some problems that I've been running into in the latest version that are frustrating to get around. For example, if there's an error in the SQL, the app warns you, but you can't dismiss the dialog, which means you have to quit the entire app.
There's abundnant quirkiness when creating tables (field names not being saved, not remembering column attributes); so much so that I finally gave up and did it via commandline. So it's a nice app for viewing your data and simple interaction, but not for playing around with SQL statements or anything advanced. Which is unfortunate, because I really, really, really like the app.
Eric Summers, Best sqlite database tool! This is the best sqlite schema and data editor for OS X! I like the attention to detail. My only issue at the moment is that I need the embedded SQLite updated to 3.8.2 so I can use the new “WITHOUT ROWID” option.
3.8.1 will not open databases with that feature enabled. It would also be nice if there was a way to install a plugin containing a custom build of SQLite so that user built extensions (virtual tables or custom functions) will work properly in Base.
That may be the next issue I run in to. Otherwise this is a great product! Eric Summers, Best sqlite database tool! This is the best sqlite schema and data editor for OS X! I like the attention to detail. My only issue at the moment is that I need the embedded SQLite updated to 3.8.2 so I can use the new “WITHOUT ROWID” option. 3.8.1 will not open databases with that feature enabled.
It would also be nice if there was a way to install a plugin containing a custom build of SQLite so that user built extensions (virtual tables or custom functions) will work properly in Base. That may be the next issue I run in to. Otherwise this is a great product!
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |