On 26 Jul 2013, at 9:25am, Rob Slater <[email protected]> wrote:
> I have an iPad app that uses several (4) different SQLITE databases and I > currently build these databases using Mozilla Firefox SQLite Manager utility > (on a Mac). The databases are simple (single table) with a number of rows, > and are created from a text file with tab delimited fields. > > This all works but is clunky. I would prefer to create the SQLITE databases > on my Windows PC (where the text files are created). > > My question is whether the SQLITE can do this job and how I go about it. I > suspect that I should be able to set up a file of SQL commands to build the > new database(s), to automate the process somewhat.... I recommend you use the sqlite3 shell tool, which you can find here <http://www.sqlite.org/download.html> precompiled for Windows. Documentation is here: <http://www.sqlite.org/sqlite.html> The simplest way to pre-make a database is to make a text file with the SQL commands which you would need, separated by semi-colons. You can then use the shell tool to process all those commands in sequence using the '.read' command. >From your description it might be simplest to write a pre-processor which >turns your existing 'text file with tab delimited fields' into SQL commands >and write those commands to the end of a text file of SQL commands which >creates the database file with blank tables and indexes. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
