circumflex icon indicating copy to clipboard operation
circumflex copied to clipboard

Published 20 hours ago • verified publisher icon inca

What databases are supported by the ORM?

Open pschwede opened this issue 14 years ago • 3 comments

Hi, I'm trying to use the ORM but I am unsure about the supported databases.

Is sqlite3 supported? I couldn't find it on the homepage.

Nevertheless, good work!

pschwede avatar Oct 01 '11 08:10 pschwede

Greetings, and thanks for your kind words!

Sqlite3 is not directly supported due to its limited SQL'92 standards compatibility (no alter table add constraint statements supported). You may play with default dialect, however, to discover the features which do not work and submit your issues. We'll do our best to elaborate on them.

Best regards, Boris Okunskiy

inca avatar Oct 01 '11 16:10 inca

From comment there circumflex-orm/src/main/scala/vendor.scala

` /*!# Vendor-specific SQL dialects

Following vendors are currently supported by Circumflex ORM:

  • PostgreSQL 8.3+;
  • MySQL 5.7+;
  • H2 database.

We also provide limited support for Oracle, MS SQL Server and DB2. We would appreciate any commits for better vendors support. */ `

btd avatar Oct 02 '11 17:10 btd

Hi btd,

Can you update the supported database list?

Thanks & Regards, Abhishek

adpande avatar Jun 08 '12 22:06 adpande