Reputation
757
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
1 5 8
Newest
 Tenacious
Impact
~35k people reached

  • 0 posts edited
  • 6 helpful flags
  • 29 votes cast
1d
comment Query for hierarchical RBAC scenario
When you replace UNION ALL with UNION, you don't need the depth check. Yes. Yes.
1d
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.
2d
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
May
7
answered Converting outer apply with Correlated subquery in SQL Server to SQLite
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
30
answered SQLite CSV import won't create a table automatically
Apr
27
answered Issue with accented characters in SQLiteStudio
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?
Apr
1
answered Improve Query Performance
Mar
31
answered Should I use VACUUM on a SQLite db with a log-structured filesystem?
Mar
30
comment How to divide a big SQL Query into small query
Just do an INSERT for each file.
Mar
8
answered Is it correct to dynamically add rows to a table in sqlite, or should I use csv? (I'm working with objective c.)
Feb
23
awarded  Tenacious
Feb
13
answered How to define the table structure for measured data in sqlite