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,033
questions
-2
votes
0
answers
13
views
Qual é a diferença entre usar '=' ou ':=' para atribuir um valor a uma variável no mysql? [closed]
Eu estava executando algumas querys com variáveis quando eu cheguei na seguinte dúvida:
executar o comando '@variavel = dado' e o 'comando @varivel := dado' fazem a mesma função, só que as coisas ...
0
votes
0
answers
9
views
Laravel Pest Tests with RefreshDatabase Trait Not Refreshing SQLite Database
I'm having trouble with my Laravel feature tests using Pest. Despite using the RefreshDatabase trait, my SQLite database isn't being refreshed between test executions. This causes test failures, as ...
- 21
-1
votes
1
answer
38
views
sqlite3_step() commits to database [closed]
I am attempting to run a sequence of sqlite3 prepared statements (some SELECT, some INSERT) and I want to be able to wrap them in a transaction, so if errors elsewhere in the code materialise, I can ...
0
votes
1
answer
34
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
38
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
17
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
15
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
48
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
26
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
50
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
74
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
36
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