Nulls and empty string entries are indistinguishable. The query builder is very good, but it would be nice to have a one click way to show all the data in the selected table (eg in the table list) in one click. MesaSQLite opens database files on AppleShare volumes, which a few others choke on. It's great to see this as a native Cocoa app, rather than some of the ugly Java alternatives. Import any csv, tab, or xls file into a given table.Import a proprietary dump that can recreate the database from a single file.Export the content screen, custom query result, or table as a csv, tab, or xls file.Export a proprietary dump to back-up the structure and content of the database. ![]() Drop a file containing REALBasic code to generate the database you have built in MesaSQLite.Create, view, and edit your Foreign Keys in the Foreign Key tab.Three triggers are created for each key in order to create and preserve referential integrity between tables ![]()
0 Comments
Leave a Reply. |