Category "sqlite"

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

file is encrypted or is not a database: , while compiling: select count(*) from sqlite_master;

I have an app that has been in production for years. It ships with the standard Sqlite DB. The lastest version of the app has SqlCipher 3.5.6 library integrated

Generic Ruby solution for SQLite3 "LIKE" or PostgreSQL "ILIKE"?

I am using SQLite3 for development and PostgreSQL for deployment. However, I am facing the following problem: My simple search using SQLite3: def self.search(

Python GUI using tkinter and db connection [duplicate]

I am not able to get any output from the following program.What i am trying to do here is store employee name and salary in a database and lat

Drupal Installation Default Page not loading css

I recently installed Drupal on Windows Server I had no errors on installation. There was a warning for OPCaching. I also don't think it should affect it but I u

Using text as a primary key in SQLite table bad?

Is it bad to have text as a primary key in an SQLite database? I heard that it's bad for performance reasons, is this true? And will the rowid be used as the ac