It’s unfortunate, but on iOS we don’t really have a good CLI method for accessing the on-device SQLite database like we do with Android. INFO: This section assumes you have XCode 4+. timer ON|OFF Turn the CPU timer measurement on or off vfsname ?AUX? Print the name of the VFS stack timeout MS Try opening locked tables for MS milliseconds If TABLE specified, only list tables matching show Show the current values for various settings separator STRING Change separator used by output mode and. If TABLE specified, only show tables matching schema ?TABLE? Show the CREATE statements restore ?DB? FILE Restore content of DB (default "main") from FILE prompt MAIN CONTINUE Replace the standard prompts nullvalue STRING Print STRING in place of NULL values mode MODE ?TABLE? Set output mode where MODE is one of:Ĭolumn Left-aligned columns. If TABLE specified, only show indices for tables indices ?TABLE? Show names of all indices import FILE TABLE Import data from FILE into TABLE header(s) ON|OFF Turn display of headers on or off explain ?ON|OFF? Turn output mode suitable for EXPLAIN on or off. If TABLE specified, only dump tables matching databases List names and files of attached databases bail ON|OFF Stop after hitting an error. backup ?DB? FILE Backup DB (default "main") to FILE It comes preloaded on Mac OSX and is available for all other major OSes. For that reason I tend to stick to the sqlite3 command line tool. My weapon of choice is generally the command line. First we’ll need a tool to actually interact with a SQLite database… In order to make this a little less painful of an experience, let’s take a look at a very simple way to inspect SQLite databases, and where we can find those databases on various mobile platforms.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |