is there a way in next.jdbc to create a database?
Sure, just connect to some existing database and then execute these queries
create user john_smith with password 'secret';
create database some_db with owner john_smith;
Of course, the current user must be able to create other users and databases.And if there's no existing database, whether you can connect to a server depends on the RDBMS itself. E.g. it seems that in MySQL you can to it just fine, but in PostgreSQL you have to be at least some database first.
But usually, databases are created not via Clojure/Python/any other language, but command line tools.
yeah in Postgres, database is mandatory. You cannot connect without specifying a database.
aaaaah @p-himik and @igrishaev that was the missing part for me i just used a lot mysql lesser postgres and now with the app i create i was like why do i have to have a db in postgress 😄 now it makes it clear its an constraint of the environment basically
Can always shell out to createdb if you really need to create a DB from within the Clojure process.
just curious what would be the better approach for something like #borkweb and for newcommers. But i guess just letting them fiddle arround with a db would be great right. Anyway you still have the option with hsql