Reputation
922
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
1 7 10
Newest
 Organizer
Impact
~63k people reached

  • 0 posts edited
  • 6 helpful flags
  • 42 votes cast
Jan
9
answered SQLite query rows nearest to hour
Dec
3
awarded  Organizer
Nov
26
comment Is it possible to store and query JSON in SQLite?
Read the documentation.
Nov
19
comment Switching SQLite environments
SQLite Manager's "Copy Database" does not appear to work with in-memory databases. Looks like a bug.
Nov
19
comment Switching SQLite environments
Then why are you using an in-memory database in the first place?
Nov
17
comment force SQLite view column type affinity
In SQLite, a view's columns do not have types. The values themselves have types, and there can be different types in the same column.
Nov
16
comment How to import data from Sqlite into SQL Server 2012
Once, or automated?
Nov
16
comment No foreign key constraint with PRAGMA foreign keys
For the code shown, the tables are empty. Anyway, show the entire function that executes the DELETE.
Nov
16
comment force SQLite view column type affinity
SQLite uses affinity when storing data into columns. Views do not store data. What is your desired effect of forcing an affinity onto a view's column?
Nov
13
comment sqlite3 foreign keys ignored
Works for me (Error: FOREIGN KEY constraint failed).
Sep
30
comment Search across all columns in a table
This would be easy with a full-text search index.
Sep
30
comment Search across all columns in a table
PRAGMA is a statement, not an expression.
Sep
6
awarded  Yearling
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
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.