3 ms·

You should post on r/selfhosted (https://www.reddit.com/r/selfhosted/ https://www.reddit.com/r/selfhosted/) Been waiting for something like this for a long tim

You should post on r/selfhosted (https://www.reddit.com/r/selfhosted/ https://www.reddit.com/r/selfhosted/) Been waiting for something like this for a long time ... Only thing I would change is use sqlite rather than mysql. That way your data is in a single file that is easily portable.

michaelbrooks 7y ago
It's using Doctrine so the configuration should be easy to change in the .env file. Update the "DATABASE_URL" line to... `DATABASE_URL="sqlite:///%kernel.project_dir%/var/app.db"` And point it to the correct directory where your file is located.
- michaelbrooks 7y ago
  I can't edit, but I was hoping the backticks would create a code block, so please ignore those backticks. Also, more details can be found on their documentation [0]. [0] https://symfony.com/doc/current/doctrine.html#configuring-the-database https://symfony.com/doc/current/doctrine.html#configuring-th...
  - sokoloff 7y ago
    DATABASE_URL="sqlite:///%kernel.project_dir%/var/app.db" Use two or more spaces at the start of the line: https://news.ycombinator.com/formatdoc https://news.ycombinator.com/formatdoc
    - michaelbrooks 7y ago
      That's helpful, thank you.
notmainacct 7y ago
I mean, you get a similarly portable file with mysqldump -u username -p database_name > data-dump.sql and you can load that dump back in with mysql -u username -p new_database < data-dump.sql I love sqlite3 for the ease of setting up, and the ability to use in any device or environment immediately, but I'll go to a more featured database like postgres or mysql for larger projects, or for speed. This projects seems to benefit with using mysql to be able to secure the database with a password, as well as the ability to have a timestamp type (but the project saves timestamps with a string rather than a datatime except for user login timestamps so ¯\_(ツ)_/¯)
dwlodarczyk13 7y ago
Hey thanks for that info - I will check that subreddit. I will stick to mysql. I agree that it would be more portable but I dont really intend to take it with me anywhere.

michaelbrooks 7y ago

It's using Doctrine so the configuration should be easy to change in the .env file. Update the "DATABASE_URL" line to... `DATABASE_URL="sqlite:///%kernel.project_dir%/var/app.db"` And point it to the correct directory where your file is located.

michaelbrooks 7y ago
I can't edit, but I was hoping the backticks would create a code block, so please ignore those backticks. Also, more details can be found on their documentation [0]. [0] https://symfony.com/doc/current/doctrine.html#configuring-the-database https://symfony.com/doc/current/doctrine.html#configuring-th...
- sokoloff 7y ago
  DATABASE_URL="sqlite:///%kernel.project_dir%/var/app.db" Use two or more spaces at the start of the line: https://news.ycombinator.com/formatdoc https://news.ycombinator.com/formatdoc
  - michaelbrooks 7y ago
    That's helpful, thank you.

notmainacct 7y ago

I mean, you get a similarly portable file with mysqldump -u username -p database_name > data-dump.sql and you can load that dump back in with mysql -u username -p new_database < data-dump.sql I love sqlite3 for the ease of setting up, and the ability to use in any device or environment immediately, but I'll go to a more featured database like postgres or mysql for larger projects, or for speed. This projects seems to benefit with using mysql to be able to secure the database with a password, as well as the ability to have a timestamp type (but the project saves timestamps with a string rather than a datatime except for user login timestamps so ¯\_(ツ)_/¯)

dwlodarczyk13 7y ago

Hey thanks for that info - I will check that subreddit. I will stick to mysql. I agree that it would be more portable but I dont really intend to take it with me anywhere.