How do I open an .sqlite file?

How can I deal with concurrent updates on a JavaScript app that is interacting with a SQLite file on Dropbox?

  • I am consulting for a small business that needs to keep track of its contacts and activities. Its requirements are fairly simple and a simple javascript app backed by a SQLite file in their Dropbox would do, but how could I deal with the potential mess caused by concurrent updates? I am hesitant to develop a web app because there isn't much competence there and I would came up with the burden of managing it. Any suggestions?

  • Answer:

    I think choosing a SQLite file synced by Dropbox isn't the right choice here. You might want to consider something like FireBase (https://www.firebase.com/).

Matan Lurey at Quora Visit the source

Was this solution helpful to you?

Other answers

In the nicest possible way, this sounds like a recipe for disaster ! It sounds like what they are looking for is a CRM system ? If so, the last thing you should be doing is developing your own from scratch (aka reinventing the wheel). There are many solid CRM solutions to choose from, either self-hosted or software as a service (recommendation: go for SaaS, you probably don't want to be lumbered with the hassle of maintenance / software updates).

Simon Gardner

Related Q & A:

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.