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
___
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 taking
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
.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:
On 13 Feb 2014, at 8:50am, O.D. vidal pa...@mac.com 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 normally be
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:
http://www.sqlite.org/releaselog/current.html
* One additional bug-fix in
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
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 slav...@bigfraud.org a écrit :
On 13 Feb 2014, at 8:50am, O.D. vidal
On 13 Feb 2014, at 9:55am, O.D. vidal pa...@mac.com 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.
However,
ok, thank you very much Simon!
olivier
Le 13 févr. 2014 à 11:01, Simon Slavin slav...@bigfraud.org a écrit :
On 13 Feb 2014, at 9:55am, O.D. vidal pa...@mac.com wrote:
Why do you say:
This would normally be done inside your programming language.
strengthen the rule directly in the
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)
decltype: custom
Even
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 table
column, so the
On Thu, Feb 13, 2014 at 11:44 AM, Clemens Ladisch clem...@ladisch.de 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 associated
On Thu, Feb 13, 2014 at 4:45 AM, Max Vlasov max.vla...@gmail.com 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 100 default
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
sorry, it works well with a trigger and raise(abort, ‘cause').
Le 13 févr. 2014 à 09:50, O.D. vidal pa...@mac.com 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 - Canada
...
On Thu, Feb 13, 2014 at 4:26 PM, Richard Hipp d...@sqlite.org wrote:
On Thu, Feb 13, 2014 at 4:45 AM, Max Vlasov max.vla...@gmail.com wrote:
Hi,
probably was discussed and modified before, but I still can not
understand
some peculiarities with random column values.
It is undefined
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
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
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 Studio
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
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 div
On Feb 13, 2014, at 8:48 PM, Wang, Baoping bw...@kelleydrye.com 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
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,
On Feb 13, 2014, at 9:08 PM, Petite Abeille petite.abei...@gmail.com wrote:
curl -s http://www.sqlite.org | lynx -nolist -stdin -dump
While we are at it, www.sqlite.org exhibits many validation errors:
On 2/13/14, O.D. vidal pa...@mac.com 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 ATTACH
2014-02-13 21:35 GMT+01:00 Petite Abeille petite.abei...@gmail.com:
On Feb 13, 2014, at 9:08 PM, Petite Abeille petite.abei...@gmail.com wrote:
curl -s http://www.sqlite.org | lynx -nolist -stdin -dump
While we are at it, www.sqlite.org exhibits many validation errors:
On Feb 13, 2014, at 9:52 PM, Jan Nijtmans jan.nijtm...@gmail.com 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:
!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.01//EN
http://www.w3.org/TR/html4/strict.dtd”
Either
On 2014/02/13 22:35, Petite Abeille wrote:
While we are at it, www.sqlite.org exhibits many validation errors:
On Thu, 13 Feb 2014 21:40:53 +0100
Zsbán Ambrus amb...@math.bme.hu 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 filename
On Thu, 13 Feb 2014 10:01:28 +
Simon Slavin slav...@bigfraud.org 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 enforce how
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
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 d...@sqlite.org wrote:
It is undefined behavior, subject to change depending the specific
version of SQLite, compile-time options,
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:
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:
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 CHM file
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
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 stonebi...@gmail.com 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 option
On Fri, Feb 14, 2014 at 6:35 AM, James K. Lowden
jklow...@schemamania.orgwrote:
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 d...@sqlite.org wrote:
It is undefined behavior,
39 matches
Mail list logo