Information on getting started with SQLite databases on Mac OS X such as installation, setup, and access. Free Download SQLiteStudio for Mac 3.1.1 - A straightforward and easy to use, yet powerful SQLite database manager that makes it easy for you to ma. SQLite for Mac Free Download - An ACID-compliant relational database management system. 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 application_id 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |