A pysqlite user reported a problem with COALESCE. I could find out
that his test case worked ok with SQLite versions 3.6.12 through
3.6.20, but failed with 3.6.21 to 3.6.23.
I could narrow down his test case to this very simple one below. The
combination of addition, named parameters and COALESCE
Gerhard Häring wrote:
> I need to know if SQLite works at all if the platform doesn't have a
> 64-bit integer type.
>
> I see that SQLite has some #ifdefing like
>
> #ifdef SQLITE_INT64_TYPE
>
> that seems to be for the case when the platform does not have the type
>
I need to know if SQLite works at all if the platform doesn't have a
64-bit integer type.
I see that SQLite has some #ifdefing like
#ifdef SQLITE_INT64_TYPE
that seems to be for the case when the platform does not have the type
natively, but I don't see where this would actually be
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
paulito santana wrote:
> Create a account in database for login ! Like you make in ORACLE, MySQL :
>
> CREATE USER mike
There are no such things as users or logins in SQLite. It's an embedded
database. If you want to implement a permission
Eino Mäkitalo wrote:
I am playing with zodb storages and there is some kind of 2pc support. I
dont know if I really need it
to implement my storage (for fun) zodb over sqlite but at least I was
thinking possibility to not make those temporary changes programmatic
way but to use sqlite
Clinco, Michele wrote:
[...] the ADO.Net driver available in MONO is
working fine, so I'm thinking about a migration.
The only problem is that I could not find the source code in the
mono-project site and I was not able to find, between the different
mirrors available in internet, the
Lenster wrote:
I am investigating which would be the most appropriate RDMS to use for
a new Intranet based application. I have rounded down my choice to two
candidates - SQLite and MySQL.
Ok. I think that PostgreSQL and Firebird are almost always better
choices than MySQL for a database
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Jose Da Silva wrote:
> Hi sqlite list,
> By default, linux gcc does not appear to remove information and
> therefore final binaries tend to be larger than they need to be if you
> use stable versions of compiled binaries. [...]
> If the sqlite
Jiao wrote:
I've build sqlite in x86, its size stripped is 318244bytes, Can it
cut even smaller, I noticed some documents said it can be more
smaller, how to cut down?
See http://www.sqlite.org/compile.html
-- Gerhard
Marian Olteanu wrote:
Is there a way in SQLite to use real prepared statements? Statements
with variables, that you fill after you compile the query and reuse then
reuse? [...]
SQLite 3 introduced prepared statements.
Read http://www.sqlite.org/capi3.html for enlightenment.
-- Gerhard
[EMAIL PROTECTED] wrote:
"Dan Petitt" <[EMAIL PROTECTED]> wrote:
I think (looking at the source) that it's a pragma, but I don't know when
you set it, once when DB is opened, on each write or on each read.
You are the third to ask (including me), maybe Richard or someone else can
through some
Nilo Paim wrote:
My point is: if I use another sql engine that is written in Java then I
just inverted the problem: how to access the databases without writing a
bridge in native code that allows me to access the database from C or
C++ or... ?
Use a database server with client interfaces
Matt Wilson wrote:
Hi. I've been working on some refactoring of the Python bindings for
sqlite. I now have a working Python binding for sqlite 3 which is
fairly different than the bindings for sqlite 2. [...]
I've been doing development in our Conary CVS repository. You can
browse the
Good suggestions, IMO, Peter.
I normally really hate this, but you could try to mangle the email
adresses they look for with some JavaScript gimmicks using document.write.
OTOH this sucks big time, because it will make the site harder to use
for those who surf with JavaScript disabled or
D. Richard Hipp wrote:
In the past couple of days, I've been having problems with
spiders [...]
You could use a robots.txt to guard against those spiders that behave
well. If the misbehaving spiders use a certain distinguishable
User-Agent header, you could block that.
-- Gerhard
[EMAIL PROTECTED] wrote:
[DQL statements ("SELECT ...") lock the whole database when using PySQLite.]
Hi,
I've thought about this whole issue and made a few changes to my local
working copy of PySQLite over the weekend, which will go into the next
release (during the next days):
The most
Bert Verhees wrote:
It would be nice if people would stop sending their emails twice to this
list, and also would put off their read or deliver notification
And learn to quote. And not top-post.
-- Gerhard
-
To unsubscribe,
[EMAIL PROTECTED] wrote:
Hi all,
I'm trying SQLite with Zope
You're using PySQLite, right?
and it works fine, but when I use the browser's
[Stop] button to interrupt the request it gives me the message:
"database is locked" [...]
This happens when you have a connection that is within a
Noel, "epankoke" and rest:
Would you people please learn to quote when using mailing lists? There's
no need to quote everything, just the parts you're referring to in your
answer.
The signal-to-noise ratio in this group is quite bad :-/
-- Gerhard
Lindsay Mathieson wrote:
[...] there is no general agreement on this subject except for
long std practice, which is to use reply-to
"Long standing practice" in the mailing lists I'm subscribed to (among
which are [EMAIL PROTECTED], several FreeBSD and Debian ones) is to
*not* do reply-to
Paul Smith wrote:
At 16:20 16/10/2003, Kevin Waterson wrote:
Seems to work fine :)
Hmm, almost.
If I just do a 'reply', then it goes to the message sender, rather than
back to the list. [...]
Yes. Please leave it that way. Explicit reply-to rewriting would get us
out-of-office & "virus" warning
21 matches
Mail list logo