Category "sqlite"

SQLite 64bit integers recognized as ints in jooq

I have an SQLite database that I am using with jOOQ. When I use jOOQ's code generation tool, it builds all of the table and record classes as expected. However,

Using brew installed sqlite3

I want to use sqlite with the json extension so I've installed it with homebrew. When I run which sqlite though, the one that is being used is the anaconda inst

Room Database Table is still empty after inserting new data

I've just finished this tutorial for my app. But my problem is that even after I insert the data, my database is still empty. I checked that by viewing it in a

sqlite: select display few rows around matching rows

I have a table of the form select rowid,* from t; rowid f ----- ----- 1 aaa 2 bbb 3 ccc 4 ddd 5 eee 6 fff 7 ggg 8 aaa 9 bbb

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