Category "sqlite"

Android SQLite same DB [duplicate]

I am using local DB (SQLite) with my android app. I know, that with every first launch of the app, a new database is created. Is there an easy

Should you remove SQLite database in Flutter to add Datastore

I have a to do list app developed using flutter and SQLite and I'm wondering if it is a better practice to remove the SQLite database when I want to use Datasto

django_celery_beat - "no such table: main.django_celery_beat_solarschedule__old" while updating "django_celery_beat_periodictask"

I'm using django + celery, when running django devserver I'm getting exception django.db.utils.OperationalError: no such table: main.django_celery_beat_solars

Where is "SetPassword" or "ChangePassword" in SQLiteConnection class?

I'm just learning how to encrypt/decrypt SQLite database. I found a way to encrypt, as in this post SQLite with encryption/password protection This page's bes

Problems with parsing a JSON array objects into an object

first question i post here. I'm learning js and trying to do some APIs for a college project. I have the body of the API that passes a JSON object like that:

Why is my Blazor Server App waiting to render until data has been retrieved, even when using async?

I'm building a Blazor Server app using .NET 6. As an example I have a list of customers that I retrieve from a Sqlite db using Entityframework Core. I want to s

Nesting where query to run faster in SQLite

I'm trying to run this SQL code in a BI tool and that does not allow any set statement, temp tables or indexing. This query runs for more than 30 mins as this a

Error occurs when I try to create a new column with passwords in database [duplicate]

from flask import Flask, redirect, url_for, render_template, request from flask_sqlalchemy import SQLAlchemy from datetime import datetime imp

Xamarin.Forms Sqlite (sometimes) fetching bad result after update

I have a Xamarin.Forms project which uses a local database file Sqlite (the file is called datas.lite) from sqlite-net-pcl nuget package (version 1.2.0). I have

SQLITE PIVOT TABLE WITH COUNT

Can you help me plase ? I want a result like the table below with Sqlite . task_name status_code department 1 A START PUR 2 B START ENG 3 C FINISH ENG 4 D NOT

Using CASE statement to INSERT values into multiple columns in SQLite

I'm trying to use INSERT statement to add values to a few columns in a new table depending on the value of a column in another table. I'm writing in SQLite. I w

sqlite mark duplicates with true or false

I need to create a new column in my dataset (duplicate_name) that contains TRUE if there are more than one record for someone or FALSE otherwise. I found this c

Store Entity Framework Core SQLite file in project-relative subdirectory

I have an ASP.NET Core 2.0 app using Entity Framework Core and the SQLite Provider. I am trying to store the SQLite database file in a subdirectory (specificall

TypeORM column type dependant on database

I have simple entity @Entity() export class File { @PrimaryGeneratedColumn() id: number; @Column({type: "mediumblob"}) data: Buffer; } Which

Return max value in a column with peewee

I have a table called jobs with a column called job_num. How do i return the maximum value of the integers in that column? I have tried result = Job.select(m

Unhandled Exception: SqliteException(1): no such table: main.checkLists, SQL logic error (code 1) [ In Moor]

I have found most people solved this issue simply by cleaning and re building their flutter databses by handling migrations in Moor. However, I have done the sa

Exit a SQLite 3 database

I have an SQLite 3 database in SUSE Linux. It's stuck at the command prompt like so: sqlite> q ...> exit ...> .exit ...> quit ...> .q

I can't find an SQLIte database after creating it

I'm really having trouble trying to understand SQLAlchemy so I apologize if this is a really symplistic problem. I can't find the sqlite database in any of my d

Django - no such table exception

In Django, I've added some models into models.py. After manage.py makemigrations, manage.py migrate raised this exception: django.db.utils.OperationalError: no

Sending query requests over LAN

I have an inventory management app (windows) that uses sqlite3 database. The app is installed on the main PC we have in the office. I am going to have around 6