Reputation
822
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
1 5 9
Newest
 Caucus
Impact
~42k people reached

  • 0 posts edited
  • 6 helpful flags
  • 33 votes cast
Jul
19
comment SQLite table design for PK and/or UNIQUE
As shown in scenario B, It is not always possible to keep the IDs the same. So why have scenario A at all?
Jul
10
comment Looking for SQLite Free Hosting
No; SQLite is not a client/server database.
Jul
9
comment Text string stored in SQLite Integer column?
@Vérace Sorry, I meant the particular database file igal was looking at.
Jul
9
comment Text string stored in SQLite Integer column?
@igal Why do you assume that the creator of that database knew what he was doing? ☺
Jul
8
comment How to optimize a large join to create a WHERE IN
@Renzo Using the table name is allowed for FTS tables to search all columns; but here it is the t column.
Jun
1
comment Possible SQLite bug?
You are assuming that columns have data types. This is not the case.
May
21
comment Query for hierarchical RBAC scenario
When you replace UNION ALL with UNION, you don't need the depth check. Yes. Yes.
May
21
comment Query for hierarchical RBAC scenario
Asking me to do all your work for you does not motivate me. At least write those queries that you know how to write.
May
21
comment Query for hierarchical RBAC scenario
Yes, a recursive CTE would be involved. First, write a query to get the permissions for a given user and his roles, assuming that there is no role recusion. Use a subquery to get the user's roles. Then write a query to get the roles contained in a role. Then combine those.
May
13
comment Sqlite query slow whilst it should be fast
R-tree virtual tables contain only numbers; think of it as an index (that you have to join explicitly).
May
6
comment Improving performance of a weighted search query in SQLite3
SQLite does not support indexes on function results. You'd have to precompute everything.
Apr
11
comment SQLite insertion with junction table
And what exactly do you have a problem with? Executing SQL commands? The syntax of SELECT or INSERT statements? lastInsertRowid()? Transactions?
Apr
10
comment SQLite insertion with junction table
What programming language are you using?
Apr
8
comment How to select data in the same table on different rows that are empty?
Are you actually inserting NULL values, or empty strings?
Mar
30
comment How to divide a big SQL Query into small query
Just do an INSERT for each file.
Feb
8
comment How do I prevent SQLite database locks?
The documentation describes the disadvantages. It is especially dangerous if you don't know how to avoid deadlocks.
Jan
20
comment Unable to sort this table for the specified condition in SQLite
Did you read the documentation? Which part do you not understand?
Dec
19
comment DBEAVER: SQL error or missing database (near “,”: syntax error)
@a_horse_with_no_name Only for compatibility with MySQL.
Dec
7
comment Insert values from one database table to other database table through shell scripting
Duplicate of stackoverflow.com/q/27284081/11654
Nov
4
comment Understanding SQLite filesize, size “always” 1.471.488 bytes
In theory, VACUUM should have worked. Show the output of sqlite3_analyzer.