On Fri, Nov 13, 2015 at 11:15 PM, A. Mannini
wrote:
> Yes I use it in other contests but, as written in another message, in
> need a serverless solutions.
>
A shared filesystem _is_ a network service! Since they have a system
sharing a drive, they can just as easily install MySQL on it and comp
> Why do you think that is a problem? (the x86_64)?
>
Yes there isn't a x64 Jet version. Or at least, there is the ACE x64 but
can't be installed side-by-side to Office 32 bit.
> Other suggests are welcomed?
> Microsoft SQL Server is free (with a limitation of a 4GB database) and it
> probably i
On 2015/11/13 10:52 PM, A. Mannini wrote:
>> Basically the decision is easy - If you require either of:
>> - Network data
>> - User control
>>
>> Then you should use a suited Network DB and not a file-based DB. Best
>> free (without limitations) choices are (In no particular order):
>> - PostGres
On 2015/11/13 9:55 PM, A. Mannini wrote:
> Ok, thanks for all your replies!!!
>
> First, i was asking to understand...before to start development in a
> wrong direction.
>
> I don't have experience with SQLite and even less on a network share. I
> would understand if corruption is a remote possib
Richard Hipp wrote:
> On 11/13/15, Michael McConville wrote:
> > Hi, everyone.
> >
> > I've been auditing the OpenBSD codebase for calls to ctype functions
> > with potentially signed chars. This is undefined on some platforms.
> > I found a number of instances in Sqlite, so I ran my Coccinelle
>
> Basically the decision is easy - If you require either of:
> - Network data
> - User control
>
> Then you should use a suited Network DB and not a file-based DB. Best
> free (without limitations) choices are (In no particular order):
> - PostGres | http://www.postgresql.org/
> - MariaDB / MySQL
On 11/13/15, Michael McConville wrote:
> Hi, everyone.
>
> I've been auditing the OpenBSD codebase for calls to ctype functions
> with potentially signed chars. This is undefined on some platforms. I
> found a number of instances in Sqlite, so I ran my Coccinelle script on
> the repo.
Thank you.
On 13 Nov 2015, at 6:46pm, A. Mannini wrote:
> 1) is there a list of FS where SQLite works fine?
It's not usually the FS which is causing the problem. When your application
tells the OS to write to a remote disk ...
program calls OS API to write to a file
OS calls Network FS on client
On 11/13/2015 08:06 AM, Philip Bennefall wrote:
> Something I forgot in my prior post; I found the delta creation code
> in sqldiff.c so my question really concerns the combined delta code
> found in RBU and sqldiff.c (both creating and applying deltas).
The versions of the delta creation and a
Hi, everyone.
I've been auditing the OpenBSD codebase for calls to ctype functions
with potentially signed chars. This is undefined on some platforms. I
found a number of instances in Sqlite, so I ran my Coccinelle script on
the repo.
The below diff was generated automatically, so formatting may
Ok, thanks for all your replies!!!
First, i was asking to understand...before to start development in a
wrong direction.
I don't have experience with SQLite and even less on a network share. I
would understand if corruption is a remote possibility or a certainty.
Someone said that Access suffer
You said you wanted something that didn't require too much skill to
set up? PostgreSQL seems safer and easier than implementing VFS
yourself. One is **slightly** less error-prone than the other.
On Fri, Nov 13, 2015 at 7:08 PM, Keith Medcalf wrote:
> You realize that the marketing translation of
Il 13/11/2015 19:31, Richard Hipp ha scritto:
> On 11/13/15, A. Mannini wrote:
>> Hi,
>>
>> i read SQLite FAQ and understood that use of SQLite on network share CAN
>> corrupts database file.
>> Fo me, it isn't clear if there is a way to safely use SQLite on a
>> network share in contests with few
Hi,
i read SQLite FAQ and understood that use of SQLite on network share CAN
corrupts database file.
Fo me, it isn't clear if there is a way to safely use SQLite on a
network share in contests with few clients (max 5 for ex) and low read /
write concurrency..
Thanks
Alessandro
On Fri, 13 Nov 2015 18:29:32 +,
A. Mannini wrote:
>
> Hi,
>
> i read SQLite FAQ and understood that use of SQLite on network share CAN
> corrupts database file.
> Fo me, it isn't clear if there is a way to safely use SQLite on a
> network share in contests with few clients (max 5 for ex) and
I think there is a flaw in information passing between the xBestIndex
and xFilter methods in virtual tables.
The information about the constraint operation in the aConstraint array
can't reach xFilter. But how is xFilter to know how to set up the cursor
when a statement like
SELECT * FROM MyTable
On Fri, Nov 13, 2015 at 5:04 PM, Niall O'Reilly wrote:
> People on this mailing list can't do your risk assessment or
> impact analysis for you.
>
> Best regards,
> Niall O'Reilly
>
Seconded.
You asked if there was a way to safely use it. I don't think there is.
You also mentioned "max 5
> > Why do you think that is a problem? (the x86_64)?
> Yes there isn't a x64 Jet version. Or at least, there is the ACE x64 but
> can't be installed side-by-side to Office 32 bit.
Ah, I see. Microsoft introduces artificial restrictions "because they can".
Just like they could have fixed all
Thanks for the clarification, Dan. Might be too picky but perhaps a short note
should be added to the sources verifying this for people as paranoid as myself?
:D
Kind regards,
Philip Bennefall
From: sqlite-users-bounces at mailinglists.sqlite.org [sqlite
On Fri, Nov 13, 2015 at 1:46 PM, A. Mannini
wrote:
> 2) why there are SERVERLESS database (MS Access or VistaDB) that works
> without FS restrictions?
If you think Access works reliably on a network share, you're going to
run in to trouble sooner or later:
https://support.microsoft.com/en-us/kb
> Ok, thanks for all your replies!!!
>
> First, i was asking to understand...before to start development in a
> wrong direction.
>
> I don't have experience with SQLite and even less on a network share. I
> would understand if corruption is a remote possibility or a certainty.
>
> Someone said
On Friday, 13 November, 2015 12:55 A. Mannini
said:
> About VistaDB it support use on network share look at
> http://www.gibraltarsoftware.com/Support/VistaDB/Documentation/WebFrame.ht
> ml#VistaDB_Introduction_SupportedPlatforms.html
> and confirmed from its support. Unfortunately i have not e
On 11/13/15, Quan Yong Zhai wrote:
> SQLite version 3.9.2 2015-11-02 18:31:45
> sqlite> .header on
> sqlite> select 0x1zzz;
> zzz
> 1
> sqlite>
This is parsed as:
SELECT 0x1 AS zzz;
PostgreSQL the same thing (modulo the fact that postgres 7.3 does not
support hexadecimal integer literals).
On 11/13/15, A. Mannini wrote:
> Hi,
>
> i read SQLite FAQ and understood that use of SQLite on network share CAN
> corrupts database file.
> Fo me, it isn't clear if there is a way to safely use SQLite on a
> network share in contests with few clients (max 5 for ex) and low read /
> write concurr
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 11/13/2015 11:55 AM, A. Mannini wrote:
> About VistaDB it support use on network share look at
> http://www.gibraltarsoftware.com/Support/VistaDB/Documentation/WebFram
e.html#VistaDB_Introduction_SupportedPlatforms.html
>
>
and confirmed from its
On Fri, Nov 13, 2015 at 12:55 PM, A. Mannini
wrote:
>
> Ok, thanks for all your replies!!!
>
> First, i was asking to understand...before to start development in a
> wrong direction.
>
> I don't have experience with SQLite and even less on a network share. I
> would understand if corruption is a r
On Nov 12, 2015, at 1:25 PM, Lonnie Abelbeck
wrote:
> When upgrading from SQLite 3.8.9 to 3.9.2 I noticed our binary image grew by
> about 600KB, the culprit was the /usr/bin/sqlite3 shell tool is now
> statically linked instead of dynamically linked as before.
Much thanks to Dan for providi
Hello,
I am upgrading from SQLite 3.8.5 to 3.9.2, using the standard
amalgamation source code (no changes, no conditional defines).
The compiler I am using is Embarcadero C++Builder XE7, which uses a
Clang-based (LLVM) 64-bit compiler.
When building a 32-bit version of my MS-Windows-executable
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 11/13/2015 10:46 AM, A. Mannini wrote:
> 1) is there a list of FS where SQLite works fine?
I don't know of any. Network filesystems are very hard to implement
(so many corner cases), and there is a lot of complexity if you also
want them to be per
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 11/13/2015 10:31 AM, Richard Hipp wrote:
> Just be warned that there are many network filesystems that claim
> to implement locks correctly, and do most of the time, but
> sometimes mess up
It is also worth mentioning that SQLite trusts the filesys
2015-11-12 20:25 GMT+01:00 Lonnie Abelbeck:
> My current solution is to apply this build patch:
> And that seems to restore the previous behavior to dynamically link the
> sqlite3 shell tool.
Actually, Makefile.in is generated from Makefile.am, so the correct patch would
be as below in the S
Something I forgot in my prior post; I found the delta creation code in
sqldiff.c so my question really concerns the combined delta code found
in RBU and sqldiff.c (both creating and applying deltas).
Kind regards,
Philip Bennefall
Hi Richard and others,
I am looking at the RBU extension, and the delta compression
functionality in particular. I am interested in using the delta
compression code (both as part of the RBU extension itself but possibly
also externally by extracting it from RBU). I see that the delta
compressi
op 12-11-2015 17:35 schreef J Decker op d3ck0r at gmail.com:
> On Thu, Nov 12, 2015 at 7:16 AM, E.Pasma wrote:
>> 12 nov 2015, om 07:02, J Decker:
>>
>>> So I've used CTE to solve a simple problem... I'm tempted to use it to
>>> fix more problems... but I'm wondering how to select different value
34 matches
Mail list logo