Answers.Body: <p>We've looked into it before as I agree, it'd be awesome. But as of February 2020, the answer is no because SQLite is missing some key features that Craft currently relies on: <a href="https://www.sqlite.org/omitted.html" rel="nofollow noreferrer">https://www.sqlite.org/omitted.html</a></p>
  
  <p>Specifically the missing joins and alter table commands.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-12-14T10:06:13.960Z
Answers.Text: libSQL added some features, did you have a look if it would now be possible? It would be such a boon to DX https://github.com/tursodatabase/libsql
Answers.UserDisplayName: Udo
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-02-18T03:44:39.580Z
Answers.LastActivityDate: 2020-02-18T03:44:39.580Z
Answers.UserDisplayName: Brad Bell
Body: <p>Is there any plan on supporting SQLite someday? It would be very interesting for small instances where we can't create any MySQL or MariaDB databases for example (in my case, free tier hosting coming with the domain name which offers PHP, 30Mb storage but no MySQL database).</p>
  
  <p>Thanks a lot!</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-02-17T20:02:47.130Z
Comments.Text: You might be better off asking your question on https://github.com/craftcms/cms/issues, as a feature request.
Comments.UserDisplayName: Paul
Tags: <database>
Title: SQLite database support
ThreadText: # SQLite database support
  
  (Asked by: username_0 on 2020-02-17)
  
  Is there any plan on supporting SQLite someday? It would be very interesting for small instances where we can't create any MySQL or MariaDB databases for example (in my case, free tier hosting coming with the domain name which offers PHP, 30Mb storage but no MySQL database).
  
  Thanks a lot!
  
  **Tags:** database
  
  > **Comments:**
  > **username_1**: You might be better off asking your question on https://github.com/craftcms/cms/issues, as a feature request.  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_2 on 2020-02-18. Score: 0 | Accepted answer
  
  We've looked into it before as I agree, it'd be awesome. But as of February 2020, the answer is no because SQLite is missing some key features that Craft currently relies on: <https://www.sqlite.org/omitted.html>
  
  Specifically the missing joins and alter table commands.
  
  > **Comments:**
  > **username_3**: libSQL added some features, did you have a look if it would now be possible? It would be such a boon to DX https://github.com/tursodatabase/libsql  
  
  ---
  
  