~singpolyma/biboumi

biboumi/src/database/postgresql_engine.hpp -rw-r--r-- 1.2 KiB
61de6b1d — louiz’ 4 years ago
Revert "Use a different Date data type"

This reverts commit 857c7d3972a03cbeebf730d99b924d3710dee6a0.
de8267fa — louiz’ 4 years ago
Fix a build warning when compiling without postgres or sqlite
857c7d39 — louiz’ 4 years ago
Use a different Date data type

PLEASE backup your database before testing this commit, and report any
migration issue.

In postgresql, we use timestamp with timezone.
In sqlite3 we use REAL (the date is expressed as julianday)

This requires a migration of the muclogline_ table:
In postgresql it’s pretty simple, we convert all the integer into timestamps

With sqlite3, we actually rename the table, create the new one with the
correct type, then copy everything to the new table, with a conversion
function for the Date_ column, and then we delete the old table.

fix #3343
2c4016a4 — louiz’ 4 years ago
Merge branch 'postgresql' into 'master'

Add postgresql support

Closes #3237

See merge request louiz/biboumi!18
414bbca0 — louiz’ 4 years ago
Handle postgresql and sqlite3 libs properly

Do not fail to compile when one of them is missing but the other one is not.

Raise an error when trying to open a database with the missing library.

see #3237
0168b96b — louiz’ 4 years ago
Add postgresql support