How do you programmatically create an empty database?
pete at mollysrevenge.com
Tue Nov 23 16:29:30 CST 2010
Great tool for sqlite but I think they've moved over to mySQL now.
Might be a ggod idea to prototype the app with SQLite (no/very little
db admin required) then port it over to mySQL if it turns out that
SQLite won;t do the job.
On Nov 23, 2010, at 2:10 PM, Andre Garzia wrote:
> If you use firefox, then pick up a firefox extension sqlite manager.
> 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.
> On Tue, Nov 23, 2010 at 7:46 PM, Jonathan Lynch <jonathandlynch at gmail.com
>> Honestly, I am still just trying to get my head around using
>> I use Rev for processing text in all sorts of creative ways at work -
>> increases our productivity - but, I know next to nothing about
>> 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
>> 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
>> 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
>> On Tue, Nov 23, 2010 at 4:32 PM, Mark Schonewille <
>> m.schonewille at economy-x-talk.com> wrote:
>>> 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
>>> directly to the MySQL directory and restart MySQL (for which you
>>> 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
>>> 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
>>>> for that?
>>> use-livecode mailing list
>>> use-livecode at lists.runrev.com
>>> Please visit this url to subscribe, unsubscribe and manage your
>>> subscription preferences:
>> 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://www.andregarzia.com All We Do Is Code.
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
More information about the use-livecode