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
-
0
votes1
answer746
viewsSQLSTATE[HY000]: General error: 1 no such table: when running Migration on SQLITE with Yii2
I am using yii2 for a small project, I am using sqlite to persist the data. And here is where the problem is occurring. Any table I create in sqlite yii2 does not recognize, nor does using GII to…
-
0
votes0
answers235
viewsTkinter: Treeview with repeated values after pressing "query" button
Every time I press the "Query" button treeview updates, but also by adding previous Rows. def consultar(): #função que Mostra na treeview todos os produtos cadastrados conn =…
-
0
votes1
answer1759
viewsHow to use sqlite3 with Docker Compose
Since sqlite3 banks are only files; And containers, by their own logic of scalability are created and excluded according to need; What is the best way to work with both partners? You see, I’m trying…
-
0
votes0
answers90
viewsDelete data from a db using sqlite3 and Bottle (python)
I am trying to make, using the Bottlepy framework, a CRUD in the Todo format (as in the example shown in the Bottle documentation itself https://bottlepy.org/docs/dev/tutorial_app.html). So far the…
-
0
votes1
answer55
viewsthe program does not read the data that is in the text file
The.txt rain text file contains results of pH analysis of rainwater samples. Each of the lines has (separated by ";") the date of commencement of sampling (in the form YYYY-MM-DD), the duration of…
-
0
votes1
answer253
viewsSave a list to Sqlite
I have a list of products and use recycleViwer to list them. I want to take these products and save them in the database. Being honest, I can’t do it! I’m researching but I can’t find content. I’m…
-
0
votes1
answer196
viewsHow to place an AUTOINCREMENT ID?
I’m making a login table, where you log in, add your service data and add a company to which you work. But I’m having trouble adding the user id. I want that so q the person make his registration,…
-
0
votes1
answer106
viewsSqlite3 How to delete last records using ORDER BY
I’ve researched a lot in the inter but found no solution... For example, I have an aptitude test. Hence I create a table: "Bdteste.db", with a bank: "candidates", with the fields: _id, name and…
-
0
votes1
answer132
viewsDoubt in Javascript + Sqlite3, return of Select
Hello, I need to retrieve information from a bank and display on a table. I’m using Electron and sqlite3. I have this function to do the consultation. function getTable(){ var obj = []; var aux =…
-
0
votes1
answer226
viewsSet DEFAULT value with empty string and not as NULL in Sqlite3
I created a table on sqlite determining columns with value DEFAULT. The example column is "name_fantasy" and in it I informed that it would be DEFAULT '' (Empty string). When trying to insert a data…
-
0
votes1
answer232
viewsSqlite3 syntax error
Does anyone know why you made that mistake? before using the androidhelper was working, I realized I was returning a different format, so I turned it into a string equal to a common input: def…
-
0
votes1
answer63
viewsWhy aren’t you entering the data into sqlite and how to insert images?
I’m making a system, I followed all the steps to insert the data into the table using sqlite, but when I go to the Application in the part of inspecting the browser element the database remains…
-
0
votes1
answer52
viewsINSERT INTO table1 SELECT * FROM table2 USING PDO SQLITE3
Hi, it’s been a while since I’ve been searching the entire internet and trying to make this query work. In the database works, however, I need to make my application run this query, I use PDO in PHP…
-
0
votes0
answers28
viewsFK Ismatch sqlite
Good afternoon I have an error of FK Ismatch on Sqlite that is already bothering me but I can not see the problem, follows the skeleton of the bank: CREATE TABLE CEST_Item ( CIT_ID integer primary…
-
0
votes1
answer62
viewsHow to place the value of an input inside a "cell" of a SQLITE3 table, with Python?
Hello, I’m a beginner in programming and, learning about the SQLITE3 library, in Python, I came across a problem and even after a lot of research I did not find the solution. I would like to be able…
-
0
votes1
answer137
viewsHow do I login to the database?
I am creating a study application for a simple login screen, on the same black screen. I created 2 files, one where I create the database query and the other with the application code itself. It has…
-
0
votes2
answers34
viewsLogic for SQL statement - Sum of values between Table A and Table B
To table A is the table that receives several rows containing different values related to table B which is where the items are stored. Table A Descrição | Valor item 1 | 50,00 item 1 | 40,00 item 2…
-
0
votes1
answer268
viewsInserting in a python sqlite3 database by a class
I am doing a mini project of a registration in a database sqlite3 by python, my problem is that in my method, which registers the product with (id, name, purchase price, sale price, quantity), gives…
-
0
votes1
answer60
viewsHow to login with SELECT in a table? Login system Pyside2 sqlite3
I am creating a simple login system, where the user puts the data entered in a table. But in the code when comparing the data, either it ENTERS even with blank spaces or wrong information or it…
-
0
votes0
answers29
viewsON DELETE SET DEFAULT does not work in Postgresql?
I’m trying to leave the value default 'SEM CURSO' in the student table when the course is deleted, but the way I am doing the value of the foreign key is not getting default and yes NULL. I am doing…
-
0
votes0
answers38
viewsHow do I insert previous tuples into tables in a Sqlite3 database?
I’m developing an RPG-style app using Android Studio. This app needs a database and as there is no need to be online, I am using Sqlite 3. The problem is that some data need to be previously entered…
-
0
votes0
answers22
viewsQuery Sqlite3 tables using python3 and insert the results in a Treeview in Tkinter
The purpose of the code is to do Sqlite3 searches between two dates and insert these Tkinter Treeview searches. I have the second table in sqlite3: CREATE TABLE "MOTO_PALIO" ( "cod" INTEGER, "data"…
-
0
votes1
answer53
viewsBring bank result and put in a list to use with variables
I’m working with Python 3.7. I am trying to define variables with data from a list[], the values of the list[] is a result coming from the database, but is giving error. Code: conn =…
-
0
votes1
answer36
viewsHow to rescue sqlite3 data with python?
I have an application in Tkinter (Basic registration that every apprentice does) where I saved the data in sqlite3, but I’m having difficulties in recovering this data. What I need exactly is: That…
-
0
votes0
answers24
viewsString concatenation from variables in the execute method of sqlite3 in python
I am trying to insert data into a table created in Python (module sqlite3) indirectly, that is, through variables that receive the values of inputs and not directly by typing them into the string of…
-
0
votes0
answers27
viewsDjango.db.utils.Operationalerror: Foreign key Ismatch when trying to change the primary key
Django automatically creates an Autofield for primary key if there is no field with primary_key=True, so I’m trying to remove the primary key I created (identifier field in the Client model) and…
-
0
votes1
answer21
viewsI cannot insert data into the SQLITE3 table (NODE.JS)
Whenever I try to add data the SQLITE table appears this error. Someone helps me, pfv. I’m starting at the Back-end now ;-; const Database = require("../db/config") module.exports = { async…
-
-1
votes3
answers4045
viewsDBMS to Sqlite
Can anyone recommend me a good SGBD Sqlite as I am using the sqlitebrowser to manage the databases of my Android applications, but I can’t do almost anything on it.
-
-1
votes1
answer401
viewsConvert an entire string to Sqlite
Dear I am trying to create an sql for a mobile application, sql is okay but the application gives the following error when running: "field waiting for a string and current is integer", the question…
sqlite3asked 7 years, 9 months ago José Raimundo Neris 17 -
-1
votes1
answer746
viewsSqlite giving "near "CREATE" error: syntax error (code 1):"
Does anyone know what’s wrong to be making that mistake? I/System.out: ERRO 1 :android.database.sqlite.SQLiteException: near "CREATE": syntax error (code 1): , while compiling: CREATE TABLE…
-
-1
votes1
answer52
viewsMaking a rank system
hello i am trying to create a rank system using sqlite3 and python however I am not getting anywhere,when I consult my database it returns me that: [('002', 5), ('001', 50), ('003', 80)] where…
-
-1
votes1
answer37
viewsSelecting gaps in database
I’m trying to build a select that will locate the missing items from a database. This is super unusual, 'select' the items that don’t exist. Let’s say I have a table called TBL795 with the column…
-
-1
votes1
answer1092
viewsSqlite3 - unrecognized token
Hello! You can help me? I’ve tried it in many ways, but I couldn’t understand. With up to 3 variables this way works, but with 7 variables presents the error in the image below. I’ve been stuck in…
sqlite3asked 6 years, 3 months ago Wilson Junior 182 -
-1
votes1
answer107
viewsProblems entering data into a table
I have a Python script that reads messages coming from the serial port. When reading messages, record them in a mailing list and send them to a SQLITE3 database. However, when executing, it presents…
-
-1
votes1
answer218
viewsHow can I call an SQL query function in Python?
Hello, I am creating an application for studies and a question has arisen. It is divided into 3 files, a main, a database and another app. In the main I put the main menu so that the user choose the…
-
-1
votes1
answer25
viewsSum of values according to value of another column
I have two doubts that are difficult for me but that maybe I can be simple for you. I wondered how I could make a sum of the amount according to the units that in this case would be the units…
-
-1
votes1
answer20
viewshow to save data from an api with ruby and sqlite3
I’m creating an app only in ruby, with sqlite 3,I have to create the bd in bin setup to save the parameters of the api,I’m trying to make this foma: #!/usr/bin/env ruby require 'sqlite3' require…
-
-1
votes0
answers10
viewsimdb-sqlite library
PYTHON - needed to popular a database in sqlite with the imdb data, I tried to use the imdb library- because I saw that it should be the simplest way, I performed the installation: Pip install…
-
-1
votes0
answers14
viewsHow to insert data into sql without erasing old data?
Hello. I’m learning sql now, I’m trying to make a simple python code to store 4 data in sql database. But every time I stop the code and run it again, it erases the bank and starts again. I couldn’t…
-
-2
votes1
answer43
viewsConnection with Sqlite returns Unsupported driver [C]
I’m trying to use Sqlite in a project but when performing any command with Sqlite returns: Unsupported driver [C]. this is my configuration on database php. 'sqlite' => [ 'driver' => 'sqlite',…
-
-3
votes1
answer44
viewsValue returned in SQLITE3 query with PHP is not what expected
Hello, good afternoon, I’m trying to select a Sqlite3 bank that sent me information, however the result that is returned to me is 0. Here’s where I want the result: This is my code: <?php $db =…
-
-4
votes1
answer53
viewsI’m having trouble with the code
people I am making a school system with python using the modules Tkinter and Sqlite but when I insert the variables of the text boxes in the database information it gives this problem take a look at…