Re: [sqlite] Hidding records from the application

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 07/15/2011 09:01 PM, san long wrote: > sqlite3 support a trigger on SELECT ? View is a good solution, but I > want to let different process see different records, like: > pid A sees rowid 1,2 > pid B sees rowid 1,3 Add a column to the table for

Re: [sqlite] Hidding records from the application

sqlite3 support a trigger on SELECT ? View is a good solution, but I want to let different process see different records, like: pid A sees rowid 1,2 pid B sees rowid 1,3 2011/7/16, san long : > haha, if I CREATE VIEW in process A and DROP VIEW when A dies. Process > B

Re: [sqlite] Hidding records from the application

haha, if I CREATE VIEW in process A and DROP VIEW when A dies. Process B could see this VIEW or not? A and B run at the same thime. 2011/7/16, Simon Slavin : > > On 16 Jul 2011, at 4:23am, san long wrote: > >> Thanks for advice, delete or update the record in a view could

Re: [sqlite] Hidding records from the application

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 07/15/2011 06:19 PM, san long wrote: > Is there any good solution to satisfy my requirement? Since you want absolutely nothing to see them, delete them. Or make triggers to copy data between the real table that contains all the data and your

Re: [sqlite] Hidding records from the application

On 16 Jul 2011, at 4:23am, san long wrote: > Thanks for advice, delete or update the record in a view could affect the > true table in sqlite now? No. Either use the VIEW for SELECT and the TABLE for changes, or implement triggers so attempts to change your VIEW actually change the underlying

Re: [sqlite] Hidding records from the application

right, but now I just want to hide these records to all processes. 2011/7/16 Igor Tandetnik > On 7/15/2011 9:19 PM, san long wrote: > > Dear all, > > I have an idea related to the safety of the records in a table: if it is > > possible to hide some records in a table so the

Re: [sqlite] Hidding records from the application

Thanks for advice, delete or update the record in a view could affect the true table in sqlite now? And, if I create a view dynamically using sqlite3_exec, is it visible to other process who opens the same database? 2011/7/16 Simon Slavin > > On 16 Jul 2011, at 2:19am, san

Re: [sqlite] Hidding records from the application

Thanks for replies. It doesn't matter no application can see the underlying data as long as they exist physically. I just want to hide them. 2011/7/16 Simon Slavin > > On 16 Jul 2011, at 2:32am, Danny wrote: > > > In my mainframe days, using IDMS/SQL, I limited user

Re: [sqlite] I havn't a clue

