New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Using SQlite with openSupports #160

Open
nickbe opened this Issue Feb 20, 2018 · 6 comments

Comments

4 participants
@nickbe

nickbe commented Feb 20, 2018

Is it possible to make OpenSupports work with SQlite?

@ivandiazwm

This comment has been minimized.

Contributor

ivandiazwm commented Feb 25, 2018

It looks like redbean (orm we use) is compatible with PostgreSQL, SQLite and CUBRID. https://redbeanphp.com/index.php?p=/connection

I think it would make sense to add a "db type" field on installation to support this.

Thanks!

@nickbe

This comment has been minimized.

nickbe commented Feb 25, 2018

Thanks for supporting this feature.

@nickbe

This comment has been minimized.

nickbe commented May 3, 2018

I have installed OpenSupports locally on a clients notebook. If we could use sqlite I wouldn't have to use mySQL or a WAMP stack at all for that. I think providing a single user version for windows which can be used only by utilizing php.exe -S 0.0.0.0 -t . would be a great help for guys like him. He's a carpenter and uses openSupport now to track his projects. :)

@ivandiazwm ivandiazwm added the v4.5 label May 18, 2018

@nickbe

This comment has been minimized.

nickbe commented Sep 8, 2018

Is this already in the current codebase?

@mredigonda

This comment has been minimized.

Collaborator

mredigonda commented Sep 12, 2018

No, it's not in the current codebase.

If we add SQLite as a supported database, I think we should add a warning, since it might not be appropriate to use with a high-traffic website.

@nickbe

This comment has been minimized.

nickbe commented Sep 12, 2018

Well in our experience SQLite can handle much more than people think it can - given that the right fields are indexed. But your right of course when it comes to very large company sites with hundrets of users. But then I don't think for example the current opensupport listviews are actually made for such environments in the first place.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment