Can I use taskcafe with MySQL? #167
Replies: 1 comment
-
However, by quickly browsing across the code, it seems that such a change would be impossible. The code requires something that only PostgreSQL has — 'extensions'. These are used for organising tables into some degree of modularity; the little I understand of PostgreSQL makes me believe that they're little more than 'syntactic sugar', i.e. not really contributing to major changes, but rather as a practical way to keep things organised (and somehow isolated from each other). I also guess (but it's just a guess!) that these extensions make partial database migration easier. There might also be some specific SQL instructions scattered around the code which use PostgreSQL's unique dialect. These would require a much deeper code change — since, in some cases, they might combine several SQL functions in a single line, and those would have to be expanded for MySQL. But you're totally right: 'forcing' PostgreSQL — and only PostgreSQL — to be the 'only' supported RDBMS is a showstopper for me as well. Having 'only' MySQL as a database in a server is not a 'problem'. It's more often than not a conscious decision, weighting in several issues — such as performance, stability, portability, general availability, and so forth. PostgreSQL has some advantages over MySQL here and there, but MySQL (especially recent versions of MySQL, of course) has other advantages. At the end of the day, that's the reason why I personally always recommend using standard SQL queries — as opposed to relying upon specific dialects — and have a general-purpose database layer (such as, say, GORM — but there are plenty to choose from), which can then be connected to whatever database is available on the system (via config files, as suggested). Unfortunately, this doesn't seem to be the case with Taskcafé. |
Beta Was this translation helpful? Give feedback.
-
Hello There,
This project is awsome and I want to use it. But the problem is that my existing database is MySQL and taskcafe supports "postgres".
My Question is, how I can use it with MySQL? Can you provide me a sample config file?
Beta Was this translation helpful? Give feedback.
All reactions