On 7/15/2011 9:28 PM, Dave Klein wrote: > Can anyone out there tell me how I can take a SQLite database and open it in > Microsoft Excell? There exist ODBC drivers for SQLite (I'm sure your favorite search engine can help you find them). Set up an ODBC source for your database, then Excel will

Re: [sqlite] Hidding records from the application

On 16 Jul 2011, at 2:32am, Danny wrote: > In my mainframe days, using IDMS/SQL, I limited user access to table data, > down to the column level, based upon logged on userid. This was accomplished > via database procedures. I'm new to SQLite, so don't know if it has any > similar

Re: [sqlite] Hidding records from the application

In my mainframe days, using IDMS/SQL, I limited user access to table data, down to the column level, based upon logged on userid.  This was accomplished via database procedures.  I'm new to SQLite, so don't know if it has any similar capabilities. > >From: Igor

Re: [sqlite] Hidding records from the application

On 16 Jul 2011, at 2:19am, san long wrote: > I have an idea related to the safety of the records in a table: if it is > possible to hide some records in a table so the upper user application could > not see them? You could CREATE a VIEW which selected just some rows of a TABLE. Simon.

[sqlite] I havn't a clue

Can anyone out there tell me how I can take a SQLite database and open it in Microsoft Excell? I'm not stupid but I don't know servers, I don't know ODBC's all I know is according to a the software I use that my data is stored in a SQLite database with the name SlotCar30.db and their website

Re: [sqlite] Hidding records from the application

On 7/15/2011 9:19 PM, san long wrote: > Dear all, > I have an idea related to the safety of the records in a table: if it is > possible to hide some records in a table so the upper user application could > not see them? > For example: > table food has content: > 1, "food A" > 2, "food B" > I want

[sqlite] Hidding records from the application

Dear all, I have an idea related to the safety of the records in a table: if it is possible to hide some records in a table so the upper user application could not see them? For example: table food has content: 1, "food A" 2, "food B" I want to hide the record whose rowid is 2, so: sqlite> SELECT

[sqlite] First steps for porting sqlite database to ThreadX OS

Hello, I am newbie with sqlite. I am work with a proyect for college and I wanna used sqlite in a embebed system. The idea is porting sqlite for run under the operating system threadx on ARM. I read about custombuild ( http://www.sqlite.org/custombuild.html) but I don't know exactly how can write

Re: [sqlite] Understanding table-level locking in shared-cache mode

On 7/15/2011 2:15 PM, Steven E. Harris wrote: > I'd like to understand that better so as to figure out whether using > shared-cache mode is appropriate for my application. My motive had been > increased concurrency due to finer-grained locking, but given that this > part of my application is

Re: [sqlite] Understanding table-level locking in shared-cache mode

Igor Tandetnik writes: > All parties in that discussion are mostly wrong. Wonderful. Even though I was hoping they'd turn out to be correct, the actual behavior of my program was not agreeing with them. > Either that, or handle errors that come from

Re: [sqlite] my new site is using as backend sqlite

On 14-07-2011 23:43, Sebastian Bermudez wrote: > > > > > - Original Message > From: Luuk > To: sqlite-users@sqlite.org > Sent: Thu, July 14, 2011 4:50:51 PM > Subject: Re: [sqlite] my new site is using as backend sqlite > > On 14-07-2011 21:40, Sebastian Bermudez

Re: [sqlite] Understanding table-level locking in shared-cache mode

On 7/15/2011 1:30 PM, Steven E. Harris wrote: > , > | In shared-cache mode, is it possible for two different connections > | (both connected to the shared cache) to mutate two different tables at > | the same time? > ` No. > My reading of the documentation[1] on shared-cache mode says

[sqlite] Understanding table-level locking in shared-cache mode

I'll start with my question, the add detail about the environment and scenario motivating it: , | In shared-cache mode, is it possible for two different connections | (both connected to the shared cache) to mutate two different tables at | the same time? ` My reading of the

Re: [sqlite] Query with subqueries: is this the good way to go?

On 7/15/2011 9:54 AM, Gabriele Favrin wrote: > SELECT > otopic.id AS idtopic, otopic.titolo, > strftime('%d/%m/%Y', otopic.inserito) AS inserito, > (SELECT strftime('%d/%m/%Y %H:%M', max(inserito)) FROM topic WHERE pub=1 > AND id=otopic.id) AS ultimo, I don't understand this part. Presumably,

Re: [sqlite] System.Data.SQLite: commands not persisting on db.

On 15 Jul 2011, at 4:11pm, Jim Morris wrote: > On 7/15/2011 1:26 AM, Mattia wrote: >> - deleting the old database (data.db) and renaming new.db with the >> correct name (new.db becomes data.db). > After this step, as a test, reopen the connection to new.db and ensure > that the data is there. >

Re: [sqlite] System.Data.SQLite: commands not persisting on db.

On 7/15/2011 1:26 AM, Mattia wrote: > - deleting the old database (data.db) and renaming new.db with the > correct name (new.db becomes data.db). After this step, as a test, reopen the connection to new.db and ensure that the data is there. Are you sure a commit is done before closing

[sqlite] Query with subqueries: is this the good way to go?

Hello. First of all thanks in advance for any help. The last time I've asked here I got a very useful help about my database structure. I'm developing a very simple forum with PHP5.3 and SQLite. I have a message table where I store messages along with their flags and a column referencing the

Re: [sqlite] Is it possible to check a data type in a query?

Perfect - thank you both.. On Thu, Jul 14, 2011 at 12:15 PM, Simon Slavin wrote: > > On 13 Jul 2011, at 1:13pm, Amit Chaudhuri wrote: > > > I have situation where a column may contain prices (REAL) or a string > > meaning "no price for this, sorry." I can handle this in

Re: [sqlite] FTS3: synonyms dictionary and tokens length

2011/7/15 Dan Kennedy : >> But queries to original text will not work: >> select text from fts where fts match 'sqlite educate'; > > I think it will. Query strings - like 'sqlite educate' - are > also parsed using the tokenizer. So the query will be transformed > to 'dbms

Re: [sqlite] System.Data.SQLite: commands not persisting on db.

On 15 Jul 2011, at 9:26am, Mattia wrote: > - checking the database with sqlite-administrator: same as before the > execution. I controlled both data.db and new.db, just to be sure: no > modification submitted. > > > To create the databases and remove them I use the IO of the framework > .Net.

Re: [sqlite] System.Data.SQLite: commands not persisting on db.

Simon Slavin > Thu, 14 Jul 2011 09:24:35 -0700 > On 14 Jul 2011, at 5:13pm, Mattia wrote: > > So actually what I do is: > > - run the application; > > - make a copy of the database; > > - select to see what lies inside a table; > > - an insert/delete/insertupdate (obtained from a string) to that

Re: [sqlite] Sqlite .net problem error175 in Visual studio 2010

Sorry, I was not clear. What was working is: VS 2010 and Sqlite.net 1.0.66.0 Apr 18, 2010. I contruct my application on these versions Note: My VS 2010 is in french, so I must retranslate the error messages in english in my explanation so they are probably not the english messages you have After

Re: [sqlite] FTS3: synonyms dictionary and tokens length

On 07/15/2011 01:10 PM, Alexey Pechnikov wrote: > 2011/7/15 Dan Kennedy: >> I think you could just have the tokenizer return "dbms" whenever >> it sees "sqlite" in the input. > > But queries to original text will not work: > select text from fts where fts match 'sqlite

Re: [sqlite] FTS3: synonyms dictionary and tokens length

2011/7/15 Dan Kennedy : > I think you could just have the tokenizer return "dbms" whenever > it sees "sqlite" in the input. But queries to original text will not work: select text from fts where fts match 'sqlite educate'; You can see synonyms dictionary in PostgreSQL