On my whish-list for this list is the possibility to include attachments like
screenshots and databases.
For program more handy functions and documentation more examples. I'm pretty
sure that less lazy users made functions that could be included as standard to
be used for all of us.
Kind
Happy New Year, Joe and other SML-members,
You answered your own question in the title of your post perfectly.
If you want to post the results of .fullschema here as well you provide us with
almost every detail of the way you coded your database.
Perhaps you mean other code in what language and
Apache Camel: Source
| |
| | | | | |
| Apache Camel: SourceWarning Icon Apache Camel code repository was moved to
git, The old svn repo will not be updated. Web Browsing of git To browse via
the web: |
| |
| View on camel.apache.org | Preview by Yahoo |
| |
| |
Kind regards
Mitch asked how to update SQLite in Anaconda,
1. Perhaps you better ask this in a Python-forum as well.2. Please tell them
and us what operating system you use3. Happy New Year
Kind regards | Cordiali saluti | Vriendelijke groeten | Freundliche Grüsse,
Klaas `Z4us` V - OrcID -0001-7190-2544
Jim Callahan wrote:#26 The unique columns have non-null values (the answer
says a lot more,but that is the essence of what I am relying on).
Right, but the question was how to count rows as quickly as possible regarding
any or all columnse.g. count(ProspectName) from Clients;
One can imagine
Venkatarangan MJ wrote:
How do I unsubscribe from the group as I have stopped using SQLITE from quite
some time now?
Thanks.
Regards
Rangan.
Send a message with subject or body 'help' to sqlite-users-requ...@sqlite.org
This is written in the header of each digest; I don't know about single
Simon wrote about parts of names like e.g. the Dutch/Flemish 'van'
They should definitely not be capitalised
Is not always true. Especially in northern Belgium names are often spelled like
Van (often even connected with the last name) and I did personally the same to
see which of the two
Dominique Devienne wrote:
(double-click on new version) SQLite version 3.8.5 2014-06-04 14:06:34
(terminal) SQLite version 3.7.13 2012-07-17 17:46:21
This means you downloaded the new version in a directory not in your $PATH
Add it to your path:
set PATH=dir where new version is: $PATH
If
Jan wrote: ** can manually set this value to 1 to emulate Win98 behavior.
*/
Can anyone give me one good reason apart from nostalgia to support a MS system
not supported by MS?
Kind regards | Cordiali saluti | Vriendelijke groeten | Freundliche Grüsse,
Klaas `Z4us` V - OrcID
Like some others I vote for solution 6.
In general accepting hexadecimal notation for floating point values exceeding
64 bits is too developer/scientist friendly. Who needs so much precision use
Fortran or another specialized language rather than SQL of any flavor. My €
2E-2
Philip wrote:
Is it possible to tell the spellfix extension not to accept duplicate
words if the rank and langid are exactly the same? I am collecting words
from many different sources and after inserting them I very often get
the same word back several times.
Add a 'unique' constraint in
James K. Lowden wrote:
If the answer to every question, concern, and suggestion is that it
already works for millions of programs, there is no point in discussion
or further development. Just use what's there because it's already
perfect.
Permission to differ, James!
Since there is no such
Renji Panicker wrote to this fine list:
- As per the sqlite3PagerOpen function, the size of the memory allocated to
this pointer is ROUND8(pVfs-szOsFile).
What configuration you're using, Renji?
On some OS/browser/SupportSoftware etc. combinations this function may crash
FYI: SQLite2.8.17 for some Linux-versions (and Apple ppc) can be found here:
http://www.rpmfind.net/linux/rpm2html/search.php?query=sqlite2
Perhaps there are applications to convert to a more contemporary format like
3.8.4.3
Kind regards | Cordiali saluti | Vriendelijke groeten | Freundliche
On 3 May 2014, at 3:47pm, Petite Abeille petite.abei...@gmail.com wrote:
Let further assume one would like to use only SQLite's build-in mechanism
Where Simon answered: There are two kinds of programmers ...
I tend to disagree, in fact there are at least three kinds
1 Application programmers
Patrick asked
Where did the release announcements go?
This is the right place to go. Here you find announcements of new versions,
planned updates and bug-fixes even before they arrive at
Recent SQLite News
Recent SQLite News
Small. Fast. Reliable. Choose any three. About Sitemap
Muhammad wrote:
| ... two identical sqlite databases from structure side. I want to make a
synchronization for the data ...
| Is there any library can do that OR I've to do it by myself?
With an Apple you can do it within SQLite itself.
http://www.sqlite.org/pragma.html#pragma_fullfsync
To do
| JN: ... the Cygwin VFS to behave the same as other UNIX'es
Warning: Off topic: RTF* and Gnu's Not Unix
Two answers from Cygwin's FAQ
Q: What?
A The Cygwin tools are ports of the popular GNU development tools for Microsoft
Windows.
They run thanks to the Cygwin library which provides the
Kees wrote answering Ashleigh
| If you prefer a graphical user interface, I can recommend
|the sqlite manager plugin in the Firefox web browser.
|| If any one knows a better way to read and understand the files I would
greatly appreciate it
|| |I think the file ext. is a plist.
|| Live,
Tejas Parekh wrote: both processes use common database db1.s3db file to store
data.
Unfortunately SQLite does not allow more than one process to write a single
file the same time. The one writing process should unlock his database in
order to make it possible to others to make changes to
From: Keith Medcalf kmedc...@dessus.com
Date: 7 Feb 2014 18:03:12 GMT+01:00
To: General Discussion of SQLite Database sqlite-users@sqlite.org
Reply-To: General Discussion of SQLite Database sqlite-users@sqlite.org
Have your application that is performing the update send an email when it does
Anbrus wrote:
what's the easiest way to generate a set of fixed number of rows like
VALUES does but in an order of your choice?
Order them before with the command 'sort'
NAME
sort - sort lines of text files
SYNOPSIS
sort [OPTION]... [FILE]...
DESCRIPTION
Write sorted
|Igor Tandetnik wrote:
| On 1/30/2014 7:20 PM, James K. Lowden wrote:
|or define a constraint
|
|colname boolean check (colname in ('Y', 'N'))
|
|Of course you can use 0 and 1, but there's no technical advantage
|There is a tiny advantage. Values 0 and 1 are special-cased in
On Jan 22, 2014, at 8:21 AM, Richard Hipp d...@sqlite.org wrote:
I seem to recall seeing some SMS databases off of an iPhone that used unix
timestamps for the date/time. That would be seconds since 1970. You can
use the 'unixepoch' modifier on the datetime functions within SQLite to do
the
Clemens wrote:
$ sqlite3
SQLite version 3.8.3 2014-01-11 12:52:25
Enter .help for instructions
Enter SQL statements terminated with a ;
sqlite .header on
sqlite values(1);
(null)
1
sqlite .mode html
sqlite values(1);
Segmentation fault
One runs the risk stumbling upon
Tobias wrote ... simpler just to have afterwards some things to do in my
program?
What is 'simple' is an off topic discussion. More important is the reason of
making changes by you and/or your colleagues.
I've seen coding in a procedural language I could only figure out by reading
the pseudo
When you'use the word 'perfornance' you might be interested not jonly in speed,
but in strength of protection, privacy of the employees, your company as a
whole and above all your clients.
One of the goals of encryption is to avoid e.g. the government(s and the spies
they hired to peek into
Warren wrote 4 dec 2013:
| There are tiny corners of the programming world (FP) where this is not the
case, but then you get into
| questions of purity, and databases are about as far from side-effect-free
as you can get.
That's a wee bit exaggerated, but who am I to start a discussion;
On Mon, Nov 4, 2013 at 6:12 AM, SongbookDB shaun_thom...@songbookdb.comwrote:
Thanks Clemens
Flash gives the error - no such function: 'sqlite_version'
SQLite Administrator says 3.5.1
I'll see what the Adobe community say.
Or just .v
-
Richard wrote:
The question for today is what to call this magic hint function:
(1) unlikely(EXPR)
(2) selective(EXPR)
(3) seldom(EXPR)
(4) seldom_true(EXPR)
(5) usually_not_true(EXPR)
Please feel free to suggest other names if you think of any.
I dislike #4 and#5, but what about one
Dear fellow users and managers of SQLite,
Alexey Pechnikov wrote:
Bad idea. The schema definition can't be modified!
In fact it's possible if you use the writable schema pragma
http://www.sqlite.org/pragma.html#pragma_writable_schema
An application could drop all applicable `ls -l` and `id
Dear fellow SQLite afficionados,
Thanumalayan Sankaranarayana Pillai madth...@cs.wisc.edu wrote:
I expect it wouldn't be a problem with WAL
Thé SQLite (not wanting, but cobsidering him at leat kind of) Force D. Richard
H. [who does not know Him don't read this message, you won;t understand
Eelco wrote:
Using version 3.7.16.2
select * from ((select * from x)) y;
Segmentation fault
On OSX we get 'Bus error'. Not a bug, because you were syntactical not exact
enough.
See http://www.sqlite.org/lang_select.html
You're supposed to use only one pair () not more. Before 3.7.15 or 16
On Sun, 21 Apr 2013 11:15:23 +0800 (CST), 刘运杰 yunjie@163.com
wrote:
Ok,I do not make my means clearly. I mean 60 seconds after my
program started,not token 60 seconds to load database file.
...
Now,I modify the implement of batch query, it take about one
second and 70k IO writing.So there are
Mohit wrote:
Can you use double quotes in the query?
In this case no problem, double quotes are ignored around a tbl_name
sqlite create temp table db..test(c1 integer, c2);
sqlite insert into db..test values (1, 'sqlite_temp_master');
sqlite insert into db..test values (2, 'db..test');
sqlite
procedure I would say about 250 tops
and stop.
Cordiali saluti/Vriendelijke groeten/Kind regards, Klaas V
http://innocentisart.net
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
, Richard Hipp d...@sqlite.org wrote:
Hi,
Is it possible to corrupt a single table among 10 tables in a database?
Is it possible to corrupt some records among millions of records in a
table?
Yes. Yes.
Cordiali saluti/Vriendelijke groeten/Kind regards,
Klaas V
http
sqlite3_open16 accepts file names in UTF-16 encoding. You would need to
convert your file names from this extended ASCII (by which I imagine
you mean system-default codepage, aka CP_ACP) to one of the two
supported encodings.
Cordiali saluti/Vriendelijke groeten/Kind regards,Klaas V
remember exact update) successfully under Vista two years
ago. Now we have OSX ( SQLite r.v.u 3.7.13)
Cordiali saluti/Vriendelijke groeten/Kind regards,
Klaas V
http://innocentisart.net
___
sqlite-users mailing list
sqlite-users@sqlite.org
http
b
where b.id between a.id - 3 and a.id)
from tbl a;
- 3 should be - 2. You're working with the last 4 days and might get an error
if id=3
:P
Cordiali saluti/Vriendelijke groeten/Kind regards,
Klaas V
http://innocentisart.net
Richard Hipp wrote:
Copy Makefile.linux-gcc into Makefile. Edit to suite your system. Type
make
When a compiled version of sqlite4 will be released? We're on OSX Snow Leopard.
Cordiali saluti/Vriendelijke groeten/Kind regards,
Klaas V
http://innocentisart.net
41 matches
Mail list logo
