Skip to main content
95,023 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
0 votes
0 answers
20 views

I want to unit test a method which removes records from a table. It works when I run it with npm run dev and a file-based SQLite database. However, it doesn't work with an in-memory SQLite database (...
Viktor's user avatar
  • 1,541
1 vote
2 answers
49 views

self.cur.execute("DROP TABLE IF EXISTS analysisResults") self.cur.execute("""CREATE TABLE IF NOT EXISTS analysisResults( subjectID INTEGER ...
Jack Walker's user avatar
  • 9
1 vote
0 answers
36 views

I need to create a package for a .NET application on Linux for the Azure Marketplace. The application uses an SQLite database. Azure Marketplace, in the process of creating the offer, does not present ...
Sten Petrov's user avatar
  • 11.1k
-1 votes
0 answers
69 views

I have dictionary of browsers and want to programmatically fetch the cookies saved in default/network/cookies. However, some of the cookies don't match, are encoded in base64, and only return one ...
Dragon Stev's user avatar
  • 1
0 votes
0 answers
34 views

I am attempting to include manual updates to an Alembic-generated migration file for my SQLite database. In models.py tables are defined. The update of the auto-generated table works however, I want ...
heylistn's user avatar
  • 1
2 votes
3 answers
83 views

If I want to insert into table COMPANY I write: "INSERT INTO COMPANY (AGE) VALUES (32);". But if I want to insert a variable x=32 instead of 32, how can I do that? There are some ways in ...
jjo mmax's user avatar
  • 40
2 votes
0 answers
87 views

I’m working on a Kotlin Multiplatform Desktop (JVM) application using Room with a custom SQLiteDriver backed by SQLite JDBC + SQLCipher last versions. I’m adapting a JDBC Connection / ...
djardon's user avatar
  • 189
4 votes
1 answer
109 views

On Fedora 43 in Python 3.14 I can create and retrieve a shelf in a command line with no errors: #!/usr/bin/env python import shelve shelf = shelve.open('/tmp/my_shelf', flag='c', writeback=True) ...
Clodoaldo Pinto's user avatar
  • 127k
Tooling
0 votes
4 replies
117 views

I am looking for a proper extension in Visual Studio 2026 to be able to visually preview my SQLite database. Currently, I am using SQLite and SQL Server Compact Toolbox. It is functional, but I'd like ...
dmytroshved's user avatar
  • 123
1 vote
0 answers
77 views

My function to get input from the user using Leaf PHP with an SQLite database should create a POST method call to create a thread, and every message (including the first one) should be in a comments ...
ffuentes's user avatar
  • 1,181
Advice
1 vote
10 replies
87 views

In SQL, if I omit the ORDER BY clause from a window function's OVER() clause, will it use the parent statement's ORDER BY instead? For example, are these two queries equivalent? -- Query 1: ORDER BY ...
Dan's user avatar
  • 5,080
0 votes
1 answer
57 views

My Flask application exposes a REST API for CVE data stored in SQLite. The API supports filtering and pagination, but is my totalRecords count logic correct when filters are applied? totalRecords ...
Gug's user avatar
  • 1
2 votes
3 answers
191 views

I want to add to my result rows the immediate previous and following row according to a specific clause. Simplified case: ROWID value x level 0 1.0 0 1 1 2.0 1 2 2 3.0 2 1 3 4.0 3 2 4 5.0 4 1 5 6.0 5 ...
bux's user avatar
  • 7,741
2 votes
3 answers
62 views

I need to group data according to a certain condition. ID STATUS WORD 1 text word 1 2 - word 1 3 text word 2 4 - word 3 5 - word 4 6 text word 4 ( - ) it's NULL I need the result to include data with ...
Aliaksei's user avatar
  • 1,583
0 votes
0 answers
68 views

I'm developing a password manager app using GAMBAS. I'm currently stuck at an issue connecting the database to the databrowser to show to the users their saved passwords. Here are the objects I have ...
bray-hiramis's user avatar
  • 1

15 30 50 per page
1
2 3 4 5
…
6335