nicmart-dev / linguistnow

LinguistNow simplifies the hassle of finding available linguists for translation projects.
https://linguistnow.netlify.app
1 stars 1 forks source link

Migrate DB to PostgreSQL and deploy to Render #25

Closed nicmart-dev closed 1 month ago

nicmart-dev commented 1 month ago

if you are using a Database you will have to use PostgreSQL . To do this you can install the pg node_module/ and edit your knexfile.js to be something like:

require('dotenv').config();
module.exports = {
  client: "pg",
  connection: {
      host: process.env.DB_HOST,
      user: process.env.DB_USER,
      password: process.env.DB_PASSWORD,
      database: process.env.DB_DATABASE,
      port: 5432,
      ssl:true
  }
};
nicmart-dev commented 1 month ago

Obsolete as we implemented Airtable instead of MySQL, meaning we also don't need to deploy DB as it's already in the cloud.