I need to save an object that contains a file and some other data. Although the file is stored on the /media folder, the entity is not saved in the database sin
I am trying to run migrations from command line and keep getting error: ERROR [root] Error: Can't locate revision identified by 'faf3ebfbe667' As suggested in
I'm building an Android application based on an old Android project. In my new application I'm using Room. I have to use the same database that is used in the
I have done my best to neatly format the meta recruiting question below. My current query that I'm trying to ascertain the ratio is this. Returning correct 2/3
I'm trying to do something simple here - connect to a sqlite database and return the number of records. In the code below I can output the len variable with co
I'm trying to do something simple here - connect to a sqlite database and return the number of records. In the code below I can output the len variable with co
I am trying to access my SQLite database which is in a Java package. When I am giving it's absolute path then it's OK, but when I am putting my db file inside j
I want to study sqlite by reading its source code. I found sqlite-1.0.1 only contained 10,000+ lines code, maybe it is easy to read. But unfortunately, modern g
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
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
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
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
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:
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
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
from flask import Flask, redirect, url_for, render_template, request from flask_sqlalchemy import SQLAlchemy from datetime import datetime imp
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
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
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
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