Jonathan, If you use firefox, then pick up a firefox extension sqlite manager. With this extension you'll have a simple client able to work your database files which you can then later open and use in LiveCode.
There are other sqlite tools and yes you can do it by script but I think it is easier to use a graphical tool. if you're on mac os x, then on the terminal there is a utility called sqlite3 which can be used. andre On Tue, Nov 23, 2010 at 7:46 PM, Jonathan Lynch <jonathandly...@gmail.com>wrote: > Honestly, I am still just trying to get my head around using databases. > > I use Rev for processing text in all sorts of creative ways at work - > vastly > increases our productivity - but, I know next to nothing about database > use. > > The logical process, to me, would be the following: > > - Create database file > - Populate it with columns > - Set up my application to use an embedded database app to write and > retrieve data as needed > > Say, for example, if I wanted to experiment with Valentina (knowing that > the > demo version only lasts 10 minutes before the app has to be restarted). I > could not fool around with it, without having an existing file to work > with. > > So, I thought to myself, my first step must be to create a database file. I > am not committed to doing it in a script, I just don't know how else to > access the embedded database driver functionalities. > > Should I just find a blank database file somewhere on the web and download > it? > > On Tue, Nov 23, 2010 at 4:32 PM, Mark Schonewille < > m.schonewi...@economy-x-talk.com> wrote: > > > Jonathan, > > > > That depends on the database you want to use. If you use MySQL then the > > answer is yes, although it might be possible to write new database files > > directly to the MySQL directory and restart MySQL (for which you will > also > > need to use the shell function). > > > > Why are you so keen on creating a database file by script? > > > > -- > > Best regards, > > > > Mark Schonewille > > > > Economy-x-Talk Consulting and Software Engineering > > Homepage: http://economy-x-talk.com > > Twitter: http://twitter.com/xtalkprogrammer > > KvK: 50277553 > > > > How to receive a free Color Converter license http://qurl.tk/kv (read > the > > conditions) > > > > On 23 nov 2010, at 22:24, Jonathan Lynch wrote: > > > > > Thanks, Mark. > > > > > > I am not talking about a database on a server. I just want to create a > > > database file on a shared drive. Would I still need to use a shell > > command > > > for that? > > > > > > > > > _______________________________________________ > > use-livecode mailing list > > use-livecode@lists.runrev.com > > Please visit this url to subscribe, unsubscribe and manage your > > subscription preferences: > > http://lists.runrev.com/mailman/listinfo/use-livecode > > > > > > -- > Do all things with love > _______________________________________________ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode > -- http://www.andregarzia.com All We Do Is Code. _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
