Support other database backends

Jef Roosens commented

2022-05-07 13:17:20 +02:00

Owner

Vlib has support for sqlite, postgresql & mysql/mariadb. If we could re-write the code to choose which database type to use, the ORM would allow us to choose one over the other.

Jef Roosens added the

enhancement

label 2022-05-07 13:17:20 +02:00

Jef Roosens commented

2022-05-28 16:03:43 +02:00

Author

Owner

The ORM is currently not complete enough to allow for this.

Jef Roosens commented

2022-06-28 11:02:26 +02:00

Author

Owner

I think this could be accomplished by not using the ORM syntax at all. Instead, all database operations could rely on the orm.Connection interface. Then the type of the database connection could be just orm.Connection, allowing multiple database backends!

Of course, this still leaves the problem of migrations. We'd have to write migrations for every database backend that we wish to support.

I think this could be accomplished by not using the ORM syntax at all. Instead, all database operations could rely on the `orm.Connection` interface. Then the type of the database connection could be just `orm.Connection`, allowing multiple database backends! Of course, this still leaves the problem of migrations. We'd have to write migrations for every database backend that we wish to support.

Jef Roosens commented

2022-10-29 14:32:53 +02:00

Author

Owner

this PR could make this simpler, as it would allow us to use a generic orm.Connection object for ORM operations, leaving only the problem of custom migrations.

[this PR](https://github.com/vlang/v/pull/16076) could make this simpler, as it would allow us to use a generic `orm.Connection` object for ORM operations, leaving only the problem of custom migrations.

Jef Roosens added a new dependency 2022-11-02 08:21:51 +01:00

#283 Fully database-agnostic code

Jef Roosens commented

2022-11-02 08:22:53 +01:00

Author

Owner

The above PR has not been merged in the V 0.3.2 release, so we'll most likely have to wait until V 0.3.3 to fully implement this. However, we can already pave the way by implementing #283.

Jef Roosens added the

V

label 2022-11-02 08:34:17 +01:00

Jef Roosens commented

2023-01-31 10:03:55 +01:00

Author

Owner

The PR didn't make it into V 0.3.3 🤷‍♂️

Rows
Columns

Support other database backends #167