Category "sqlite"

sqlite3.OperationalError: no such column:

This is a very basic question and I know there are security issues with this code and it should be using parameterized entries among other issues - it is a work

AutoPopulate EditText in Android Studio from SQLite Database

I am attempting to autocomplete the EditText in my application, however not through means of typing but from one entry to another. What I mean is that when the

How do catch error on React Native SQLite

I have the code: let dirs = RNFetchBlob.fs.dirs RNFetchBlob .config({ fileCache : false, }) //pega o arquivo da internet .fetch('GET', 'https://U

Sqlite concurrent writing performance

I'm writing a website with Golang and Sqlite3, and I expect around 1000 concurrent writings per second for a few minutes each day, so I did the following test (

How do I check if a SQLite3 database is connected in Python?

Question 1: I have an SQLite3 connection in Python. How can I checked whether it is connected or not? I know that if sqlite3.connect() fails, an exception is ra

Insert row to table in SQLite and Node.js

I am studying SQLite for Node.js. Currently I am at the very beginning. I tried to insert row to a table but got error. The code I am using comes from this tuto

Error database_closed when using flutter's sqflite

I try to use sqflite to save some data like my class Movie but when i try to insert or query on the database, see this message: [ERROR:flutter/lib/ui/ui_dart_st

SQLite - SELECT DISTINCT of one column and get the others

I have a table like this (but with more columns): Code Quantity ----- -------- 00001 1 00002 1 00002

deleting sql code with python and selecting from JOIN

I have just started with Python and am already aware of the basics of SQL. In this code I'm trying to join tables and just test out python however I have two pr

Django 2.0: sqlite IntegrityError: FOREIGN KEY constraint failed

I'm working on adding Django 2.0 support to the django-pagetree library. During automated testing, using an sqlite in-memory database, I'm getting a bunch of er

NameError: name '_mysql' is not defined after setting change to mysql

I have a running Django blog with sqlite3 db at my local machine. What I want is to convert sqlite3 db to mysql db change Django settings.py file to serve MySQL

Reading data from Sqlite Database in android application.

I am trying to read data from a database. I imported the database in the sqlite manually and now just want the connection made in android application and want t

Inserting with Foreign Key in sqlite3 for python

I have a database called soccer.db with two tables team and game I used DB Browser to create the database. My sqlite3 version is 3.30.0. I also confirmed that t

How to have an automatic timestamp in SQLite?

I have an SQLite database, version 3 and I am using C# to create an application that uses this database. I want to use a timestamp field in a table for concurre

How to filter a nested relation in Room?

Let's take this example: I have a form, which has several sections, each having questions. Sideways, I have answers that are mapped to questions and they have a

Sqlite executemany and DELETE

Execute many seems to be very slow with deletion (Insertion is fine) and I was wondering if anyone knows why it takes so long. Consider the code below: import s

Is it possible to access an SQLite database from JavaScript?

I have a set of HTML files and a SQLite database, which I would like to access from the browser, using the file:// scheme. Is it possible to access the database

How to store tree structure in sql?

Here is my schema using sqlite, I am not sure if this is a good way to create tree structure in sql as I have to traverse many time to obtain the entire tree, a

java.lang.IndexOutOfBoundsException: Invalid index 0, size is 0

I am trying to get datafrom database in a list. This is my code: private class LoadData extends AsyncTask<Void, Void, Void> { private ProgressDialog

SQLite Select from where column contains string?

What I currently have selects based on a column having the same value.. "SELECT * FROM users WHERE uuid = ?" But what if I want to return a row based on one