List of tables, db schema, dump etc using the Python sqlite3 API

For some reason I can't find a way to get the equivalents of sqlite's interactive shell commands: .tables .dump using the Python sqlite3 API. Is there anything like that?

Encrypted file or db in python

I have a sqlite3 db which i insert/select from in python. The app works great but i want to tweak it so no one can read from the DB without a password. How can i do this in python? note i have no...

Python SQLite: database is locked

I'm trying this code: import sqlite connection = sqlite.connect('cache.db') cur = connection.cursor() cur.execute('''create table item (id integer primary key, itemno text unique, ...

Excel/SQLite date serial numbers

How can I get SQLite to convert excel-type serial numbers to dates, e.g. I want the integer 40074 in a table to somehow get the date 18-Sept-2009? The dates are already in SQLite.

Difference between MySQL/SQLite/etc databases?

This is my first time trying to work with a database, so bear with me. I need to write a program that will use a database that I do not have access to yet. I know there is MySQL, SQLite, and a...

Update multiple rows with different values in a single SQL query

I have a SQLite database with table myTable and columns id, posX, posY. The number of rows changes constantly (might increase or decrease). If I know the value of id for each row, and the number...

SQLITE - INSERT or UPDATE without changing ROWID value

I need to update a table row IF EXISTS, otherwise INSERT a new row. I tried: INSERT OR REPLACE INTO table VALUES ... but if the row row exist this statement changes the row's ROWID, and that's...

How to import data from csv file to sqlite Manager tool

How can I import data from a CSV file into the SQLite Manager tool? I can not find the import option in SQLite manager. I have to import data from CSV to a particular table in db.

C# and SQLite: Resource to Array

I'm querying a database with SQLite. I'm trying to get data from this database, save it in an array, then return to the controller. I need to present this data using a foreach loop in my...

SQLite query - date reserved word?

Am just curious, is date a reserved word i SQLite? I have a column which is named date, and trying to run this query: DELETE FROM cases WHERE date <= date('now','-1 day') By doing this: String...

android java.lang.IllegalStateException: Couldn't read row 0, col 0 from CursorWindow

I am developing an application which download some files and save their text in file_content field to database. The file sizes can vary from some KBs to 10 MB. The app works for all sizes while...

SQLite import csv file with comma in text fields

I want to import csv file into SQLite db using sqlite> .separator , sqlite> .mode csv data sqlite> .import test.csv data where data is the table name with three columns, just like the file. The...

How to write C# case insensitive LIKE statement for SQLIte using ICU extension?

SQLite has limitation on using LIKE for non-ASCII symbols. ICU extension solves this problem. How to write code in C# for creating following case insensitive statement: SELECT * FROM Persons WHERE...

Attempt to write to a readonly database error

I have created a new Laravel app utilising SQLite database for user login system. I am experiencing a weird issue where I receive the following error: > SQLSTATE[HY000]: General error: 8 attempt...

unity build webGL with SQLite database

I'm developing a game for web(html5) which connects to a SQLite database to access the game's questions (which I learned in here:...

Visual Studio C# - SQLite.Interop.dll not found

I am currently trying to create with Visual Studio a C# application working with SQLite. I installed SQLite for my program with NuGet and three references appeared in the Solution Explorer...

Getting com.android.volley.ServerError

PUT request using volley Log.i("JsonObject...

How do i get specific data from SQLITE DATABASE and display it in TextView

How do i get 1 specific row from the database (by id for example) Cursor c = db.rawQuery("SELECT * FROM measurements WHERE _id = 1", null); ?? how do i display it in edittext ?

Executing an SQL query over a pandas dataset

I have a pandas data set, called 'df'. How can I do something like below; df.query("select * from df") Thank you. For those who know R, there is a library called sqldf where you can execute SQL...

Connecting to an online database through python sqlite3

I have a question about sqlite3. If I were to host a database online, how would I access it through python's sqlite3 module? E.g. Assume I had a database hosted at "www.example.com/database.db"....

Implementing the Room Database (Android)

I like to know how to properly integrate the Room Library within an Android Application. Some articles I have seen uses a Singleton approach using a Respository for database calls, while other...

Failure preparing: bad parameter or other API misuse in SQLite swift while inserting data

let db = Database.openDatabase() let insertStatementString = "INSERT INTO SignupDetails VALUES (\((self.txtUsername.text!.trimmingCharacters(in: .whitespaces))),...

Unable to import sqlite3 using Anaconda Python

I am trying to do the following in Python 3.7.1 on Windows import sqlite3 but I get the following error message Traceback (most recent call last): File "<console>", line 1, in <module> File...

how to make my SQlite query case insensitive?

My original code is : String sql = "select t.* from (select dId, " + "case when substr(dWord, 1, 4) in ('das ', 'der ','die ') " + "then substr(dWord, 5)...

Your target project 'XXX' doesn't reference EntityFramework. This package is required

Can anyone point me in the direction of where I have gone wrong. I am trying to get migrations to work on EFCore with SQLite (Console App .NET Core 3.1) Running any command such as...

How to store hashed passwords on SQLite3 database?

I want to store passwords on a sqlite3 database on python, however I don't want to store the passwords in plaintext for obvious reasons. I have used bcrypt to hash the passwords, but I keep...

What does Room return if a query had no results

Having a difficult time finding this answer and the documentation doesn't seem to answer the question. If I have a basic ROOM query, @Query("SELECT * FROM geotable WHERE geohash =...

JAVA + SQLite - get a formatted date from each row using strftime()

I've been using SQLite for about a day now and have managed to get reading and writing working in Android Studio using Java. I'm still pretty new to all this, even java, so I may be missing...

Why can't I see the created database file in my working directory (Flask)?

Problem: I am new to creating a website on the flask and my code is running smoothly without any error, but I can't see the database file on my working directory or in my Project and I dont know...

Cannot read property 'filename' of undefined Node js

I have a problem with nodejs, when I want to make a post with an image, I have an error message "Cannot read property 'filename' of undefined" I do not see where my error is. this is my multer...