Most voted "sqlite" questions
Sqlite is a C-language library that implements a built-in SQL database. Programs that use the Sqlite library can have access to SQL database without running a separate DBMS process, not requiring service configuration.
Learn more…652 questions
Sort by count of
-
38
votes3
answers2673
viewsHow to make "case-insensitive" comparisons in Sqlite?
Since there’s an obsession with accent questions, here goes mine :) Sqlite allows direct comparisons or through like with any encoding/charset as long as it’s done byte to byte. It only allows…
-
21
votes1
answer6034
viewsWhat is the storage limit for Sqlite?
A new demand for the application of the company where I work, I need to store more than 100k of records in different tables, I’m worried if the Sqlite will withstand such demand, my question is:…
-
19
votes3
answers9326
viewsIs it possible to use Sqlite as client-server?
There is any technique or tool to use Sqlite using an architecture Client-Server instead of local access? Of course you would need a client library to communicate with the server. And a server…
-
15
votes3
answers5035
viewsWhen to use Sqlite?
When I should and should not use Sqlite? I have a project that I intend to do I have no idea how many tables will be, but I believe that more than 15 with about a thousand lines in some tables. It…
-
12
votes1
answer2421
viewsWhat is the best way to store money in Sqlite?
Li that post on the lack of precision of double, and virtually every link in the post. Then I realized that this was a vulnerability of my software in production (since I have rounds to every corner…
-
12
votes1
answer398
viewsWhy 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 in the network to connect…
-
10
votes2
answers1364
viewsSqlite error on Android : error code 11: database disk image is malformed
I have a version of the App in production where it is allowed to mark a message as favorite, only that this totally random error happens provoking corruption of the database and resulting in…
-
10
votes5
answers2656
viewsHow to manage a Sqlite connection between multiple simultaneous threads?
So I’m facing some problems with my Sqlite connection, where I’m not finding a skilled solution. Setting My scenario is this:: I synchronize the data of my application with a legacy system, through…
-
10
votes1
answer3282
viewsHow to compile the database to install together with a C#application?
I’m developing an application in c#, and I need to know if I can compile the database to install together with the application, I’ve seen something here talking about Sqlite, but I don’t know the…
-
9
votes2
answers144
viewsIs it redundant to use LIMIT in a QUERY whose ID is the primary key?
My question is if using LIMIT there will be some performance gain in the QUERY. Example: SELECT descricao FROM produto WHERE id = 9999 LIMIT 1 Has better performance than? SELECT descricao FROM…
-
8
votes1
answer480
viewsIs there a way to open a direct SQL table in a data.table, without doing the SQL path > data.frame > data.table?
I want to open a direct SQL table in a date.table. When I do a query with dbGetQuery, what I get is a data.frame. I know I can then turn that data.frame into a data.table easily. But I would like to…
-
8
votes1
answer466
viewsUsing Sqlite on Android with Phonegap
Guys, I have a little problem... I’m making an application and I’m using the sqlite on android to save a copy of my database, so far it’s okay, is working, is copying the data the only problem I…
-
7
votes2
answers1017
viewsPrevent DROP TABLE
I would like to prevent deletions on a table in Sqlite. CREATE TRIGGER nao_deletar_tabela BEFORE DELETE ON tabela BEGIN SELECT RAISE(IGNORE); END; It worked! Whenever one runs DELETE, nothing…
-
7
votes1
answer181
viewsIs the "Row ID" equal to the primary key?
The function Insert of Android returns a row ID according to the documentation, the Row ID of the Newly inserted Row, or -1 if an error occurred To row ID corresponds to the primary key, ID, if…
-
7
votes1
answer740
viewsSqlite and Mysql synchronization
I have an application in which I have a database using Sqlite and an external service using Mysql. Basically it’s a task application, where I can create a task in mode offline. When the user has…
-
6
votes2
answers441
viewsHow to make a "rbind" in tables of an SQL base from R?
I would like to "merge" two tables of a Sqlite "database" from the R -- and save it to a new table within the same database. Below, I send a minimum reproducible code:…
-
6
votes3
answers5260
viewsLaravel: Migrations
I have a question about Migrations do Laravel and I believe you can help me. 1 - I created a model with Migration by php artisan make:model Evento -m; 2 - In addition to increments and timestamps I…
-
6
votes0
answers292
viewsSave multiline text in Blob field on Sqlite
I would like a hand in this matter of saving a EditText multiline in a blob field in the Sqlite database, because when I add ContentValue values.put(CriaBanco.OBS, pedido.getObservacao()); in the…
-
6
votes2
answers12679
viewsWhere to find the android database path?
SQLiteDatabase BancoDados = null; String NomeBanco = "Cadastro"; CriaBanco(); public void CriaBanco(){ try{ BancoDados = openOrCreateDatabase(NomeBanco, MODE_WORLD_READABLE, null); String SQL =…
-
6
votes1
answer228
viewsProblem to execute a query in Sqlite
Table statement @DatabaseTable(tableName = "alarmes") public class ListenerAlarme { @DatabaseField(generatedId = true) public long id; @DatabaseField(canBeNull = true) public Date dataAlarme;…
-
6
votes4
answers8334
viewsHow to list all tables in a Sqlite database?
In Mysql, when I run the command SHOW TABLES I can see all tables present in a given database. And in the case of Sqlite? How can I do this?
-
6
votes1
answer396
viewsOrder by command with Sqlite accent
I am programming for Android and using the native database(SQLite). I want to make a query in the product table ordered by name, but while doing the SELECT thus: SELECT * FROM produtos ORDER BY…
-
5
votes1
answer1117
viewsI cannot enter data into the sqlite using javascript
I’m creating a smartphone app using Cordova for a college project. The App consists of a simple patient registration. I’m having trouble recording data in the database. Initially the recording was…
-
5
votes1
answer1111
viewsAndroid Sqlite data insertion
What is the best way to insert more than 10000 rows of data into a 13-column table using Sqlite Android? I thought of using the ContentValue then: Db.insert(DATABASE_TABLE, null, ContentValue);…
-
5
votes2
answers2666
viewsBackup in Sqlite database
I need to backup an Android Sqlite database. Ex: I will change device and need to copy the application BD to be loaded on other Android phone. Is there any viable solution? I developed an…
-
5
votes1
answer3364
viewsOffline database on Phonegap app
I’m creating an app with Phonegap and need to consume/manipulate information from an existing Sqlite base within my directory WWW but in 3 days looking for tutorials only found ways to create the…
-
5
votes2
answers4323
viewsHow to update BD sqlite java android
How do I add a column in the database of my android java application without losing data from the current database? My code: public DataBaseHandler(Context context) { super(context, DATABASE_NAME,…
-
5
votes1
answer996
viewsIncluding in APK an Sqlite database
Is it possible to include the application database in the APK installation? I already have all the necessary records for the operation of the application and would like to include it during the…
-
5
votes1
answer1198
viewsBest way to model a chat database
I have an application that works with webservices and mysql database, I’m putting a chat in it, the part about how to pick up messages, display notifications and search for users I already have, my…
-
5
votes1
answer6498
viewsHow to Build a Webservice to Synchronize Android and Mysql Sqlite Database
I built an android app that stores basic information about a contact in Sqlite: Name, Telephone, E-mail, Address among others. I searched a little and from what I understood, what I can do is use a…
-
5
votes2
answers1026
viewsHow to resolve "Typeerror: must be Unicode, not str" error in Python?
When backing up my database on Sqlite3, the Python interpreter returns the following message: Typeerror: must be Unicode, not str on the line f.write("%s\n" % linha), I couldn’t find a solution…
-
5
votes1
answer1457
viewsHow to save locations from a map to an Sqlite database?
I plan to save sites displayed on a map to a Sqlite database so that the user can consult them in the future and add a description. Here’s my class Description... public class Descricao { private…
-
5
votes2
answers1003
viewsCan Sqlite work fully offline?
I need to save my alarms so that after the device is restarted they are put back into operation. The problem is that I get all of them through my database on mysql. What made me think that maybe it…
-
5
votes1
answer3875
viewsHow do I save an image to the database in Sqlite?
How do I save an image to Sqlite? I ask you to be as specific as possible because I don’t have much experience. In case I want to include a table row to save the image. import br.gestaoBd.Login;…
-
5
votes1
answer118
viewsFilter using calculated value does not work in Django
I have a model in Django with fields largura and comprimento, and would like to filter it by area: class Projeto(models.Model): largura = models.DecimalField(decimal_places=0, max_digits=4,…
-
5
votes1
answer610
viewsXamarin - Sqlite Join
I’m creating an app on Xamarin, which generates a sales order, and stores on mobile. I’m using Sqlite to store the data, but I’m having trouble making a Join between my Order Items table, and the…
-
5
votes2
answers190
viewsSystem modularization
I’m developing a C# system with Winforms from Livestock Control to a farm, and will communicate with a scale to improve the weighing process. Some of the features are (Bill entry, vaccination,…
-
5
votes1
answer1200
viewsHow to create a database automatically in Laravel with all tables?
Well I need help in a problem, I am developing a system for the first time in Latin and I need to create a database for each user registered in my system, these databases should have the same tables…
php database sqlite laravel-eloquent laravel-5.3asked 5 years, 6 months ago Igor De Moraes Sampaio 79 -
5
votes1
answer68
viewsCapture the index data in the database
I was able to feed my listview with Sqlite data, however, I now want to capture the data (in the database) that each line of listview matches. For example: Line 10 displays Code. 1 and Name: Felipe…
-
5
votes1
answer461
viewsRescue all nodes from an Sqlite database tree
I have a serialized tree in my database in the table arvore. Like any good tree, every node can have at most a single parent node. Your data is in this format: id | id_pai | valor…
-
4
votes2
answers313
viewsDatabase on does not reflect changes in the same Activity
I am trying to update the database in my application. Trying to simulate a possible error in production intentionally I give a DROP in a table, and soon after I do a SELECT in the same table and…
-
4
votes1
answer436
viewsTwo databases in an Android app
I have an Android application and this works with an internal database. Now I need this application to work with 2 internal databases. Is this possible on Android? Some example that can help?…
-
4
votes1
answer156
viewsHow to create a view with Crosstab in SQLITE via Android?
I have the following tables: ┌──────────────┐ ┌──────────────┐ ┌─────────────────────────────┐ │ TABLE pessoa | | TABLE lente | | TABLE pessoa_lente | ├──────────────┤ ├──────────────┤…
-
4
votes1
answer130
viewsHow do I save read-only data? Should I use Sqlite in this case?
I’m developing an app (a widget actually) that shows some sentences in home user. I have about 1000 sentences of approximately 150 characters, how will I store it? In this case the use of DB is…
-
4
votes2
answers989
viewsHow to install Sqlite to be part of a C#project?
I am creating a desktop application in C# of registration that will use database. Which database to use? I was advised to use the Sqlite, but I’m not quite sure how to use it. Which version of…
-
4
votes1
answer1159
viewsImport sqlite database already populated
I’m making an app requires only queries in a database. Since this is a very large amount of data, I think it would be counterproductive to feed this database using a insertOrThrow for each item of a…
-
4
votes1
answer421
viewsandroid - Image cache and display listview
Good afternoon, my friends, The thing is, I’m going to use Volley to get the data from the webservice, and so I write the list to my local BD with Sqlite. In this webservice will come a JSON with…
-
4
votes2
answers4252
viewsError: Undefined object reference for an object instance, how to resolve?
I have the method ChamadaEfetuada(MAluno) : bool checking whether the call was made to a particular student, this method is used in another method ChamadaEfetuada() : bool that instead of checking…
-
4
votes2
answers3075
viewsHow can I see the structure of a table in Sqlite?
In Mysql, we can use the command DESC <table> to discover the structure of a table. And in Sqlite? How could I do that?
-
4
votes1
answer748
viewsSqlite with Javascript does not work
I am knowing the Sqlite now, to try to deploy in a mobile application, I made this test based on some web codes but I can not return a recording of the data successfully, until it selects but…