Re: [sqlite] Once again about random values appearance

On Fri, Feb 14, 2014 at 6:35 AM, James K. Lowden wrote: > > > select id, (select id from TestTable where id = abs(random() % 100)) > > > as rndid from TestTable where id=rndid > > On Thu, 13 Feb 2014 07:26:55 -0500 > Richard Hipp wrote: > > > It is

Re: [sqlite] Graphic SQLite Client Tool

I'd recommend http://www.sqliteexpert.com/. I've been using it for years and like it. On Sun, Jan 26, 2014 at 5:08 AM, big stone wrote: > Hello sqlite-users, > > I'm looking for a Graphic SQLite Client Tool to equip a classroom of old > windows PC. > > So far, the best

Re: [sqlite] System.Data.SQLite documentation

Yes! Thanks man, keep it smooth dude... you got it right. -Original Message- From: Joe Mistachkin Sent: Thursday, February 13, 2014 10:34 PM To: 'General Discussion of SQLite Database' Subject: Re: [sqlite] System.Data.SQLite documentation Incongruous wrote: Dude! Something

Re: [sqlite] System.Data.SQLite documentation

Incongruous wrote: > > Dude! Something must've happened to that file, there is a tree in the > Contents tab, but it doesn't matter which help file I click on nothing gets > displayed. The help files do not have any data in them! > What did I do wrong? > Not being able to open a downloaded

Re: [sqlite] System.Data.SQLite documentation

Thanks for the help Joe Mistachkin. Dude! Something must've happened to that file, there is a tree in the Contents tab, but it doesn't matter which help file I click on nothing gets displayed. The help files do not have any data in them! What did I do wrong? -Original Message- From:

Re: [sqlite] System.Data.SQLite documentation

Incongruous wrote: > > So, please, point me out to the location of the documentation for System.Data.SQLite. > https://system.data.sqlite.org/index.html/doc/trunk/Doc/SQLite.NET.chm?mimet ype=application/x-chm Also, please see the FAQ:

Re: [sqlite] Once again about random values appearance

> > select id, (select id from TestTable where id = abs(random() % 100)) > > as rndid from TestTable where id=rndid On Thu, 13 Feb 2014 07:26:55 -0500 Richard Hipp wrote: > It is undefined behavior, subject to change depending the specific > version of SQLite, compile-time

[sqlite] System.Data.SQLite documentation

After searching the archives for this year, I was really surprised that no one has ever asked for the documentation of System.Data.SQLite! I am very new in C# and with my little bit of knowledge I really need a lot of help for... even for just opening a connection to the database. I know that a

Re: [sqlite] Field not editable

On Thu, 13 Feb 2014 10:01:28 + Simon Slavin wrote: > Your question is an example of a long term discussion about whether > your entire business philosophy should be encoded within your SQL > databases, with numerous FOREIGN KEYs, CONSTRAINTs and TRIGGERs used > to

Re: [sqlite] Field not editable

On Thu, 13 Feb 2014 21:40:53 +0100 Zsbán Ambrus wrote: > > I want the name of the country can not be changed. > > You can put all the tables you want to be not changable to a separate > database file which you attach as read-only. Use the ATTACH statement > with the URI

Re: [sqlite] HTML Tokenizer

On 2014/02/13 22:35, Petite Abeille wrote: While we are at it, www.sqlite.org exhibits many validation errors: http://validator.w3.org/check?uri=http%3A%2F%2Fwww.sqlite.org%2F=%28detect+automatically%29=Inline=0=W3C_Validator%2F1.3+http%3A%2F%2Fvalidator.w3.org%2Fservices#result Yea I

Re: [sqlite] HTML Tokenizer

On Feb 13, 2014, at 9:52 PM, Jan Nijtmans wrote: > But if you put the validator in HTML5 mode, there are many less errors: Possibly. But it says 'HTML 4.01 Strict' on the tin: http://www.w3.org/TR/html4/strict.dtd”> Either way, a bunch of errors.

Re: [sqlite] HTML Tokenizer

