Reputation
822
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
1 6 9
Newest
 Constituent
Impact
~45k people reached

  • 0 posts edited
  • 6 helpful flags
  • 34 votes cast
Aug
22
answered Using SQLite ODBC without installing a driver
Aug
3
awarded  Constituent
Jul
27
awarded  Caucus
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
9
answered Looking for SQLite Free Hosting
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.
Jul
7
revised How to optimize a large join to create a WHERE IN
added 658 characters in body
Jul
7
answered How to optimize a large join to create a WHERE IN
Jul
7
answered Why does an sqlite3 .dump and restore result in a smaller database file size?
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
13
answered Sqlite query slow whilst it should be fast
May
7
revised Converting outer apply with Correlated subquery in SQL Server to SQLite
added 62 characters in body
May
7
revised Converting outer apply with Correlated subquery in SQL Server to SQLite
added 1954 characters in body