SQLite or MySQL?

Post your Gambas programming questions here.
Post Reply
User avatar
Cedron
Posts: 156
Joined: Thursday 21st February 2019 5:02pm
Location: The Mitten State
Contact:

SQLite or MySQL?

Post by Cedron »

Those seem to be the most common choices.

Which one do most people prefer?

Which one does this site use?

Either one will work for what I want to do. I'm just wondering which is more popular around here.

Postgres???

Ced
.... and carry a big stick!
User avatar
jornmo
Site Admin
Posts: 224
Joined: Wednesday 21st September 2016 1:19pm
Location: Norway

Re: SQLite or MySQL?

Post by jornmo »

SQLite is only reccomended to be used locally. This forum is using MySQL (MariaDB actually). My impression is that MySQL is more widely used than Postgre, but that people many times prefer Postgre over MySQL. But I do not have the statistics to back it up. I also "believe" REST APIs are more commonly used for applications these days, than connecting directly to a MySQL/Postgre...
User avatar
Cedron
Posts: 156
Joined: Thursday 21st February 2019 5:02pm
Location: The Mitten State
Contact:

Re: SQLite or MySQL?

Post by Cedron »

Thanks,

I want to be able to use any of them, but there are quirks and differences which makes concentrating on one make sense.

Which version of MariaDB? Which version of PHP?

If you guys are willing to host the SoftwareFarmDB I'm working on, I can provide the DB and code.

If anybody wants to volunteer to work on this with me, any help is most welcome.

Ced
.... and carry a big stick!
User avatar
jornmo
Site Admin
Posts: 224
Joined: Wednesday 21st September 2016 1:19pm
Location: Norway

Re: SQLite or MySQL?

Post by jornmo »

My hands are very full these days already. For security reasons I will not post those here in public. What is this project your making?
User avatar
Cedron
Posts: 156
Joined: Thursday 21st February 2019 5:02pm
Location: The Mitten State
Contact:

Re: SQLite or MySQL?

Post by Cedron »

FarmDB.sqlite.zip
(2.62 KiB) Downloaded 397 times
(This sucker went from 193K to 3K compressed! Talk about fluffy.)

I understand. It's not that important, I'll just grab the latest one and not use any fancy features.

Does Gambas gb.db support MariaDB?

I see SQLite, MySQL, Postgres, and ODBC.

I have a brief explanation of what I have in mind at the end of:

https://forum.gambas.one/viewtopic.php?f=4&t=699

Attached is a skeletal SQLite DB file that is automatically generated from the diagram in the post.

I've got 20 plus years of database application development experience. This would be a "medium sized" project.

Ced
.... and carry a big stick!
User avatar
gbWilly
Posts: 68
Joined: Friday 23rd September 2016 11:41am
Location: Netherlands
Contact:

Re: SQLite or MySQL?

Post by gbWilly »

Hi Cedron,

When working with MariaDb, you are working with a fork of MySql.
I used to run MySql on a Debian 7 server at work, we're now running Debian 9 servers and they replaced MySql with MariaDB. So, after a simple migration of the data from MySql to MariaDB, our data is now stored in MariaDB.

I didn't need to recode anything in the Gambas applications that work with the database (except for the server name when connecting to the database) as you approach MariaDB exactly the same as MySql (using gb.db.mysql component).

So, you code in Gambas as if you are coding for MySql from a gambas developers point of view.

Hope this helps,

gbWilly
gbWilly
- Dutch translation for Gambas3
- Gambas wiki content contributer


... there is always a Catch if things go wrong!
User avatar
Cedron
Posts: 156
Joined: Thursday 21st February 2019 5:02pm
Location: The Mitten State
Contact:

Re: SQLite or MySQL?

Post by Cedron »

Thanks gbWilly,

I decided to do the right thing and support both in the tools I am writing. I've even added MsAccess 2000 to the list.

SqLite is to MySQL/MariaDB as MsAccess is to SqlServer.

Works for me.

Ced
.... and carry a big stick!
Post Reply