;
sqlite> INSERT INTO T VALUES (2,x'323232');
sqlite> UPDATE T SET bl=x'33' WHERE bl=x'323232';
sqlite> SELECT * FROM t;
1|111
2|333
sqlite> DELETE FROM t WHERE bl=x'313131';
sqlite> SELECT * FROM t;
2|333
sqlite>
>Thank you,
>J
ch queue.
Are you sure the temp objects are accessed via the same
connection (db object) as where they were created?
> Is there a better multi-threaded approach?
I'll leave that to someone more experienced in threading.
--
Regards,
Kees Nuyt
_
On Mon, 27 Oct 2014 07:20:04 +1100, Isaac Faulkner
wrote:
>
>
>I did not sign up for this someone hacked my email stop spamming me please
Visit the link below, make it send your password, then login and
unsubscribe.
Regards,
don't (have to) care
about concurrency at all, so the concurrency that SQLite
supports is a lot already.
There are enough other products available that target that
market.
> Thanks a lot.
You're welcome.
--
Regards,
Kees Nuyt
___
sqlite-users ma
On Wed, 15 Oct 2014 01:26:10 +0200, Kees Nuyt
wrote:
> http://knuyt.demon.nl/sqlite.org/faq.html#q19
Oops, make that
http://www.sqlite.org/faq.html#q19
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mail
the performance of sqlite3
> in this scenario?
I suspect this is a case of
http://knuyt.demon.nl/sqlite.org/faq.html#q19
--
Regards,
Kees Nuyt
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
unctions a totally separate program (which would be, I
> think, a poor
> way to do this). It might help if there were wsome way to determine the
> database status in
> some way which could tell me what state it's in (open for viewing, locked,
> unlocked, etc).
>
> Ca
data
c.execute("""insert into stocks
values ('2006-01-05','BUY','RHAT',100,35.14)""")
https://pysqlite.readthedocs.org/en/latest/sqlite3.html
No idea whether that solves your problem.
--
Regards,
Kees Nuyt
qlite3_step(), and finally sqlite3_reset() to use the
same compiled statement again and again.
That way, there is no need to _finalize() and _prepare() every
time, and you may not need that optimization at all.
--
Groet,
Kees Nuyt
___
sqlite-users mailing
On Fri, 3 Oct 2014 18:39:29 +0530, Prakash Premkumar
wrote:
> Can you please tell me which function is
> sqlite actually generates the Vdbe
> program for a give sql string ?
http://www.sqlite.org/c3ref/prepare.html
--
Groet,
Kees Nuyt
_
o post export from the other database to change the
> values correctly?
Have a look at
http://sqlite.org/datatype3.html
"2.3 Column Affinity Behavior Example"
--
Groet,
Kees Nuyt
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
t1 (x,y) VALUES (2,5);
SELECT * FROM t1;
1 1
2 2
3 3
3 4
2 5
SELECT max(x), y FROM t1;
3 3
SELECT y FROM (SELECT max(x), y FROM t1);
5
SELECT m, y FROM (SELECT max(x) as m, y FROM t1);
3 3
SELECT y FROM t1 WHERE x=(SELECT m
On Sat, 13 Sep 2014 00:55:23 +0200, Kees Nuyt
wrote:
> It works better on your local filesystem.
Perhaps you can configure (a partition on) the Seagate GoFlex as
an iSCSI target and configure an iSCSI initiator on the PC ?
A quick websearch on "seagate goflex iscsi" suggests that&#
n to be buggy or even unimplemented on
many NFS implementations (including recent versions of Mac OS X)
and that there are reports of locking problems for network
filesystems under Windows. Your best defense is to not use
SQLite for files on a network filesystem. "
It works better on your local filesystem.
--
Regards,
Kees Nuyt
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Fri, 12 Sep 2014 23:23:39 +0100, Simon Slavin
wrote:
>
>On 12 Sep 2014, at 10:33pm, Kees Nuyt wrote:
>
>> Sure, it's all available at
>> https://system.data.sqlite.org/
>>
>> I think the material there covers most of the questions.
>
>So the
unity:
printf "PRAGMA page_size=bytes; VACUUM;\n" \
| sqlite3 benchmark.sqlar
>Eric
>
>References:
>
>http://sqlite.1065341.n5.nabble.com/Internal-v-External-BLOBs-td15515.html
>http://www.sqlite.org/intern-v-extern-blob.html
--
Groet,
Kees Nuyt
_
a pointer to that document as a first approximation to an
> answer, whether they understand the question or not.
>
> If such document already exists, could someone post a pointer ?
Sure, it's all available at
https://system.data.sqlite.org/
I think the material there covers most of the questions.
--
Groet,
Kees Nuyt
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Thu, 11 Sep 2014 23:49:22 +0200, Kees Nuyt
wrote:
> Today I bumped into a presentation about ordering and atomicity
> of filesystems that might interest you.
>
> https://www.youtube.com/watch?v=YvchhB1-Aws
Compliments for sqlite at 43
dison
Talk at usenix 2014 Published on Sep 4, 2014 by USENIX
Association Videos
Somewhat related to the article drh recently wrote about using
sqlite as an application data store.
--
Regards,
Kees Nuyt
___
sqlite-users mailing list
sqlite-users@sqlit
On Fri, 8 Aug 2014 11:14:29 +0200, Giuseppe Costanzi
wrote:
>>>> sqlite3.sqlite_version
>'3.5.9'
Version 3.5.9 is more than 6 years old. A lot of optimizations
were introduced since that version. Please upgrade and try
agai
rogramming error or
some form of memory (heap) corruption.
Try to run the program with a debugger to pinpoint the error.
--
Groet, Cordialement, Pozdrawiam, Regards,
Kees Nuyt
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Miguel Fernandes
--
Groet, Cordialement, Pozdrawiam, Regards,
Kees Nuyt
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Thu, 17 Jul 2014 13:06:36 +0530, Sky Meena
wrote:
> how to set a password to open a sqlite db in sqlite browser
Answered in a different thread 2 minutes ago.
--
Regards,
Kees Nuyt
>On Thu, Jul 17, 2014 at 7:18 AM, RSmith wrote:
>
>>
>> On 2014/07/16 14:
e able to open an
encrypted SQLite database.
Hope this helps
--
Regards,
Kees Nuyt
>On Fri, May 9, 2014 at 6:05 PM, Simon Slavin wrote:
>
>>
>> On 9 May 2014, at 1:23pm, Sky Meena wrote:
>>
>> > i working in server client... c program. i need to transfer db fr
On Mon, 14 Jul 2014 12:09:46 +0100, Simon Slavin
wrote:
> On 14 Jul 2014, at 11:19am, Kees Nuyt wrote:
>
> > On Sun, 13 Jul 2014 18:00:59 +0100, Simon Slavin
> > wrote:
> >
> >> I had to explain to some users that a database
> >> change
; .execute().
His follow-up article is nice too:
<http://sebastianraschka.com/Articles/2014_sqlite_in_python_tutorial.html>
--
Groet, Cordialement, Pozdrawiam, Regards,
Kees Nuyt
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sq
irectory in
an atomic fashion, which would be necessary to maintain
consistency for sqlite or any other software that works on
time-coordinated sets of files.
In my opinion dropbox should not be used on directories with
SQLite databases at all. It would be better to only allow
dropbox access to
ses to sqlite3.
sqlite3 is current and actively maintained / optimized.
Differences (as perceived almost 10 years ago):
http://www.sqlite.org/version3.html
Release history:
http://www.sqlite.org/changes.html
Hope this helps.
--
Regards,
Kees Nuyt
___
3 is current and actively maintained / optimized.
Differences (as perceived almost 10 years ago):
http://knuyt.demon.nl/sqlite.org/version3.html
Release history:
http://knuyt.demon.nl/sqlite.org/changes.html
Hope this helps.
--
Regards,
Kees Nuyt
will be hidden, yet
accessible.
Without INTEGER PRIMARY KEY, the ROWID is still there, but it is hidden.
Check it with PRAGMA table_info(test);
You will see the id column, never a ROWID column.
I think this behaviour is consistent with
http://sqlite.org/lang_createtable
, it seems to be
> very confusing behaviour.
Perhaps http://www.sqlite.org/c3ref/next_stmt.html
is useful here.
--
Groet, Cordialement, Pozdrawiam, Regards,
Kees Nuyt
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
your posts ? Make sure we can see both the full
> error text and which line of code it's complaining about.
The error report was included, you just have to scroll down a bit more.
--
Groet, Cordialement, Pozdrawiam, Regards,
Kees Nuyt
___
VALUES
(1,3,4,0),(2,3,5,1),(3,7,4,1),(4,7,5,0);
or even:
REPLACE INTO TeamPersonTable
(tpId,teamId,personId,orderId)
VALUES
(1,3,4,0),(2,3,5,1),(3,7,4,1),(4,7,5,0);
http://www.sqlite.org/lang_insert.html
--
Groet, Cordialement, Pozdrawiam, Regards,
Kee
ERE cluase determines which rows are updated.
>Cheers.
--
Groet, Cordialement, Pozdrawiam, Regards,
Kees Nuyt
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
e.org/sar/doc/trunk/README.md
--
Groet, Cordialement, Pozdrawiam, Regards,
Kees Nuyt
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
LICT clause:
http://sqlite.org/lang_conflict.html
--
Groet, Cordialement, Pozdrawiam, Regards,
Kees Nuyt
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
gt; insert into U values(4)
>
> and it works but i don't want to, because the value 4 is not in T.
> I've tried PRAGMA foreign_keys first, but it's the same.
Old version perhaps?
--
Groet, Cordialement, Pozdrawiam, Regards,
Kees Nuyt
emselves, they take hardly any storage
at all, ust the type indicator that every every row has for every
column.
--
Groet, Cordialement, Pozdrawiam, Regards,
Kees Nuyt
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-b
ble within SQL
>queries?
PDO used to have a variant pdo_sqlite3_external (or similar name), which
linked dynamically to a standard sqlite3 library, but that wasn't
supported on all platforms (don't remember which though).
It was a great solution, because you could upgrade sqlite3 ind
ssil repository,
http://www.sqlite.org/cgi/src/doc/trunk/README.md
The Makefile will tell you what sqlite3_analyzer is made of.
--
Groet, Cordialement, Pozdrawiam, Regards,
Kees Nuyt
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.o
s users may want to add:
CC += -D_XOPEN_SOURCE=500 -O2
to the Makefile.
For completeness, I also added target:
clean:
-rm sar sqlite3.o
--
Groet, Cordialement, Pozdrawiam, Regards,
Kees Nuyt
___
sqlite-users mailing list
sqlite-us
n't worry about
it unless you are in a very fast real-time environment.
Premature optimization is the root of all evil.
--
Groet, Cordialement, Pozdrawiam, Regards,
Kees Nuyt
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
the date formatting functions in your select
statement to change the presentation.
http://sqlite.org/lang_datefunc.html
--
Groet, Cordialement, Pozdrawiam, Regards,
Kees Nuyt
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
drawiam, Regards,
Kees Nuyt
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
transaction.
BEGIN;
DELETE FROM table1 WHERE ...;
DELETE FROM table2 WHERE ...;
COMMIT;
--
Groet, Cordialement, Pozdrawiam, Regards,
Kees Nuyt
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
t; http://sqlitestudio.pl
> http://www.valentina-db.com
> http://www.navicat.com/products/navicat-for-sqlite
Not what you asked for, but LibreOffice Base can use SQLite via ODBC:
http://ch-werner.de/sqliteodbc/
I have no experience with that solution, but at least the package is
maintained and
7;')) from q;
[2014-03-08 11:02:52] < zzo38> Do you like quine program in SQL?
[2014-03-08 11:03:06] < zzo38> Maybe do you have a better (shorter) one?
Note:
SQL preferably written as a oneliner
References:
http://en.wikipedia.org/wiki/Quine_(computing)
to the developer of "sqlLite administrator",
apparently this public beta is not fit for general availability.
HTH
--
Groet, Cordialement, Pozdrawiam, Regards,
Kees Nuyt
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
to read and understand the files I would
> greatly appreciate it
>I think the file ext. is a plist.
>Live, love & laugh.
>
--
Groet, Cordialement, Pozdrawiam, Regards,
Kees Nuyt
___
sqlite-users mailing list
sqlite-users@sqlite.org
veryone that
>has attempted to figure this out has been stumped. I am using Microsoft
>Visual Studio 2012 and C++.
Which version of MS Windows?
What is the path to the database file?
Is the database perhaps stored in a "protected" directory?
Any errors on execution of the BEGIN and
replayed and deleted.
>
> Is my understanding correct?
Yes.
--
Groet, Cordialement, Pozdrawiam, Regards,
Kees Nuyt
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
literal but an identifier, just like
table names and column names.)
--
Groet, Cordialement, Pozdrawiam, Regards,
Kees Nuyt
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Mon, 10 Feb 2014 14:18:18 -0500, C M
wrote:
>On Sat, Feb 8, 2014 at 4:28 AM, Kees Nuyt wrote:
>>
>> On Sat, 08 Feb 2014 12:06:01 +0700, Dan Kennedy
>> wrote:
>
>
>
>> >> SQLITE_LOG: delayed 1375ms for lock/sharing conflict (10) SQLITE_IOERR
tter idea of what could be happening and how I
>> can fix this problem?
>
>Looks like GetFileAttributesEx() might be throwing an ERROR_ACCESS_DENIED
>exception. Maybe a virus scanner or some other background process had
>temporarily locked the database file.
>
>Dan.
I agree, and
/get_autocommit.html can help you decide
what mode you are in.
By the way, autocommit is not the best thing to do if you have
related insert/update/delete statements in an application
transaction. Related updates should be in the same, atomic,
ll you.
I hope this helps.
--
Groet, Cordialement, Pozdrawiam, Regards,
Kees Nuyt
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
figure \
&& make \
&& mv -f fossil ${HOME}/usr/bin/fossil \
&& make clean \
&& cd
set +xv
}
On Solaris, I complie trunk every now and then, on MS Windows, I run the
released executables.
I'll try the same on XStreamOS
iam, Regards,
Kees Nuyt
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
e is an
easy workaround
(oneliner wrapped by mail) :
printf ".output stderr\nPRAGMA busy_timeout =1000;\n.output stdout\ncreate
table foo as select 1 as
c;select * from foo;" |sqlite3 2>/dev/null -html -header :memory:
yields:
c
1
--
Groet, Cordialement, Pozdrawiam, Regards,
Kees
advanced / etc.)
Remark: Do you know that concurrent access to sqlite files
on network shared filesystems is not safe?
--
Groet, Cordialement, Pozdrawiam, Regards,
Kees Nuyt
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:808
t and 64-bit Windows OS.
Only for very large databases you may need SQLite compiled for 64 bit.
Typically, that is not something a newbie would do.
>Regards
>Krishna
--
Groet, Cordialement, Pozdrawiam, Regards,
Kees Nuyt
___
sqlite-users m
t better/quicker/more
answers if you also post:
- a minimal set of sample data that
can demonstrate the problem
- expected result
- obtained result
--
Groet, Cordialement, Pozdrawiam, Regards,
Kees Nuyt
___
sqlite-users mailing list
sqlite-users@s
ermediate result set.
For faster pagination, read :
http://sqlite.org/cvstrac/wiki?p=ScrollingCursor
--
Groet, Cordialement, Pozdrawiam, Regards,
Kees Nuyt
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
c WHERE name=?);
>
>Anyone have a hint on how to perform such as query?
Perhaps:
INSERT OR IGNORE INTO table_a
(
col_a,
col_b,
col_c,
col_d
) VALUES (
(SELECT id FROM table_b WHERE name=?)
,?
,?
,(SELECT id FROM table_c WHERE name=?)
);
>Tha
27;"}'
FROM .
I use .mode line sometimes, which is easy to postprocess,
or .mode list with .separator '\001', if the data is suitable.
--
Groet, Cordialement, Pozdrawiam, Regards,
Kees Nuyt
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
issed part of the spec.
I'm sure the OP will sort it out after so many hints :)
>On 2013/11/18 13:55, Kees Nuyt wrote:
>> On Mon, 18 Nov 2013 13:04:31 +0200, RSmith wrote:
>>
>>> Oops, misprint...
>>>
>>> name won't be null of course, the par
uery. if key and name available, execute 2nd
>>> query.
>>>
>>> Is it possible to write in single query?
>>>
>>> Regards,
>>> va
>>> ___
>>> sqlite-users mailing list
>>> sqlite-users@
ng the risk of reading some of it before a change and some of it after
>> the change. So yes, you need some form of mutex. Or to use the SQLite
>> backup API to read the file. Or to use the normal SQLite API to open the
>> file read/only and read all the data.
>>
>> Simon.
--
Groet, Cordialement, Pozdrawiam, Regards,
Kees Nuyt
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Sat, 16 Nov 2013 23:59:35 +0100, Petite Abeille
wrote:
>
>On Nov 16, 2013, at 11:02 PM, Kees Nuyt wrote:
>
>> For the application, the merge would look like a single
>> INSERT INTO merge_t statement.
>
>H…. clever lateral thinking, but I doubt this will fly
he SQL
could probably be generated by a smart m4 macro.
--
Groet, Cordialement, Pozdrawiam, Regards,
Kees Nuyt
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
S 'index1'; ? Doing so still shows the index when I load the
>database in SQLite Administrator.
What operating system are we talking about?
What is the exact full path to the database file?
--
Groet, Cordialement, Pozdrawiam, Regards,
Kees Nuyt
___
oet, Cordialement, Pozdrawiam, Regards,
Kees Nuyt
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
ond run
was optimized out.
--
Groet, Cordialement, Pozdrawiam, Regards,
Kees Nuyt
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
URL. You can build it yourself by checking out the
correct version of the fossil repositories (links at the bottom of the
http://sqlite.org/download.html page).
Hope this helps.
--
Groet, Cordialement, Pozdrawiam, Regards,
Kees Nuyt
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
w are the computers you are using accessing the same file ? Are you using
>access across a network ? If so, what network protocol are you using ?
>
>Simon.
>___
>sqlite-users mailing list
>sqlite-users@sqlite.org
>http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
--
Groet, Cordialement, Pozdrawiam, Regards,
Kees Nuyt
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Wed, 18 Sep 2013 20:53:31 -0700 (PDT), niubao
wrote:
>Thank you very much Simon, for your detailed and very clear explanation on
>this. I wonder if there is some materials, a tutorial or something, that
>are dedicated to SQLite schema change for beginners?
>
>There seems to be so many things t
/code.google.com/p/sqlite-manager/ should meet your needs
+1
--
Groet, Cordialement, Pozdrawiam, Regards,
Kees Nuyt
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
t should be the difference
between CURRENT_TIME and datetime('now')?
just my two cents...
--
Groet, Cordialement, Pozdrawiam, Regards,
Kees Nuyt
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
ts based on
>one
>select from the PK generating initial insert.
>
>Thanks,
>jlc
HTH
--
Groet, Cordialement, Pozdrawiam, Regards,
Kees Nuyt
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Wed, 4 Sep 2013 10:57:44 +0530, Pratheek Prakash
wrote:
> Hi Kees Nuyt,
>
> That was really helpful. Also I have another doubt.
> Eventually I will be running sqlite integrated with other
> modules in a board.
That is what SQLite is made for.
> As far as I have read I s
he Unix VFS may serve as an example.
A good starting point in the documentation is:
http://sqlite.org/custombuild.html
>Regards
>Pratheek
--
Groet, Cordialement, Pozdrawiam, Regards,
Kees Nuyt
___
sqlite-users mailing list
sqlite-users@sqlite.org
y: there are too many
>possibilities and it requires too good an understanding
>of how the query planner works for non-experts.
>There's no substitute for actual testing.
>
>Simon.
--
Groet, Cordialement, Pozdrawiam, Regards,
Kees Nuyt
__
bly not
> but he did not
> try to seek for wikipedia sqlite in google?
Yes, that probably means he is young and has not learned how to do
research yet.
> It is just me or it is quite weird?
Weirdness is common on the internet.
--
Groet, Cordialement, Pozdr
e.
Every connection will respect it.
--
Groet, Cordialement, Pozdrawiam, Regards,
Kees Nuyt
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
orting the pk-ness of a column is likely to be
>intentionally not correct for views.
Indeed.
>Thomas
--
Groet, Cordialement, Pozdrawiam, Regards,
Kees Nuyt
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
ents you cannot implement using the above, you may need to
create additional meta data tables.
--
Groet, Cordialement, Pozdrawiam, Regards,
Kees Nuyt
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_reset()
end loop 1
_finalize()
But perhaps I don't understand your problem?
--
Groet, Cordialement, Pozdrawiam, Regards,
Kees Nuyt
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
he identifier.
attach database 'file:test.db' as test;-- OK
attach database 'file:test.db' as 123test; -- not OK
attach database 'file:test.db' as test123; -- OK
Note: these are database names, not table names.
A double quoted database identifier as in "123test&q
ce: sqlite3_get_table().
http://www.sqlite.org/c3ref/free_table.html
--
Groet, Cordialement, Pozdrawiam, Regards,
Kees Nuyt
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
al ROWID column, saving an integer
column. Also, JOIN performance on rowindex will be better as it removes
one level of indirection.
--
Groet, Cordialement, Pozdrawiam, Regards,
Kees Nuyt
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
n be
automatic in some versions of _prepare().
In most applications the schema is quite static.
my EUR 0.02
--
Groet, Cordialement, Pozdrawiam, Regards,
Kees Nuyt
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/m
--
Groet, Cordialement, Pozdrawiam, Regards,
Kees Nuyt
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
s C, not C++, but it can be called from C++.
Warning: I've never done any of this myself, and I don't know what kind
of API ta-lib offers.
--
Groet, Cordialement, Pozdrawiam, Regards,
Kees Nuyt
___
sqlite-users mailing list
sqlite-users@s
gt;On 6/8/2013 2:51 PM, Dave Wellman wrote:
>> update t1 from (select c1,c2 from t1) as dt1 set c2 = dt1.c2 where
>> t1.c1 = dt1.c2 - 1;
>
>update t1 set c2 = coalesce((select c2 from t1 dt1 where t1.c1 = dt1.c2
>- 1), c2);
--
Groet, Cordialement, Pozdrawiam, Regards,
K
http://sqlite.org/faq.html#q19 helps?
--
Groet, Cordialement, Pozdrawiam, Regards,
Kees Nuyt
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
kingv3.html#how_to_corrupt
3) On some versions of MS Windows, .db is a special extension, which
gets a special treatment and should be avoided.
Some people reported bad performance if that extension is used, which
improves when replaced by something like .sqlite or .etilqs .
--
Groet, Cordialement
> so that should be an easy fix.
Warnings are fixed eventually
( e.g. <http://www.sqlite.org/cgi/src/info/274d2a2266> ),
but with a lower priority than making sure all tests succeed.
>Alex
--
Groet, Cordialement, Pozdrawiam, Regards,
Kees Nuyt
single transaction.
I miss one test case: both journal_mode = off, and all 5764 inserts
within a single transaction.
Give that one a thought (and a try) and you'll understand the
difference.
--
Groet, Cordialement, Pozdrawiam, Regards,
Kees Nuyt
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
ows, for example in
http://unxutils.sourceforge.net/
Note: you need both UnxUtils.zip and UnxUpdates.zip
>Or is there a way I can force sqlite3 to ignore these double quotes?
>
>thanks
>
>gert
--
Groet, Cordialement, Pozdrawiam, Regards,
Kees Nuyt
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
t;My.html
Try:
sqlite3 -help
for more options.
--
Groet, Cordialement, Pozdrawiam, Regards,
Kees Nuyt
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
101 - 200 of 883 matches
Mail list logo
