I'm trying out statements for creating a database, and after 10 entities without any issues I ran into this error Error: Near line 83: near "Transaction":
I'm pretty new to SQL and am trying to join some tables in SQL. I'm using SQLite3 and Pandas and have the following table structure: User | Measuremen
I'm pretty new to SQL and am trying to join some tables in SQL. I'm using SQLite3 and Pandas and have the following table structure: User | Measuremen
Given a table with columns(name, lat, lon, population, type) where there are many rows for each name, I'd like to select the rows grouped by name where populati
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