[sqlite] Temporary table in SQLite

Hi, Is it possible to create a temporary table in SQLite so that it will only be visible to the current session and be destroyed after the session is closed? Just like SQL Server http://www.codeproject.com/Articles/42553/Quick-Overview-Temporary-Tables-in -SQL-Server ? Thanks

[sqlite] Why SQLite does not use a web-based forum?

Hi, Why SQLite does not utilize a web-based forum for all users discuss problems? I think that will be more convenient and can help more people. Thanks

[sqlite] Performance comparison between SQLite and SQL Server?

Hi, I am just curious whether there is a performance comparison between SQLite and SQL Server? Surely SQL Server will perform better on huge database with thousands of tables(more than 10GB size). But whether SQLite will perform better on smaller database such as one database with one table that i

[sqlite] Get count of unique values?

Hi, I create a table as follows: CREATE TABLE MyTable (F1 INTEGER, F2 INTEGER); Then add the following records: INSERT INTO MyTable (F1, F2) Values (1, 2); INSERT INTO MyTable (F1, F2) Values (1, 3); INSERT INTO MyTable (F1, F2) Values (2, 4); INSERT INTO MyTable (F1, F2) Values (2, 5); INSERT

[sqlite] Process duplicate field values

Hi, I create a table as follows: CREATE TABLE MyTable (F1 INTEGER, F2 INTEGER); Then add the following records: INSERT INTO MyTable (F1, F2) Values (1, 2); INSERT INTO MyTable (F1, F2) Values (1, 3); INSERT INTO MyTable (F1, F2) Values (2, 4); INSERT INTO MyTable (F1, F2) Values (2,

[sqlite] Process duplicate field values

Hi, Thank you very much. Can task 2 and 3 be performed in one query to improve the performance? Thanks > -Original Message- > From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users- > bounces at mailinglists.sqlite.org] On Behalf Of Hick Gunter > Sent: Friday, Febr

[sqlite] Process duplicate field values

Hi Sorry for the confusion. The distinct values for F1 is only 1, 2 and 3, so the distinct value count is 3. However, there are totally 6 records that have duplicate F1 values. The task 2 is to calculate the total count of conflict records so it is 6. Hope that explain the issue clearly. Than

[sqlite] Process duplicate field values

Hi, Thank you. In that case, is there a way to create a table which contains only the records that have duplicate F1 values? Thanks > -Original Message- > From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users- > bounces at mailinglists.sqlite.org] On Behalf Of R S

[sqlite] Process duplicate field values

No. Originally I think since task 2 and 3 are operations performed on the same set of records, maybe they can be merged to improved the performance though one is get and another is set. Thank you very much > -Original Message- > From: sqlite-users-bounces at mailinglists.sqlite.org [mailt

[sqlite] Select top 1 from duplicate values

Hi, I am using SQLite 3.11. I create a table as follows: CREATE TABLE MyTable (F1 INTEGER, F2 INTEGER, F3 INTEGER); Then add the following records: INSERT INTO MyTable (F1, F2, F3) Values (1, 2, 8);

[sqlite] Order by multiple columns

Hi, I am using SQLite 3.11. I create a table as follows: CREATE TABLE MyTable (F1 INTEGER, F2 INTEGER, F3 INTEGER); Then add the following records: INSERT INTO MyTable (F1, F2, F3) Values (1, 2, 8);

[sqlite] Late calculation of a field

Hi, I am using SQLite 3.11. I create a table as follows: CREATE TABLE MyTable (F1 INTEGER, F2 INTEGER, F3 INTEGER, F4 INTEGER); Then add the following records: INSERT INTO MyTable (F1, F2) Values (1, 1);

[sqlite] How to remove duplicate records

Hi, I am using SQLite 3.11. I create a table as follows: CREATE TABLE MyTable (F1 INTEGER, F2 INTEGER, F3 INTEGER); Then add the following records: INSERT INTO MyTable (F1, F2, F3) Values (1, 2, 8);

[sqlite] Order by multiple columns

Hi, Thank you. In that case, if I create an index for (F1, F2, F3), then the next time when I invoke SELECT statement like this: SELECT * FROM MyTable ORDER BY F1, F2, F3; Then SQLite will utilize the index automatically, is that correct? If I use SELECT * FROM MyTable ORDER BY F1, F2; Then t

[sqlite] Encrypt the SQL query

Hi, In my C++ program, I will invoke SQLite to execute SQL queries. But these queries are just stored as normal string constants in C++ so it is easy to be decoded via reverse engineering method. Does SQLite provide a good way to encrypt the SQL query strings while does not affect the performance

[sqlite] Encrypt the SQL query

Hi, To encrypt the SQLite database, I can only find the following extension: https://www.sqlite.org/see/doc/trunk/www/readme.wiki So I must recompile and enable the extension to encrypt the database, is that correct? Thanks > -Original Message- > From: sqlite-users-bounces at mailingl