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
-
4
votes1
answer382
viewsSize occupied on disk by a table in Sqlite
In Oracle, when we want to know how much a table occupies disk we can make a query to the dictionary dba_segments. SELECT segment_name, segment_type, bytes/1024/1024 MB FROM dba_segments WHERE…
-
4
votes1
answer2155
viewsRead values from a table in Sqlite
I am in need of a help in the following situation: I need to take the values of a column in the bank and write these values in a variable, and then this variable will randomly generate one of these…
-
4
votes2
answers322
viewsSearch simple data Sqlite
I want to return only two simple data in TextView using SQLite. I have a common "Products" table and another temporary table "Information" I use SUM() to add the column of the first table. Dbhelper:…
-
4
votes2
answers683
viewsHow to run INSERT only if the record does not exist?
I’d like to wear something like sqlite insert into table (column) values ('')if not exist;…
-
4
votes1
answer1422
viewsPassword validation saved in Sqlite
Hello I’m doing a project for college and I’m new on Android,I’m making an application that the purpose of it is to check if the password is correct to be able to finalize the application, but I’m…
-
4
votes1
answer356
viewsDatabase Locked Sqlite/Java error
I have the following problem: in an Insert that I am trying to accomplish, I don’t know if it is an error in the database or something in the java programming, but every time I try to perform an…
-
4
votes1
answer678
viewsError while recovering data from Sqlite
I’m starting to work with database and I’m already in trouble. I ask for a hand! Well, I have a database, apparently, there’s no mistake in adding data to it. I have a Dbhelper class that inherits…
-
4
votes1
answer62
viewsLITE ORM problems in saving columns bytes
My app the user can use the camera to take photo and need to save it in the database. To save in the database I convert the image into an array of bytes, however I noticed a problem in this process…
-
4
votes1
answer1085
viewsHow to define a composite key table in Sqlite?
I am making an embedded database as a field medium in the integration between two systems. The system A, where you have the data, export all your data to the system B already properly mapped.…
-
3
votes1
answer599
viewsStandard Java design for code reuse
I am developing a simple program in Java Desktop using SqLite to store local data, I would like to know which design pattern I can use to reuse the codes Java to develop the same application for…
-
3
votes2
answers1157
viewsRails 4: Changing the "Development" database from Postgresql to Sqlite3 makes the Rails server error
Hello. For some reasons, I had to change my DB "Development" from Postgresql Rails back to Sqlite3. Only the page has stopped working and the error that appears in the server Rails output is this:…
-
3
votes1
answer70
viewsFilter month on Qsqltablemodel
How do I filter the month on QSqlTableModel? I’m doing like this: model = new QSqlTableModel(this); model->setTable("tabela"); // db sqlite model->setFilter("strftime('%m',…
-
3
votes1
answer1829
viewsExport Mysql database to Sqlite
I usually use a database in the applications I develop locally. With the mysql whenever I need to work clone the application to another machine, I need to generate a dump bank and import at local…
-
3
votes2
answers226
viewsError performing Insert on an Android application: "Empty bindArgs"
Explanation: I have an android app that was made using the ADT (Android Developer Tools) I use the bench sqlite and eventually perform some operations such as insert or update and also some…
-
3
votes1
answer846
viewsJSON or Sqlite?
I’m developing a simple app on PhoneGap and I will need to have basically 2 tables. One to store the names of the series and another to store the exercises of each specific series. But I’m not sure…
-
3
votes1
answer205
viewsSqlite - count primary keys that were not referenced as foreign key
First, I am trying to count the primary keys of a table that WERE and WERE NOT referenced as a foreign key in another table. Also, I want to filter the search using the clause LIKE to show only…
-
3
votes1
answer886
viewsWhat is the Journal file on Android
When I created a database in Sqlite on Android, I noticed a file with the table name, followed by -Journal. What is it and what it’s for? Strange this file have different permissions and use a table…
-
3
votes2
answers1246
viewsCount number of records in a database
I want to count the number of records in a database table. I have 3 records in my DB, but the result is always 1. I used this code: $base_hndl = new SQLite3("p.sqlite"); $select = "SELECT COUNT(*)…
-
3
votes1
answer1552
viewsHow to connect to an existing Sqlite database using PDO?
I want to connect to a database that already exists using PDO and sqlite in PHP, and here is the code I have: class Database extends PDO{ public function __construct(){ parent::__construct("sqlite:…
-
3
votes2
answers1863
viewsAndroid - How to export the database in a csv file?
I have an application that collects and stores information in a database, and the user can query this data within the application itself. However, I would like to insert a button to export the…
-
3
votes2
answers2124
viewsHow to save an Sqlite database table to a text file on Android?
I have an application that saves data from a form in an Sqlite database table. Until now, just consult this data within the application, no problems. Example: My form saves information such as name…
-
3
votes1
answer113
viewsIs there a problem using multi-thread software with Sqlite?
Are there problems using multi-threaded software with an Sqlite database? This database will only have one connection, but the software that will access it is multi-thread (application server). Is…
-
3
votes1
answer1008
viewsInstall database together with C#
I am finalizing an agenda of the meeting room that will be in the company reception, so I opted for the base to be locally and not networked. I intend to use Mysql or Sqlite. Is there any way I can…
-
3
votes4
answers4241
viewsHow to get the amount of records in a query in Sqlite?
I am listing the records of a table with the code below: SQLiteCommand comando = new SQLiteCommand("SELECT * FROM Cadastro " +filtro, conn); SQLiteDataReader receber = comando.ExecuteReader(); But…
-
3
votes1
answer508
viewsShow Local Database data on screen, Ionic
The function that makes the select and roll the dice to result that’s the one: $scope.queryAndUpdateOverview = function(){ f_Select("SELECT * from cadastroPessoa",[], function(results){ $scope.dados…
-
3
votes1
answer3161
viewsSynchronize Local Database from Remote Server on IONIC
Personal how to update a database in a mobile application every time the remote database is updated. For example I have an application in Ionic, and to get faster I use the database of contacts…
-
3
votes1
answer250
viewsFirst element in listview does not appear
I have a listview that lists through an Adapter. The list is updated after a Sqlite search. The problem is that it only appears from the second element of my table.... someone could help me?…
-
3
votes2
answers225
viewsMigrate data from one version to another - Android Sqlite
In the application I am working on, I have to save the data from a specific table when the application is updated. This action needs to happen before the table is discarded in the onUpgrade method.…
-
3
votes1
answer1804
viewsSelect taking the difference between Sqlite dates
I wanted a select to give me the following sentence comparing two dates, example: "2015-03-12 13:00"e "2015-03-12 14:15". My return would be something like: 0 days 1 hour and 15 minutes to go... I…
-
3
votes1
answer331
viewsSave Operations log to database with system user field
Hello, would like to know how to by means of triggers in the bank I get beyond saving the operations performed and in which table held also the user logged into the system (not the bank user, if the…
-
3
votes1
answer457
viewsSave information to an Sqlite and then go up to a JSON with webserive
I read several tutorials on how to take a JSON and pass the information to an Sqlite, but as I do the reverse, I take the application data already saved in Sqlite and then transfer them to a…
-
3
votes1
answer2296
viewsFormat date on Android and Sqlite
I am having difficulty in making the process of setting the current date of my Sqlite database in the type attribute java.util.Date of my object. The Sqlite date comes in "yyyy-MM-dd" format. I am…
-
3
votes2
answers1472
viewsDatabase for mobile devices
I’m creating a mobile app and need to use a database to store user data. I’ve thought about Sqlite, but it is not recommended to use it on sites with more than 100 thousand requests per day, and if…
-
3
votes1
answer151
viewsError in Trigger Sqlite
I’m trying to create this trigger in the SQLite, but I don’t know if it’s possible. I got a big one Remedios and a Manutenção. I want that when I have an insert in the table Manutenção, it does an…
-
3
votes2
answers1914
views -
3
votes2
answers187
viewsError save data from sqlite register
I am in error when saving data from a people register in Javanullpointerexception sqlite: invalid int:(51)3452-2470. This error started to occur after I applied a mask. Follow the codes below.…
-
3
votes2
answers331
viewsI cannot enter user-defined values in Sqlite
I have a problem where I can not add anything in the table and always appears the error: sqlite3.Interfaceerror: Error Binding Parameter 0 - probably Unsupported type. The code I’m trying to add…
-
3
votes2
answers810
viewsSqlite Database does not work on Unity Games compiled for Android
I’m using the Sqlite as a game database made in Unity that works perfectly on Unity Editor, but when I build for Android the game simply does not access the bank (nothing is informed or released).…
-
3
votes2
answers223
viewsWhich database is ideal for my scenario?
I am developing a commercial automation system (C# and Windows Forms) that can be installed on one or several machines on the same local network. I did the part mobile system, where it is possible…
-
3
votes1
answer261
viewsC#,SQL,SQLITE How to return SQL command from an action
I have a question in C# and SQL commands, I am currently using Sqlite as a local database. In my application I enter entries in the database, so far so good, but I wanted to know if there is any way…
-
3
votes2
answers3700
viewsHow to Format/Separate Date and Time from a sqlite datetime field
I have the table Pitches with the following fields: CREATE TABLE [LANCAMENTO]( [ID] INTEGER PRIMARY KEY ASC AUTOINCREMENT NOT NULL UNIQUE, [VALOR] DECIMAL(8, 2), [DATE_BUY] DATETIME, [DESCRIPTION]…
sqliteasked 7 years, 1 month ago Edu Mendonça 2,564 -
3
votes2
answers57
viewsSuspend Trigger on parole
I did not find a SQL statenment IF in Sqlite and the closest was the CASE, that this attending me, meanwhile would like to suspend a Trigger upon a conditional and believe that can only be done with…
-
3
votes1
answer298
viewsHow to set SELECT values in Textview?
I have the following class for bank appointments: package com.example.tais.books.Dados; import android.content.Context; import android.database.Cursor; import android.database.sqlite.SQLiteDatabase;…
-
3
votes1
answer55
viewsIs there anything equivalent to Mysql’s "FOR UPDATE" in Sqlite?
As the title itself says, there is something equivalent to FOR UPDATE Mysql in Sqlite? Example: SELECT id FROM minha_tabela WHERE id=1 FOR UPDATE I own a query that uses a unique line lock within a…
-
3
votes0
answers108
viewsError when connecting external database
The following error appears E/MYSQL: Erro: java.lang.ClassNotFoundException: org.sqlite.JDBC.Driver E/MYSQL: Erro: java.sql.SQLException: No suitable driver E/MYSQL: Erro:…
-
3
votes1
answer233
viewsError executing delete in Sqlite database
I’m having a problem with my project Android. When I execute a delete at the bank sqlite, I get as return the following log message: W/FileUtils: Failed to chmod(/storage/sdcard/Cardapio…
-
3
votes2
answers2936
viewsHow do I search the table with Sqlite?
Good guys, how do I make a select in a table using Sqlite on Android? So far I have the table created and the Insert. For example: search by User login and password, to be able to compare. Follows…
-
3
votes1
answer6369
viewsHow to build a SELECT on Sqlite?
I am new in Android development, I am using Sqlite as a bank. I need to make a SELECT, and return the values of three columns of my table. Then I need to set the attributes of my object with the…
-
3
votes1
answer1007
viewsAndroid - What is the difference between getReadableDatabase() and getWritableDatabase()?
I was able to enter information in the database using the method getReadableDatabase(). In that case shouldn’t it be wrong? Shouldn’t it be the method getWritableDatabase()? private void savePet() {…
-
3
votes1
answer275
viewsSeparate line contents in the Bufferedreader loop
I have files txt with approximately 5,000 items, and these do not have a pattern, for example: 10 20 30 40 50 60 70 80 90 100 I need to import this into the SQLite, where each value is 1 record.…