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.
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.
`DATABASE_URL="sqlite:///%kernel.project_dir%/var/app.db"`
And point it to the correct directory where your file is located.
[0] https://symfony.com/doc/current/doctrine.html#configuring-th...
DATABASE_URL="sqlite:///%kernel.project_dir%/var/app.db"
Use two or more spaces at the start of the line: https://news.ycombinator.com/formatdocmysqldump -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 ¯\_(ツ)_/¯)