Most voted "sqlite3" 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.
Learn more…142 questions
Sort by count of
-
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…
-
8
votes2
answers2322
viewsHow to ignore accents in an SQL query?
How could I perform a query ignoring words with letters that contain accents? Example of words: Olá, é, Lógica, Pão I tried using the command collate noaccents as follows: select c.* from Curso c…
-
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…
-
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?
-
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…
-
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
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
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
answer153
viewsHow to write fields with sqlite3 accent via Python?
Hi, guys! I’m making a small program in python and using sqlite3 to save the database. The program is entering, reading and deleting data in the database called "position". I wonder if there’s a way…
-
3
votes2
answers830
viewsConnection BD C# Sqlite
I have a small application on C# where the database was established in the SQLite, initially to run only locally. But now I need it running on 2 other machines besides the server. I thought about…
-
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
answer1403
viewsDecimal values being rounded in Sqlite
After migrating my database from Access to Sqlite 3 in a Windows Forms application, I have been having difficulties with Decimal values. If I run a simple select: SELECT * FROM Item WHERE id = 1;…
-
3
votes2
answers230
viewsSub-consultations with SELECT declaration in Sqlite
I have to return two values in my query and do not know if it is possible to do this in a single select... I wanted a better explanation to understand how to make a subselect on Sqlite. I have the…
sqlite3asked 7 years, 1 month ago Edu Mendonça 2,564 -
3
votes1
answer856
viewsDjango + Python how to update a table item
Hey, guys, I have a registration flow where in a first step save the student and then the data of the responsible, however, after that I need the student to make a description and this description…
-
2
votes1
answer1489
viewsDjango - Error saving to Database
The data is not being saved in the database and Django is not generating Error, but when I create an object of Livro and try to save by shell it returns me the following error: Valueerror: invalid…
-
2
votes1
answer166
viewsNodejs + sqlite3: error retrieving information from Select
I’m learning nodes. I am trying to integrate it to Sqlite3, but when trying to read a database information is being generated the following error:…
-
2
votes1
answer604
viewsCall to Undefined Function transliterator_transliterate() in php 5.512 using wampserver 2.5
I am studying SQLITE3 and PHP and checking an example of the PHP Manual appeared the following error: Fatal error: Call to undefined function transliterator_transliterate() Example:…
-
2
votes2
answers1877
viewsHow to check if there is any sqlite database in the application?
I have the following dilemma: I’m setting up an app where I perform a synchronization between a Mysqle database and Sqlite using a Webservice. My database is already available in Mysql, and in my…
-
2
votes1
answer42
viewsError in sqlite3 Foreign or foreigin
I created a database on sqlite3 in version 3.9.2 and had problems with Foreign key. alter table table_01 add column tab_2 integer foreign key references table_02(id); // Esse deu erro de sintaxe no…
sqlite3asked 8 years, 9 months ago Brumazzi DB 4,345 -
2
votes2
answers738
viewsProblems trying to save to "POST" = "no-such-table" Django / Python database
I’m following a course by Python and Django, and the problem begins when the version in the course is 1.1.2 and mine is 1.8.2 I managed to generate a form to save "Events" however, when clicking on…
-
2
votes0
answers275
viewsExternal database is not loading on android
I need to make an application Android who accesses a servidor, low files .s3db and query about the downloaded files. I can download normally to data/data/meu-pacote/databases/ and I can also do…
-
2
votes1
answer173
viewsSqlite - Too Many levels of Trigger recursion
I’m getting the error below when I try to make an insertion in Sqlite. Error while executing SQL query on database 'BDTESTE': Too Many levels of Trigger recursion Table creation CREATE TABLE…
-
2
votes1
answer190
viewsHow to check if a Sqlite3 Database is valid?
I was testing and seeing what happens if android create a database with wrong input values. For example, if I unintentionally typed NOOT instead of NOT or INTEGET instead of INTEGER, I expected SQL…
-
2
votes0
answers55
viewsPHP error with PDO and SQLITE, Call to a Member Function execute() on bool
Hello, can anyone see why this error is apparently all right function verificarImportados(){ define("DB_DSN", "sqlite:host=localhost;dbname=dbXML.db"); define("DB_USERNAME", " ");…
-
1
votes1
answer236
viewsPROBLEM WITH SQLITE - View with several selects
I have three tables that I have to take a dice in each to make an algorithm in the app, only I would like to know if there is a view that brings me this three data that are in the different tables.…
-
1
votes1
answer148
viewsKeep object alive in memory for another class
Hello! I have a very simple doubt, because I have already found a solution for it, but it still seems problematic. I will explain: I created a connection with web service to receive some data, and…
-
1
votes1
answer1986
viewsProblem Inserting Into SQLITE Table Using RAD STUDIO XE6
Good Afternoon, I have a problem in my code, use Rad Studio XE6 connected to a base SQLITE, when I insert values with point in the table occurs the following error for example = 'near "6.75":syntax…
-
1
votes1
answer258
viewsWhat are the main programming languages that integrate Sqlite?
What are the main programming languages Sqlite as SGBD in your code?
-
1
votes1
answer1846
viewsSqlitestudio types of data
I’m using Sqlitestudio to model a database. When creating the fields of a table, I noticed that it has some data types that do not appear in the Sqlite documentation. For example, in the combobox…
-
1
votes1
answer630
viewsEncrypt Sqlite3
There is a free way to encrypt Sqlite3 database? I’ve seen some pretty expensive proprietary software.
-
1
votes1
answer1140
viewsError creating database with sqlite
Colleagues, I am trying to create database on a computer with the Sqlite. It is installed and everything OK, but when trying to create using the command by cmd: C: Users José Roberto>sqlite3 C:…
-
1
votes1
answer254
viewsException when searching in Sqlite bank
12-10 09:25:36.029: D/dalvikvm(21543): VFY: replacing opcode 0x6e at 0x0002 12-10 09:25:36.279: I/Adreno-EGL(21543): <qeglDrvAPI_eglInitialize:410>: EGL 1.4 QUALCOMM build: () 12-10…
-
1
votes1
answer711
viewsUpdate in Sqlite Table via Imagebuttom Android Studio
I have a project that I am developing in Android Studio where I use a Custom Adapter, an Employee and a Databasehelper. What happens, I use a database already populated that is in the Assets folder,…
-
1
votes1
answer55
viewsHow to represent in the database (android sqlite), a class that extends another?
Hello, I’m working on android, I have a case where a table extends another. example: table Exercise -> String dataInicio, String description ...... etc table Football -> String timeInicio, Int…
-
1
votes1
answer120
viewsSQL to notify a confirmed date 2 days before the same in Sqlite
Dear Programmers I am beginner and would like to know how do I make an sql notify me of a certain date in the database, for example: 28/06/2017 I want when I arrive two days before give me a return…
sqlite3asked 7 years, 5 months ago José Raimundo Neris 17 -
1
votes1
answer103
viewsCheck records for the same month
I’m having trouble searching the sqlite3 database, records for a specific month, I searched the internet but I couldn’t find anything that could help me. I have an Account template that has…
-
1
votes1
answer41
viewsLuasql(Sqlite3) accepting only a "value"
I’m trying to create a simple table, just with names, but when I enter a value, I can’t enter any more. Like I’m doing: require 'luasql.sqlite3' local env = luasql.sqlite3() local con =…
-
1
votes1
answer47
viewsHow to view and maintain an Sqlite database
Hello, I have recently started to study the Sqlite database and I would like to know if there is a way to view my tables and the database structure itself in full, equal to pgAdmin and Mysql…
-
1
votes1
answer346
viewsError: Undefined reference to 'sqlite3_open'
I am creating a software in C that uses Sqlite 3 as database, however, when compiling the project Codeblocks returns me the following error message: createdata. c|| undefined reference to…
-
1
votes1
answer438
viewsDatabase loca + Node.js
I am working on a project using Node.js. I need to use a local database, but I wanted to reconcile performance with security, and if possible, portability as well. I only know MS Access (.accdb) and…
-
1
votes0
answers54
viewsHow to remove lines in Pyqt
I need to remove a row from Pyqt’s table. In fact it loads the lines according to the filter. But at the time it will open it pulls the ID of the lines out of the filter, how to solve this?
-
1
votes0
answers61
viewsMultiple update commands separated by ";" (dot and comma) in Sqlite!
Problem I am trying to apply the following script/command to a version of my Sqlite database: UPDATE UF SET DATE_CREATE = DATE_UPDATE; UPDATE CIDADE SET DATE_CREATE = DATE_UPDATE; UPDATE CLIENTE SET…
-
1
votes0
answers297
views"Invalid class Typecast" when loading stream from Sqlite (Delphi)
I’m trying to find an image I’ve already entered in my Sqlite database, however on the line ms:=query.CreateBlobStream(query.FieldByName('imagem'),TBlobStreamMode.bmRead); have error "Invalid class…
-
1
votes1
answer31
viewsError collecting va_list value in C
Good afternoon. I came across a problem at the time of preparing the va_list in c. of two similar codes, one works and the other persists in error. extern bool _sqlite3_insert(const char *table,…
-
1
votes1
answer1287
viewsReturn from a sub menu to the main menu of a Python function
I created a simple Python application for an agenda system with Sqlite3. There are 3 files in the main menu agenda.py the of contato.py and usuario.py who log in to the system. In the file…
-
1
votes1
answer402
viewssqlite3.Operationalerror error
I’m having a problem with sqlite3 in python, can anyone help me? the mistake is this: :~$ python3 05_create_data_param.py Nome: Henry Elias Carlos Eduardo dos Santos Usuário: Henry94 Senha:…
-
1
votes0
answers29
viewsaccess database data from a specific colula
I have a database with a list_students table, str(name) field and str(serie) field, someone can explain me why I can’t access the names that contain only the series I passed? conn =…
-
1
votes1
answer46
viewsProblem with logging in using sqlite
My method is not returning the professor logged in. public Professor autenticarUsuario(String usuario, String senha) { String SQL = "select * from PROFESSOR where USUARIO = ? and SENHA = ? ";…
-
1
votes1
answer950
viewsHow to return data from a select in sqlite3 as dictionaries instead of tuples in Python?
I’m using sqlite3 to record some data. However, by default, when a select is made, it returns the information as a list of tuples, which is considerably harder to work with than if they were…
-
1
votes1
answer245
viewsbeforeupdate sequelize does not work
I am trying to make the data update encrypted the user password but simply does not work and does not issue error. Have the following model of sequelize. import bcrypt from 'bcrypt'; export default…