Skip to content
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

SQLITE Support #12

Open
tuefekci opened this issue Feb 22, 2024 · 0 comments
Open

SQLITE Support #12

tuefekci opened this issue Feb 22, 2024 · 0 comments
Assignees
Labels
help wanted Extra attention is needed wontfix This will not be worked on

Comments

@tuefekci
Copy link
Owner

The App theoretically should operate smoothly with SQLite, but numerous challenges persist:

  • Concurrency Issues: Although SQLite supports concurrency, accessing the database concurrently often results in frequent access errors.
  • Syntax Limitations: SQLite theoretically supports all necessary syntax; however, the PHP library may lack support for certain operations, such as 'drop', potentially due to outdated versions.
  • Random Operational Challenges: Occasional access restrictions or file corruption issues arise unpredictably, complicating database management.

Despite prolonged efforts to exclusively utilize SQLite for database operations, the persistent challenges have become tiresome. Consequently, I've opted to implement a version compatible with MySQL and potentially Redis. After resolving immediate needs with alternative solutions, I may revisit SQLite optimization in the future.

@tuefekci tuefekci added help wanted Extra attention is needed wontfix This will not be worked on labels Feb 22, 2024
@tuefekci tuefekci self-assigned this Feb 22, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
help wanted Extra attention is needed wontfix This will not be worked on
Projects
None yet
Development

No branches or pull requests

1 participant