Questions tagged as 'sqlite'

Tagged questions
3
answers

How to make case-insensitive comparisons in SQLite?

As there is an obsession with questions with accents, here's mine:) SQLite allows you to make direct comparisons or through like with any encoding / charset from byte to . It only allows comparisons to be made regardless of case...
asked by 09.01.2014 / 14:01
1
answer

What is the SQLite storage limit?

There is a new demand for the company application where I work, I need to store more than 100k of records in different tables, I'm worried if SQLite will handle such a demand, my question is: Does SQLite have a storage limit? The type of d...
asked by 27.08.2015 / 15:40
3
answers

Is it possible to use SQLite as a client-server?

Is there any technique or tool to use SQLite using a Client-Server architecture instead of local access? Of course you would need a client library to communicate with the server. And a server application to handle these connections and acce...
asked by 24.01.2014 / 01:30
3
answers

When to use SQLite?

When should I and should not I use SQLite? I have a project that I plan to do I have no idea how many tables are going to be, but I believe more than 15 with at least a thousand lines in some tables. Would it be feasible to do it in SQLite...
asked by 26.11.2015 / 10:58
5
answers

How to manage a SQLite connection between multiple concurrent threads?

So I'm having some problems with my connection to SQLite, where I'm not finding a workaround. Scenery My scenario is as follows: I synchronize the data of my application with a legacy system through a WebService; Synchronization is...
asked by 20.02.2014 / 14:35
2
answers

Sqlite error on Android: error code 11: database disk image is malformed

I have a version of the Application in production, where it is allowed to mark a message as a favorite, but this totally random error happens causing database corruption and resulting in application failure. I know that I do a little risky o...
asked by 15.12.2013 / 12:33
1
answer

What is the best way to store monetary values in SQLite?

this post about the lack of precision of double , and practically all the links of the post links. So I realized that this was a vulnerability of my software in production (since I have rounds for every corner before doing...
asked by 05.08.2015 / 16:57
1
answer

Using Sqlite on Android with Phonegap

Well, I have a little problem ... I'm doing an application and I'm using sqlite on android to save a copy of my database, so far it's fine, it's working, it's copying the data the only problem I found is this. To make it clear I'm putting the...
asked by 09.10.2015 / 16:06
1
answer

How to compile the database to install together with a C # application?

I'm developing a C # application, and I need to know if I can build the database to install with the application, I've already seen something here about SQLite, but I do not know the tool and I do not know if it stores images, my case will have...
asked by 18.12.2015 / 06:25
1
answer

Why does the SQL language vary from DBMS to DBMS?

I was used to using SQL for web projects, always using MySQL. One day I had to write a C ++ program that used databases. At first I chose SQLite but needed other computers on the network to connect to the database. So I opted for PostgreSQ...
asked by 29.08.2018 / 20:37