Questions tagged [sqlite]
SQLite is an open-source software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. SQLite is the most widely deployed SQL database engine in the world.
sqlite
95,030
questions
0
votes
1
answer
31
views
Implement a method to send reminders from a Telegram Bot on a Channel/Group and Private Chat
My Telegram bot acts as a calendar for my favorite team's matches. It should scrape from a site that publishes the match calendar, put this calendar in a local SQLite database and access it via ...
- 29
0
votes
0
answers
36
views
How do I generate rows of predefined values from a SELECT statement? [duplicate]
In SQLite I want to return a list that I type in myself (for further left join SQL commands):
ABC
DEF
GHI
Not existing in any table but manually entered strings (like how SELECT 'ABC' returns ABC, ...
- 919
0
votes
0
answers
12
views
Why does my deployment fail with an error about PHP's sqlite3 extension?
Trying to deploy a Shopify webapp using Heroku (following Shopify documentation) I am pushing from a branch (to test before merging into master) running git push heroku <branch name>:refs/head/...
-1
votes
0
answers
13
views
Restore/rebuild an (by now) offline page with help of the IndexedDB files?
is it possible to re-create/setup a page again which went offline in the meantime?
A friend of mine can still use the page (when entering the URL although it is offline). The URL is https://omnibibel....
-3
votes
1
answer
45
views
Why is my code not pre-populating the database?
My app collects data for experiments. I am trying to pre-populate the database. I create directories for each experiment and store the database in each of those.
Folder storedData holds the database ...
- 29
-4
votes
0
answers
25
views
I am pasting the information from the class I am taking and I keep getting nothing from the result [closed]
select EmployeeID, fName, lName, Position, Salary
from Randell222
where Salary > 30000 and Salary < 45000;
This is the query I am asked to make and I have not gotten a single result. I have ...
-1
votes
0
answers
46
views
How do I query for overtaken trains from this train schedule data?
From my train schedule database I want to get trains overtaken by train 12301. What would the SQL query be?
Overtake can be at a station (train A arrives and departs in between arrival and departure ...
0
votes
2
answers
73
views
How do I create an interface for a conditional one-to-many relation?
I am creating an inventory app for electronic components. There is a package for each component which will change if their assemble technology is on SMD or DIP. Each SMD and DIP has its own options, ...
- 133
-1
votes
1
answer
20
views
pgloader does not find sqlite database file
to work myself into pgloader I have created a sqlite3 db from an csv file.
If I open the file and do select star from the data it shows the correct data
path is /tmp/tt.db
this works
sqlite3 /tmp/tt....
- 1,919
0
votes
1
answer
39
views
How do I combine rows from different tables in one view?
My database stores events from C++ structs of report information. All structs have common fields (id, timestamp) but also unique ones (application.name, user.name). I need data for one component from ...
- 365
0
votes
0
answers
35
views
Intermittent TABLE ALREADY EXISTS database error
In CakePHP 4.3.3 with SQLite I use a temporary table which I refresh by deleting and re-creating. Occasionally from the CREATE statement I get an error that the table already exists, despite that my ...
- 49
-1
votes
1
answer
57
views
Equals method never called by LINQ expression [duplicate]
My data class:
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.ComponentModel.DataAnnotations;
using static iText.StyledXmlParser.Jsoup.Select.Evaluator;
...
- 403
0
votes
1
answer
43
views
How do I combine multiple json_group_array for this query correctly?
My aggregate query with group_concat selects from one table, and if there are no results it selects from another:
SELECT
Col1,
Col2,
IFNULL(
SELECT group_concat(SomeColumn) FROM ...
- 4,259
-1
votes
1
answer
45
views
What is a more flexible way of storing parameters for an SQL table?
In my budget tracking app using Python and sqlite3 I don't need the user to come up with new types of transactions or accounts (card, cash and etc.). I need to make a fixed amount of transaction types ...
- 19
0
votes
1
answer
28
views
How to test Amazon Athena queries
I have a rather complicated Athena query, which I would like to test on a local machine without connecting to Athena. I specified some mock data for testing purposes, and I was hoping that I could use ...
- 714