reccommend the best database engine

[jack616]

This thread seems to have been invaded by ignorant trolls - I wont bother  reading it again.

[jwdietrich]

This thread seems to have been invaded by ignorant trolls - I wont bother  reading it again.

I think that some mixed up the terms database engine and DBMS.

[Leledumbo]

I think that some mixed up the terms database engine and DBMS.

Actually the question is rather about storage engine (I don't know whether database engine refers to the same thing or not).

[fabienwang]

@Jack616, for collations, i highly suggest to use utf8_general_ci.
It supports lots of characters plus it's faster with string operations than utf8_unicode_ci

Btw, Leledumbo was right, MariaDB is 100% compatible with MySQL at api level too (even binaries have the same name).

[jwdietrich]

I think that some mixed up the terms database engine and DBMS.

Actually the question is rather about storage engine (I don't know whether database engine refers to the same thing or not).

You are right, see http://en.wikipedia.org/wiki/Database_engine. The terminology is a bit unfortunate, of course.

[avra]

This thread seems to have been invaded by ignorant trolls

And you don't think that your topic name had anything to do with it?

[JJVillamor]

I have some very good expirience with 1c:enterprise 8.
In my oppinion - create 2-10x faster your apps, rather than as usual.
I was working with Visual foxpro earlier.
...
but when i was looking for myself for completely independent solution i choose Lazarus+Firebird, but at this moment i do not check this variant and do not work with them.

At the least, this is your second post where you seem to join in the discussion then promote "1C:Enterprise".

Many Linux distributions are migrating from MySQL to MariaDB, compatible with the first. Would it be interesting to consider offering support in Lazarus?

Isn't it compatible even at API level? I mean, we don't really have to do anything to connect to MariaDB, simply treating it as MySQL. CMIIW.

Can you share more info about MAriaDB?

Right now my choices are SQLLite(easiest), Firebird (I've played around with IB a little), and PostgreSQL (most advance??). My leanings are towards firebird because it is embedable.

[Leledumbo]

Can you share more info about MAriaDB?

Err... what do you want to know about it? I think simply googling its name will reveal a lot about it. Even its history in relationship to MySQL is well explained everywhere.

[JJVillamor]

Yes I've goggled a little. It's main intent is to be compatible with mysql.

I don't really know. Maybe something important that could have been missed. I've read statements that with maridb there is no need to use mysql.

[Leledumbo]

I've read statements that with maridb there is no need to use mysql

Indeed, that's the main point of MariaDB: a drop-in replacement for MySQL with additional features and better performance.

[marcov]

Many Linux distributions are migrating from MySQL to MariaDB, compatible with the first. Would it be interesting to consider offering support in Lazarus?

Isn't it compatible even at API level? I mean, we don't really have to do anything to connect to MariaDB, simply treating it as MySQL. CMIIW.

Mysql isn't compatible with itself at API level 

[Leledumbo]

Mysql isn't compatible with itself at API level 

Let me rephrase: Mysql isn't compatible with itself of different version including minor at API level

[poiuyt555]

At the least, this is your second post where you seem to join in the discussion then promote "1C:Enterprise".

Sorry.
I promise - there will no be more in this topic (1c).
Simply you ask:

Instead of a new thread, I hope this won't be much of an OT but rather an expansion of the discussion, what if?
1) speed is preferable
2) about 100-150 records daily
3) suitable for someone not well versed in Sql aside from some basic SQL statements

I undurstand it like recomend any (not only disscussed here MariaDB and ets...). But my english is not very good and i may undesntand it not correct.
On other thread i say truth about 1c, form my point of view, as i see it.
Add: and i also recomend firebird too:

but when i was looking for myself for completely independent solution i choose Lazarus+Firebird, but at this moment i do not check this variant and do not work with them