The develop branch of Frappe Framework supports sqlite as of today.
You can try it out by creating a new site:
Update dependencies: bench setup requirements
New site: bench new-site test --db-type sqlite
It will have some issues, if you find any, please do post here, or open a GitHub issue (or a pull request if you can fix it!)
This won’t be backported to previous versions, it will be available in the upcoming v16 release - for now the only way to try it is to use the develop branch.
Great. So its only supports upcoming version of v16 and dev branch ,Right?
Will ERPNext be supported also?
Not anytime in the near future. SQLite does have some limitations, not sure how suitable it’d be for an app like ERPNext.
I do aim to have all the other newer (smaller) apps supported though.
The major issue I see to support ERPNEXT with SQLite, is related to MySQL functions!
ERPNext uses it in many places, and this can be the major source of incompatibility!
Luckily the SQLite standard module allow the registry of python functions, to solve this gap, but will introduce more code to be maintained just because that wrapper
These exist as C/ integrated functions in the wild. I think this is probably a better path than Python.
@tmatteson thanks for the link, but this still don’t guarantee compatibility with MySQL functions!
Naming conventions and positional parameters, need to be ensured, also, the function behavior
Yes, the solution to both is to use a use multisql interface, which Frappe already has. It’s also the same solution to Postgres compatibility.