SQLITE BROWSER MAC OS WINDOWS
FYI, I used iFunBox on Windows to retrieve the SQL file from the PhatNotes sandbox on the original iPad, since the data transmission facilities in PhatNotes had stopped working following an iOS upgrade. The reason I bought this app was specifically to deal with the above-mentioned iPad/iPhone database, which is critical to me and which I was forced to migrate to MacOS. I haven’t tried this function with any other SQL databases. The SQL database was originally created by the PhatNotes iPhone/iPad app, which is quite old and no longer supported, perhaps this has something to do with this issue? However, other SQL editors I’ve tried on MacOS don’t have any trouble accessing and modifying record data in this database. Going through the “Alter” process for the record also does not let me change the data. Double-clicking only selects the text under the mouse as if I’m copy/pasting. Export to SQL, delimited text, XML or Microsoft Excel-compatible formats.Īfter I open a database, sometimes I can double-click a data record to open an edit window so I can change data, but usually usually I can’t.
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. Advanced table designing and altering.
From simple default values, to complex foreign keys, Base can handle it.