10/28/2019 Sqlite Viewer For Mac
DB Browser for SQLite (was SQLite Database Browser) is a high quality, visual, open-source tool to create, design, and edit database files compatible with SQLite. It is for users and developers wanting to create databases, and search and edit data. I need to inspect an SQLite file on Mac. What viewer should I use? Requirements: Free, ideally open source Browse schema, data. Run queries Bonus if updated in near real time when the file is.
You might wish to take a look at (see for details and screenshots). According to, a MacOS version is 'in progress', and you can use 1.3.x series, it's working (quote from there). How does it meet your requirements:. Free, ideally open source: It's free alright, and its. Browse schema, data: Definitely – that's what I mainly use it for:). Run queries: Yes. It has a query editor with syntax highlighting even.
Not sure about your 'bonus feature', as I didn't check that. Giving you an example screenshot before you head to the: Sqliteman running on Linux (source:; click image for larger variant).
You may like my app. It fits all of your requirements other than being free/open source. There is a available on the Mac App Store, which allows you to view all of your data, but does not allow modifying schemas or data.
The ‘bonus’ feature (automatic refresh) is handled as well. By default the database will detect external changes and reload automatically. This can be disabled via the application preferences (although reloads can still be performed via keyboard shortcuts). 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. 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.
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. Yes, it has the basic features you need: Table schema? Table contents? Custom queries?.
Base fully supports the display and editing of all column- and table-level constraints. Everything from simple default values, through to complex foreign key constraints, Base can handle it.
Advanced table designing & altering No need to muck about with long-winded 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 filtering Easily find the data you want using the new filtering system. Build complex queries with minimal typing in a familiar spotlight-like view.
You can even export the filter to SQL to save later!. Easy import, comprehensive export. Quickly bring in existing CSV or SQL from dump files, then export your tables and custom queries to SQL, delimited text, XML or Microsoft Excel-compatible formats!. SQL editing made easy On top of the standard syntax highlighting, Base can now autocomplete commonly-used SQL commands. Even better, you can store your commonly used SQL snippets for quick re-use later on. Screenshots Support Need help?
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |