{"action":"created","issue":{"url":"https://api.github.com/repos/sulu-io/sulu/issues/2048","repository_url":"https://api.github.com/repos/sulu-io/sulu","labels_url":"https://api.github.com/repos/sulu-io/sulu/issues/2048/labels{/name}","comments_url":"https://api.github.com/repos/sulu-io/sulu/issues/2048/comments","events_url":"https://api.github.com/repos/sulu-io/sulu/issues/2048/events","html_url":"https://github.com/sulu-io/sulu/issues/2048","id":136435784,"number":2048,"title":"Add support for SQLite","user":{"login":"webmozart","id":176399,"avatar_url":"https://avatars.githubusercontent.com/u/176399?v=3","gravatar_id":"","url":"https://api.github.com/users/webmozart","html_url":"https://github.com/webmozart","followers_url":"https://api.github.com/users/webmozart/followers","following_url":"https://api.github.com/users/webmozart/following{/other_user}","gists_url":"https://api.github.com/users/webmozart/gists{/gist_id}","starred_url":"https://api.github.com/users/webmozart/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/webmozart/subscriptions","organizations_url":"https://api.github.com/users/webmozart/orgs","repos_url":"https://api.github.com/users/webmozart/repos","events_url":"https://api.github.com/users/webmozart/events{/privacy}","received_events_url":"https://api.github.com/users/webmozart/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/sulu-io/sulu/labels/DX","name":"DX","color":"006b75"},{"url":"https://api.github.com/repos/sulu-io/sulu/labels/Enhancement","name":"Enhancement","color":"bfdadc"}],"state":"open","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/sulu-io/sulu/milestones/14","html_url":"https://github.com/sulu-io/sulu/milestones/Release%201.2","labels_url":"https://api.github.com/repos/sulu-io/sulu/milestones/14/labels","id":1218042,"number":14,"title":"Release 1.2","description":"","creator":{"login":"chirimoya","id":627313,"avatar_url":"https://avatars.githubusercontent.com/u/627313?v=3","gravatar_id":"","url":"https://api.github.com/users/chirimoya","html_url":"https://github.com/chirimoya","followers_url":"https://api.github.com/users/chirimoya/followers","following_url":"https://api.github.com/users/chirimoya/following{/other_user}","gists_url":"https://api.github.com/users/chirimoya/gists{/gist_id}","starred_url":"https://api.github.com/users/chirimoya/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/chirimoya/subscriptions","organizations_url":"https://api.github.com/users/chirimoya/orgs","repos_url":"https://api.github.com/users/chirimoya/repos","events_url":"https://api.github.com/users/chirimoya/events{/privacy}","received_events_url":"https://api.github.com/users/chirimoya/received_events","type":"User","site_admin":false},"open_issues":63,"closed_issues":49,"state":"open","created_at":"2015-07-21T12:42:54Z","updated_at":"2016-03-15T09:57:55Z","due_on":"2016-03-30T22:00:00Z","closed_at":null},"comments":8,"created_at":"2016-02-25T16:21:33Z","updated_at":"2016-03-15T11:01:58Z","closed_at":null,"body":"In order to simplify the installation of Sulu as much as possible, we should add support for SQLite. In a second step, SQLite should be the default database backend for Sulu Standard. The goal is that users are able to set up Sulu within minutes, even without reading the documentation.\r\n\r\nAt the moment, SQLite is not supported. During `app/console sulu:build`, the following error occurs:\r\n\r\n```\r\n$ app/console sulu:build prod\r\nBuild Targets\r\n=============\r\n\r\n+---+--------------------+-----------------------------------------------------------------+\r\n| # | Builder            | Deps                                                            |\r\n+---+--------------------+-----------------------------------------------------------------+\r\n| 0 | database           |                                                                 |\r\n| 1 | phpcr              | database                                                        |\r\n| 2 | fixtures           | database, phpcr                                                 |\r\n| 3 | phpcr_migrations   | phpcr                                                           |\r\n| 4 | system_collections | database, fixtures                                              |\r\n| 5 | prod               | database, phpcr, fixtures, phpcr_migrations, system_collections |\r\n+---+--------------------+-----------------------------------------------------------------+\r\n\r\nOptions:\r\n\r\n  - nodeps: false\r\n  - destroy: false\r\n  - help: false\r\n  - quiet: false\r\n  - verbose: false\r\n  - version: false\r\n  - ansi: false\r\n  - no-ansi: false\r\n  - no-interaction: false\r\n  - shell: false\r\n  - process-isolation: false\r\n  - env: 'dev'\r\n  - no-debug: false\r\n\r\nLook good? (y)y \r\n\r\nExecuting builders\r\n==================\r\n\r\nTarget: database\r\n\r\n    \r\n                                                                                                                   \r\n      [Doctrine\\DBAL\\DBALException]                                                                                \r\n      Operation 'Doctrine\\DBAL\\Platforms\\AbstractPlatform::getListDatabasesSQL' is not supported by platform.  \r\n                                                                                                                   \r\n\r\n    sulu:build [-D|--nodeps] [--destroy] [-h|--help] [-q|--quiet] [-v|vv|vvv|--verbose] [-V|--version] [--ansi] [--no-ansi] [-n|--no-interaction] [-s|--shell] [--process-isolation] [-e|--env ENV] [--no-debug] [--] <command> [<target>]\r\n```\r\n\r\nIf possible, this should be fixed."},"comment":{"url":"https://api.github.com/repos/sulu-io/sulu/issues/comments/196766124","html_url":"https://github.com/sulu-io/sulu/issues/2048#issuecomment-196766124","issue_url":"https://api.github.com/repos/sulu-io/sulu/issues/2048","id":196766124,"user":{"login":"dantleech","id":530801,"avatar_url":"https://avatars.githubusercontent.com/u/530801?v=3","gravatar_id":"","url":"https://api.github.com/users/dantleech","html_url":"https://github.com/dantleech","followers_url":"https://api.github.com/users/dantleech/followers","following_url":"https://api.github.com/users/dantleech/following{/other_user}","gists_url":"https://api.github.com/users/dantleech/gists{/gist_id}","starred_url":"https://api.github.com/users/dantleech/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dantleech/subscriptions","organizations_url":"https://api.github.com/users/dantleech/orgs","repos_url":"https://api.github.com/users/dantleech/repos","events_url":"https://api.github.com/users/dantleech/events{/privacy}","received_events_url":"https://api.github.com/users/dantleech/received_events","type":"User","site_admin":false},"created_at":"2016-03-15T11:01:58Z","updated_at":"2016-03-15T11:01:58Z","body":"Hmm. Mine didn't look like that. Anyway,\r\n\r\nThe symfony CMF standard looks as follows:\r\n\r\n\r\n```\r\nparameters:\r\n    database_driver:   pdo_sqlite\r\n    database_path: '%kernel.root_dir%/app.sqlite'\r\n    database_host: null\r\n    database_port: null\r\n    database_name: null\r\n    database_user: null\r\n    database_password: null\r\n\r\n    # ...\r\n```\r\n"}}