Category "sqlite"

How to convert SQLite database in android studio and then share it as csv file

Im making an app in which the users inserts values into a table (SQLite DB) and I want to make a share button which will share the the table as an excel file (.

How do I delete the selection of a combobox from a sqlite database?

I want to delete a row from a sqlite3 database using the selection of a combobox to get the row that I want to delete. My current code deletes an item from the

How to set threading mode in SQLite with Entity Framework?

I'm using SQLite with Entity Framework Core (RC1). I read, that SQLite supports three different threading modes: Single-thread, Multi-thread and Serialized.

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