How do you programmatically create an empty database?

Andre Garzia andre at andregarzia.com
Tue Nov 23 17:10:26 EST 2010


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 <jonathandlynch at 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.schonewille at 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 at 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 at 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.



More information about the Use-livecode mailing list