2014-02-13 21:35 GMT+01:00 Petite Abeille : > > On Feb 13, 2014, at 9:08 PM, Petite Abeille wrote: > >> curl -s http://www.sqlite.org | lynx -nolist -stdin -dump > > While we are at it, www.sqlite.org exhibits many validation errors: > >

Re: [sqlite] Field not editable

On 2/13/14, O.D. vidal wrote: > I would like a field is not editable. What is the best solution? > > I want the name of the country can not be changed. You can put all the tables you want to be not changable to a separate database file which you attach as read-only. Use the

Re: [sqlite] HTML Tokenizer

On Feb 13, 2014, at 9:08 PM, Petite Abeille wrote: > curl -s http://www.sqlite.org | lynx -nolist -stdin -dump While we are at it, www.sqlite.org exhibits many validation errors:

Re: [sqlite] HTML Tokenizer

My current project needed to tokenize the text in HTML without the tags. The easy solution for us was to license a library from Chilkat that supported text extraction then tokenize that. I'm on my phone at the moment but could supply more details later if desired. SDR On Feb 13, 2014 1:02 PM,

Re: [sqlite] HTML Tokenizer

On Feb 13, 2014, at 8:48 PM, Wang, Baoping wrote: > New to Sqlite, anybody knows is there a HTML tokenizer for full text search, No. > Or do I need to implement my own? If you feel the urge. Otherwise, try lynx -dump. For example: curl -s http://www.sqlite.org | lynx

Re: [sqlite] HTML Tokenizer

> New to Sqlite, anybody knows is there a HTML tokenizer for full text search, > Or do I need to implement my own? There isn't an HTML tokeniser. But the default tokeniser considers punctuation like <> to be word breaks so it may already work for you with the down side that things like Hello!

[sqlite] HTML Tokenizer

New to Sqlite, anybody knows is there a HTML tokenizer for full text search, Or do I need to implement my own? Thanks Pursuant to Treasury Regulations, any U.S. federal tax advice contained in this communication, unless otherwise stated, is not intended and cannot be used for the purpose of

Re: [sqlite] C# - SQLite - and other things

Incongruous wrote: > > After downloading sqlite-netFx451-static-binary-x64-2013-1.0.90.0 and uncompressing > it, I got this list of file: > I think using the System.Data.SQLite NuGet package would be better in this case. The package is here (it can also be found by searching in the Visual

Re: [sqlite] How to use SQLite in C#

Good day, There are 2 different ideas to look into: 1) Using the API 2) Integrating tools into your IDE >From the prospective of my 32-bit Windows 7 machine. Under 1) Using the API If you are just using the API, then you don't need very many of those files. using System.Data.SQLite; Be sure to

[sqlite] C# - SQLite - and other things

After downloading sqlite-netFx451-static-binary-x64-2013-1.0.90.0 and uncompressing it, I got this list of file: Installer.exe Installer.pdb northwindEF.db SQLite.Designer.dll SQLite.Designer.pdb SQLite.Designer.xml SQLite.Interop.dll SQLite.Interop.pdb sqlite_file_list.txt

Re: [sqlite] Once again about random values appearance

On Thu, Feb 13, 2014 at 4:26 PM, Richard Hipp wrote: > On Thu, Feb 13, 2014 at 4:45 AM, Max Vlasov wrote: > > > Hi, > > > > probably was discussed and modified before, but I still can not > understand > > some peculiarities with random column values. > > >

Re: [sqlite] Field not editable

