SQL Basic Concepts
-
Hi everyone,
I want to make an app which acts as a MySQL Server.
Is it possible that my app. acts as a SQL Server if I use "Embedded MySQL Server" solution?
Is there any example which use embedded mysql server method? -
@CodeFreaks said in SQL Basic Concepts:
Embedded MySQL Server
-
You can look for examples by Googling all over the web, including example code in the MySQL documentation. This is not a Qt question.
-
You might like to look at https://www.mysql.com/oem/. I am unclear whether the gist here is that Embedded MySQL Server is only available in a commercial offering? EDIT Perhaps not? See https://www.xaprb.com/blog/2009/02/17/when-are-you-required-to-have-a-commercial-mysql-license/ :
You need a commercial license if you want to embed MySQL within your non-Free program. Note that embed is not the same as “make a connection to.”
- You should also look at the list of restrictions in https://dev.mysql.com/doc/refman/5.6/en/libmysqld-restrictions.html. That includes:
InnoDB is not reentrant in the embedded server and cannot be used for multiple connections, either successively or simultaneously.
Assuming that would apply to you, make sure this limitation does not rule out whatever you are trying to achieve.
-