catfan
Issues going between MySQL and SQLite
I'm currently working on an application that utilizes Medoo, along with a custom migrations controller built around it. Table creation functions as expected when using MySQL; however, I'm encountering syntax-related issues—particularly with AUTO_INCREMENT—when attempting to run the same migrations on SQLite.
Is there a configuration setting within Medoo that addresses these differences, or would it be advisable to implement a translation layer that adjusts SQL syntax based on the active database driver?
You can check out the database type via $database->type and run a different query for it.
Thank you for your response. I was wondering if there are any plans to introduce greater intercompatibility or a built-in translation layer to help address these syntax differences across database types. Needing to manually check the driver and adjust queries accordingly does add some friction to the development process, though I do appreciate that the library is designed to remain lightweight and minimal.