Create a database and tables in runtime in Rails

Question

Is it possible to create a database and tables in runtime, in a Rails app?

For example: the server receives a request with some data. Then, it should create a database in PostgreSQL, and create also some tables in that new DB. Is this possible?

John Naegle · Accepted Answer · 2018-01-11 17:33:26Z

0

Yes, Its possible. Perhaps not recommended.

answered Jan 11, 2018 at 17:33

John Naegle

8,2973 gold badges43 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

rjmAmaro Over a year ago

can you provide more information about why it is not recommended?

rjmAmaro · Accepted Answer · 2018-03-02 16:38:01Z

0

Using the Sequel gem (http://sequel.jeremyevans.net/) it is possible to create databases in runtime, running an SQL script.

I've tried it only with a PostgreSQL database, not sure if it is possible with others.

For a PostgreSQL database

Connect to the PostgreSQL server

To connect to the PostgreSQL server you always have to define a database to connect to. Use the 'postgres' database, a default database created by the PostgreSQL server (more info: Default database named postgres on Postgresql server).

db = Sequel.postgres('postgres', user, password, host, port)

Run the SQL script to create a database

db.run "CREATE DATABASE my_new_db"

answered Mar 2, 2018 at 16:38

rjmAmaro

6901 gold badge8 silver badges21 bronze badges

Collectives™ on Stack Overflow

Create a database and tables in runtime in Rails

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related