Converting mysql to SQLite

[Bill]

As soon as you do that I will make two copies of my program, one using MySQL
and one using SQLite and start doing some speed test comparisons. I use the
database controls and everything moves very slowly with MySQL.

On 4/17/05 10:51 PM, "Trevor DeVore" <lists at mangomultimedia.com> wrote:

> On Apr 17, 2005, at 6:21 PM, Bill wrote:
>> But it requires SQLite 3.0 database files and it turns out the version
>> of
>> SQLite installed with altSQLite is SQLite 2.1 (when you look at the
>> generated database file that is what it says) even though it says on
>> the
>> Altuit web site that the version used is 2.8
> 
> altSQLite does use version 2.8 but the version of the SQLite db file is
> 2.1.  I tested this with the compiled version of SQLite 2.8 and it
> reports 2.1 as well.
> 
> Though this might not help you in the short term I am incorporating
> code in the next release of libDatabase which will convert from one
> database to another without use of any external programs.  Right now
> the code I have just does MySQL to Valentina but I am in the middle of
> making it more generic and incorporation it into libDatabse so it will
> be easy to add additional db support.  I plan on releasing 2.0 of
> libDatabase with support for MySQL, SQLite and Valentina.
> 

            |    |    |
           )_)  )_)  )_)
          )___))___))___)\
         )____)____)_____)\\
       _____|____|____|____\\\__
-------\                   /--------- http://www.bluewatermaritime.com
 ^^^^^ ^^^^^^^^^^^^^^^^^^^^^
  ^^^^      ^^^^     ^^^    ^^
       ^^^^      ^^^

24 hour cell: (787) 378-6190
fax: (787) 809-8426

Blue Water Maritime
P.O. Box 91
Puerto Real, PR 00740