DBFCDX or SQLite

[fouednoomen]

Dear Radhi ,

Many thanks for your prompt reply ,

Following my configuration You advise me to migrate to MariaDB , so :

1- is it Free
2- how many users can support
3- i must change change all dbf commands and functions or not
4- can i migrate step by step ,that mean i migrate first the big files until i finish all job because
I need to test the new database system online with full charge under the network

I consider this topics as a workshop for all Members of this Forum in order to help everyone
to migrate to a database system

i appreciate your help in advance


Regards

Foued

[Rathinagiri]

Rightly asked Foued.

1. Yes. it is.

This is their mission statement stressing on technical and legal means to guarantee the technology used by the world's largest database community to be free in every sense.

All of MariaDB is by default be GPL

2. Theoretically unlimited. It is limited by your network resources and bandwidth. Most of the web servers run on MySQL. Even our forum runs on MySQL only. MariaDB is developed by the original MySQL developer.

3. Yes and no. There are some RDDs using DBF like commands to access SQL. However, I prefer using the straight SQL connection. If you want to use straight SQL based functions and commands it is easy too. SQL is recordset based. This is because of ACID requirements. It is being handled using arrays in Harbour. If you want I can create prototype of dbf and sql operations.

4. Yes. You can migrate a part of a project if the database can be migrated in such a way the integrity doesn't get affected.

[fouednoomen]

Thanks a lot Radhi

Could you please create for us prototype of dbf and sql operations.

i will download MariaDB and i 'm waiting for your prototype to start the migration of my
biggest dbf file ,

I hope that it easy .


Regards

foued

[mol]

I'm also interested

[fouednoomen]

Hi Mol ,

I'm sure if Radhi open for us a workshop in this forum ( How to migrate from dbfcdx to Mariadb or mysql or sqlite step by step ) and everyone participate following his competence level , we can success together easily


Regards

Foued

[Carlos Britos]

Hi Mol ,

I'm sure if Radhi open for us a workshop in this forum ( How to migrate from dbfcdx to Mariadb or mysql or sqlite step by step ) and everyone participate following his competence level , we can success together easily


Regards

Foued

+1

[bpd2000]

Waiting for working example

[Hazael]

One thing I like about SQLite is the possibility to use it with SQLCipher to have the database secure.
More about it here: http://hmgforum.com/viewtopic.php?f=7&t=2416

And here is a good topic about going from DBF to SQLite: http://hmgforum.com/viewtopic.php?f=37&t=1539

I hope it will help someone