The first two tutorials have already learnt you how to create a project, but this one is quite different : We will see here how to make a project that connects to a PostgreSQL database, makes a query and displays data in an application.
To do so, go to File
and search "SQL
" in the search bar --> select SQL project,
and name it "sql_database_back
Then, you will have to fill the information to link the database you want : In this case we will take the "Public Postgres Database" from the RNAcentral website.(https://rnacentral.org/help/public-database
In the first field, select org.postgresql.Driver
In the JDBC URL
field, replace <server_name>
and <database name>
In the Username
field, type reader
and paste NWDMCE5xdipIjRrp
in the password field.
You can find all the connection information for the SQL Database on the link above.
Once you filled everything, click the "Test connection" button to see if it works. You should have a "connection parameters are correct" message.