3 ms·

Ah... installation "wizards"... Your DB driver of choice [MySQL/MariaDB]: [mysql ] MySQL/MariaDB [pgsql ] PostgreSQL [sqlsrv ] SQL Se

Ah... installation "wizards"... Your DB driver of choice [MySQL/MariaDB]: [mysql ] MySQL/MariaDB [pgsql ] PostgreSQL [sqlsrv ] SQL Server [sqlite-e2e] SQLite > sqlite-e2e Absolute path to the DB file: > /home/user/koel.sqlite3 WARN Cannot connect to the database. Let's set it up. Your DB driver of choice [MySQL/MariaDB]: [mysql ] MySQL/MariaDB [pgsql ] PostgreSQL [sqlsrv ] SQL Server [sqlite-e2e] SQLite

j16sdiz 2y ago
https://github.com/koel/koel/issues/1099 https://github.com/koel/koel/issues/1099 Looks like the "sqlite-e2e" is for integration-test only.
- dathos 2y ago
  Interesting, I wouldn't consider another DB driver for integration tests if that isn't usable in production. Probably a good reason for it but can anyone clarify why that's done?
  - imp0cat 2y ago
    Well, sqlite is the most simple alternative that's great for local testing.
- JodieBenitez 2y ago
  And yet the "getting started" page says: "Any database supported by Laravel – MySQL, MariaDB, PostgreSQL, or SQLite" The "wizard" also proposes a regular "SQLite" option. But it fails as well. I wouldn't mind if it was a humble project, but the website is full of marketing BS, including "Koel is a music streaming solution that actually works™"
- lupusreal 2y ago
  But sqlite is the only choice from those options that makes any sense for a personal music server. (I use it in this role, with my own home-brewed media and documents library.)
  - JodieBenitez 2y ago
    It definitely should be the default IMO.
  - Mashimo 2y ago
    I have quite a few personal services running at home that use mysql. Would be lovely if sqlite worked, but why is it the only one that makes any sense?
    - lupusreal 2y ago
      Installing/maintaining mysql or the others is a pain in the ass relative to sqlite (essentially no cost at all). For a personal media library, all write operations are trivially serializable. Sqlite DBs are the easiest to copy to new machines when you upgrade hardware.
      - Mashimo 2y ago
        > Installing/maintaining mysql or the others is a pain in the ass Koel provides a docker-compose file for them, should make it trivial to spin it up.
        lupusreal 2y ago
        Needing to delve into docker stuff is itself a bigger hassle than using sqlite. Which isn't saying much admittedly, but sqlite is basically hassle free in the most extreme way.
        Mashimo 2y ago
        Oh yeah, but it's still far far away from "not making any sense"
ocodo 2y ago
...just owrks...

j16sdiz 2y ago

https://github.com/koel/koel/issues/1099 https://github.com/koel/koel/issues/1099 Looks like the "sqlite-e2e" is for integration-test only.

dathos 2y ago
Interesting, I wouldn't consider another DB driver for integration tests if that isn't usable in production. Probably a good reason for it but can anyone clarify why that's done?
- imp0cat 2y ago
  Well, sqlite is the most simple alternative that's great for local testing.
JodieBenitez 2y ago
And yet the "getting started" page says: "Any database supported by Laravel – MySQL, MariaDB, PostgreSQL, or SQLite" The "wizard" also proposes a regular "SQLite" option. But it fails as well. I wouldn't mind if it was a humble project, but the website is full of marketing BS, including "Koel is a music streaming solution that actually works™"
lupusreal 2y ago
But sqlite is the only choice from those options that makes any sense for a personal music server. (I use it in this role, with my own home-brewed media and documents library.)
- JodieBenitez 2y ago
  It definitely should be the default IMO.
- Mashimo 2y ago
  I have quite a few personal services running at home that use mysql. Would be lovely if sqlite worked, but why is it the only one that makes any sense?
  - lupusreal 2y ago
    Installing/maintaining mysql or the others is a pain in the ass relative to sqlite (essentially no cost at all). For a personal media library, all write operations are trivially serializable. Sqlite DBs are the easiest to copy to new machines when you upgrade hardware.
    - Mashimo 2y ago
      > Installing/maintaining mysql or the others is a pain in the ass Koel provides a docker-compose file for them, should make it trivial to spin it up.
      - lupusreal 2y ago
        Needing to delve into docker stuff is itself a bigger hassle than using sqlite. Which isn't saying much admittedly, but sqlite is basically hassle free in the most extreme way.
        Mashimo 2y ago
        Oh yeah, but it's still far far away from "not making any sense"

ocodo 2y ago

...just owrks...