![sqlpro for sqlite index sqlpro for sqlite index](https://static.macupdate.com/screenshots/286415/m/sqlpro-for-sqlite-screenshot.png)
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. ($2.99) SQLiteFlow is a very great GUI tool for SQLite on macOS. If you purchase via our, 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. Tables can be imported & exported from/as CSV, XML or JSON.Ī query history browser so that you may see queries run in the past. 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. The ability to run multiple queries at one time (and a customizable run query shortcut). Customizable themes allowing the query editor to be completely customized. Syntax highlighting & Autocomplete (sometimes called intellisense). Some of the neat features it includes are.
#SQLPRO FOR SQLITE INDEX MAC OS X#
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. 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.