Possibility of support for other databases

[christianwolters]

Hi Lawrence,

I just read about your project in the moodle dev chat.

Are you using some code/api/? that prevents the use with other databases,
or are specific to MariaDB?

How complex do you think is it, to make this work with postgres?

Best regards
Christian

[llagerlof]

Hi @christianwolters.

I am using PHP's PDO that can access many databases. However, as you know, each database has its specific set of commands to retrieve data.

Freezer needs to query some information from tables:

• The list of database's table names.
• The structure of each table, containing at least:
  • All table's fields and its types.
  • Which field is the auto incremented one (if has an auto incremented field)

So if I get this information I could abstract those and add other databases (postgres in this case).

Can you send me the query commands I need to run on Postgres to get the information mentioned above? This would save me a precious time.

Thank you.