It's Fizzy fully compatible with MariaDB?

[valenciaj]

Hi there!

I’m currently testing Fizzy as a possible replacement for several tools we use at my company, such as Jira, Trello, and GitHub Projects.

I’ve deployed a Fizzy instance on my personal server running Debian 12, with Ruby 3.4.7 and Rails 8.2.0.alpha, backed by MariaDB 11.8.4 from the system packages. The deployment setup is fairly traditional (“old school”): a systemd-based environment, no containers.

While deploying and testing Fizzy, I ran into a couple of issues:

1. It seems necessary to add a store function to the Filter model for things to work correctly.

git diff app/models/filter.rb
diff --git a/app/models/filter.rb b/app/models/filter.rb
index 9bfefe176..75b7af8a9 100644
--- a/app/models/filter.rb
+++ b/app/models/filter.rb
@@ -1,6 +1,8 @@
 class Filter < ApplicationRecord
   include Fields, Params, Resources, Summarized
 
+  store :fields, coder: JSON
+
   belongs_to :creator, class_name: "User", default: -> { Current.user }
   belongs_to :account, default: -> { creator.account }
 

2. I encountered an error when changing a card’s column.

rails[570893]: D, [2026-01-03T13:50:17.017219 #570893] DEBUG -- : [de23f6fe-cdda-4898-8f89-30ee444b651e]   Event Create (1.2ms)  INSERT INTO `events` (`id`, `account_id`, `action`, `board_id`, `created_at`, `creator_id`, `eventable_id`, `eventable_type`, `particulars`, `updated_at`) VALUES (x'019b83e8973378a7ac225d2e5777e8b3', x'019b7b72675b76c696322e37779cc08e', 'card_triaged', x'019b7b7267e67d76ae0bab557a8f5620', '2026-01-03 12:50:17.014355', x'019b7b7267be7024b866146f00e08c8b', x'019b7b72697a757f99f0a9b9c7673a6a', 'Card', '{particulars: {column: \"Yes\"}}', '2026-01-03 12:50:17.014355') RETURNING `particulars`
rails[570893]: D, [2026-01-03T13:50:17.018007 #570893] DEBUG -- : [de23f6fe-cdda-4898-8f89-30ee444b651e]   TRANSACTION (0.3ms)  ROLLBACK
rails[570893]: I, [2026-01-03T13:50:17.019298 #570893]  INFO -- : [de23f6fe-cdda-4898-8f89-30ee444b651e] Completed 500 Internal Server Error in 41ms (ActiveRecord: 8.3ms (15 queries, 0 cached) | GC: 0.0ms)
rails[570893]: E, [2026-01-03T13:50:17.026295 #570893] ERROR -- : [de23f6fe-cdda-4898-8f89-30ee444b651e]
rails[570893]: [de23f6fe-cdda-4898-8f89-30ee444b651e] ActiveRecord::CheckViolation (Trilogy::ProtocolError: 4025: CONSTRAINT `events.particulars` failed for `fizzy_xxx_production`.`events` (trilogy_read_row))
rails[570893]: [de23f6fe-cdda-4898-8f89-30ee444b651e] Caused by: Trilogy::ProtocolError (4025: CONSTRAINT `events.particulars` failed for `fizzy_xxx_production`.`events` (trilogy_read_row))
rails[570893]: [de23f6fe-cdda-4898-8f89-30ee444b651e]
rails[570893]: Information for: ActiveRecord::CheckViolation (Trilogy::ProtocolError: 4025: CONSTRAINT `events.particulars` failed for `fizzy_xxx_production`.`events` (trilogy_read_row)):
rails[570893]: [de23f6fe-cdda-4898-8f89-30ee444b651e]
rails[570893]: [de23f6fe-cdda-4898-8f89-30ee444b651e]
rails[570893]: Information for cause: Trilogy::ProtocolError (4025: CONSTRAINT `events.particulars` failed for `fizzy_xxx_production`.`events` (trilogy_read_row)):
rails[570893]: [de23f6fe-cdda-4898-8f89-30ee444b651e]
rails[570893]: [de23f6fe-cdda-4898-8f89-30ee444b651e] app/models/concerns/eventable.rb:10:in 'Eventable#track_event'
rails[570893]: [de23f6fe-cdda-4898-8f89-30ee444b651e] app/models/card/triageable.rb:25:in 'block in Card::Triageable#triage_into'
rails[570893]: [de23f6fe-cdda-4898-8f89-30ee444b651e] app/models/card/triageable.rb:22:in 'Card::Triageable#triage_into'
rails[570893]: [de23f6fe-cdda-4898-8f89-30ee444b651e] app/controllers/cards/triages_controller.rb:6:in 'Cards::TriagesController#create'
rails[570893]: [de23f6fe-cdda-4898-8f89-30ee444b651e] app/controllers/concerns/current_timezone.rb:15:in 'CurrentTimezone#set_current_timezone'
rails[570893]: [de23f6fe-cdda-4898-8f89-30ee444b651e] config/initializers/tenanting/account_slug.rb:32:in 'block in AccountSlug::Extractor#call'
rails[570893]: [de23f6fe-cdda-4898-8f89-30ee444b651e] app/models/current.rb:22:in 'Current#with_account'
rails[570893]: [de23f6fe-cdda-4898-8f89-30ee444b651e] config/initializers/tenanting/account_slug.rb:31:in 'AccountSlug::Extractor#call'
rails[570893]: [de23f6fe-cdda-4898-8f89-30ee444b651e] config/initializers/true_client_ip.rb:20:in 'TrackTrueClientIp#call'

I’m not sure whether these are known issues, configuration-related, or something I might be missing, so I wanted to share my experience and get some guidance.

There are a few other areas where Fizzy also breaks in my setup, but I didn’t want to list everything at once. I can provide more details if that helps.

Thanks a lot for the time and effort you’ve put into developing Fizzy, and also for taking the time to read and respond to this discussion. It’s truly appreciated.

[javier-valencia-arch]

Responding to myself briefly: no, you can’t use MariaDB with Fizzy. Instead, use MySQL, preferably the latest version available.