Question: why is "CREATE DATABASE" not yet implemented?

[rhighs]

I have a few tests i wanted to migrate to ramsql. They make use of a create command: CREATE DATABASE <test_name> to leverage tests parallelism, but it got error: "Parsing error near ". Looking at the code this seems to be implemented yet. Is there any specific reason?

If not, I could have a deeper look and open a PR!

[proullon]

Hello,

The reason CREATE DATABASE is not implemented is that opening a connection with ramsql on any different connection string will be isolated, like running in a different database.

i.e

db1, _ := db.Open("ramsql", "Test1")
db1, _ := db.Open("ramsql", "Test2")

Now indeed, there may be a case to parse "CREATE DATABASE" and ignore it, to avoid error with pre-existing tests.

[rhighs]

Now indeed, there may be a case to parse "CREATE DATABASE" and ignore it, to avoid error with pre-existing tests.

I've tried using it the way you describe it and it works really well. I have some code paths that run migrations files for my tests in a given database, skipping the error would be great. It might be a good idea to track down which tokens are parsed and ignored to avoid errors in a table somewhere. You know, just to document this behavior.