sorry, it works well with a trigger and raise(abort, ‘cause'). Le 13 févr. 2014 à 09:50, O.D. vidal a écrit : > > Hello all, > > I would like a field is not editable. What is the best solution? > > For example, I have a table Country: > > id - Name > > 1 - Brazil > 2 -

[sqlite] How to use SQLite in C#

After downloading sqlite-netFx451-static-binary-x64-2013-1.0.90.0 and uncompressing it, I got this list of file: Installer.exe Installer.pdb northwindEF.db SQLite.Designer.dll SQLite.Designer.pdb SQLite.Designer.xml SQLite.Interop.dll SQLite.Interop.pdb sqlite_file_list.txt

Re: [sqlite] Once again about random values appearance

On Thu, Feb 13, 2014 at 4:45 AM, Max Vlasov wrote: > Hi, > > probably was discussed and modified before, but I still can not understand > some peculiarities with random column values. > > The table > Create table [TestTable] ([id] integer primary key) > > populated with

Re: [sqlite] When is the decltype recognized?

On Thu, Feb 13, 2014 at 11:44 AM, Clemens Ladisch wrote: > By design, SQLite uses dynamic typing, and keeps only the actual type of > the value. The declared type is a property of the *column*, not of the > value itself, so it is lost as soon as the value is no longer

Re: [sqlite] When is the decltype recognized?

Peter Otten wrote: > Clemens Ladisch wrote: >> Peter Otten wrote: >>> Clemens Ladisch wrote: The first query uses a temporary table for sorting. The column in that temporary table does not have a declared type. The second query returns the values directly from the underlying

Re: [sqlite] When is the decltype recognized?

Clemens Ladisch wrote: > Peter Otten wrote: >> Clemens Ladisch wrote: >>> Peter Otten wrote: select * from (select alpha from demo union all select alpha from demo) order by alpha decltype: (null) select * from (select alpha from demo union all select alpha from demo)

Re: [sqlite] Field not editable

ok, thank you very much Simon! olivier Le 13 févr. 2014 à 11:01, Simon Slavin a écrit : > > On 13 Feb 2014, at 9:55am, O.D. vidal wrote: > >> Why do you say: >> >>> This would normally be done inside your programming language. >> >> strengthen the

Re: [sqlite] Field not editable

On 13 Feb 2014, at 9:55am, O.D. vidal wrote: > Why do you say: > >> This would normally be done inside your programming language. > > strengthen the rule directly in the database seems common sense. I can see that argument, which is why I bothered figuring out the TRIGGER.

Re: [sqlite] Field not editable

Thank you Simon! Why do you say: > This would normally be done inside your programming language. strengthen the rule directly in the database seems common sense. olivier Le 13 févr. 2014 à 10:37, Simon Slavin a écrit : > > On 13 Feb 2014, at 8:50am, O.D. vidal

[sqlite] Once again about random values appearance

Hi, probably was discussed and modified before, but I still can not understand some peculiarities with random column values. The table Create table [TestTable] ([id] integer primary key) populated with 100 default values (thanks to CTE now made with a single query): with recursive

[sqlite] [ANNOUNCEMENT] Updated: sqlite3-3.8.3.1-1 for Cygwin/Cygwin64

SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine Changes since 3.8.3-2 = * Updated to upstream 3.8.3.1 release. See: * One additional bug-fix in

Re: [sqlite] Field not editable

On 13 Feb 2014, at 8:50am, O.D. vidal wrote: > I would like a field is not editable. What is the best solution? > > For example, I have a table Country: > > id - Name > > 1 - Brazil > 2 - Canada > ... > > I want the name of the country can not be changed. This would

Re: [sqlite] SQlite3 Performnace

.timer on (in the sqlite shell) Unless you are storing the databases on different disks AND your SQLite queries are IO bound I don't expect any performance gains. -Ursprüngliche Nachricht- Von: techi eth [mailto:techi...@gmail.com] Gesendet: Donnerstag, 13. Februar 2014 10:11 An:

[sqlite] SQlite3 Performnace

Hi, Is there any way I can check SQlite3 Database read/write timing for performance measurement. What are the changes in performance if I have single SQlite3 Database file (Contain 'N' table) or 'N' Database file each contain single table. Regards, Techi

Re: [sqlite] When is the decltype recognized?

Peter Otten wrote: > Clemens Ladisch wrote: >> Peter Otten wrote: >>> select * from (select alpha from demo union all select alpha from demo) >>> order by alpha >>> decltype: (null) >>> >>> select * from (select alpha from demo union all select alpha from demo) >>> decltype: custom >>> >>> Even

[sqlite] Field not editable

Hello all, I would like a field is not editable. What is the best solution? For example, I have a table Country: id - Name 1 - Brazil 2 - Canada ... I want the name of the country can not be changed. Thank you! Greetings olivier ___