[sqlite] memsubsys1-8.4...Assertion failed: (EIGHT_BYTE_ALIGNMENT(p)) with --enable-debug

Hello. I'm found next error in tests memsubsys1-8.3... Ok memsubsys1-8.4...Assertion failed: (EIGHT_BYTE_ALIGNMENT(p)), function sqlite3Malloc, file sqlite3.c, line 18891. *** [test] Signal 6 when compiling sqlite with options CONFIGURE_ARGS+=--enable-debug CPPFLAGS+= -Wall

Re: [sqlite] Using SQLite on a networkshare

It boils down to that SQLite is working as intended as it can only rely on what the OS feeds it. As stated, the developers of SQLite are not going to be looking at network sharing as the responsibility of file locking is on the OS, not SQLite. Network sharing is tricky, and it "seems" seamless

Re: [sqlite] Don't passes next tests on FreeBSD: atof1-*

Hello. On a 64 bit system, all the tests running are successful. log compilation https://docs.google.com/file/d/0Bz0ZXsXvwY_gc09EeWk1VEktRVk/edit log testing https://docs.google.com/file/d/0Bz0ZXsXvwY_geDlIRWlUSTZTMFE/edit My operating system: FreeBSD fb2.localhost 9.1-PRERELEASE FreeBSD

Re: [sqlite] sqlite version of android 4.0.3

thank you using emulator, after adb shell login, sqlite3 command was displayed that's version. 2013/01/10 10:53、Yongil Jang のメッセージ: > ~Android gingerbread: 3.6.22 > Honeycomb~ICS: 3.7.4 > Jellybean~:3.7.11 > On Jan 10, 2013 9:23 AM, "sqlitekyounoii"

Re: [sqlite] Problem whit sqlite_prepare_v2() in 3.7.5 version andlater

On 1/11/2013 5:34 AM, a...@zator.com wrote: Problem (partially) solved: Using MS Windows 8; MS Visual Studio 2012 for desktop, and SQLite 3.7.15.1 I get consistently the following behavior for the application: Running in Debug-mode, fails as reported in the OP. Running in Release-mode

Re: [sqlite] convert a .sql file to a .db file

On 11 Jan 2013, at 11:52am, kevnm67 wrote: > I'm new to sql and having trouble figuring out how can I convert my .sql > file to a .db file? Use a SQLite tool to dump to .csv format, then use a DB tool to import the .csv to DB format. Since this is a SQLite list, we can

Re: [sqlite] How to decrease IO usage

On 10 Jan 2013, at 2:42pm, Bebel wrote: > I include all the operation made by my action (so open/close are included). > > I create one base per user, so I prefer not to merge database to make one > bigger. Okay. This means that your enquiry is not the standard one of

[sqlite] convert a .sql file to a .db file

Hey everyone! I'm new to sql and having trouble figuring out how can I convert my .sql file to a .db file? I originally had the database made by someone who ran a python script on my .csv file and parsed the info into a .db file. Running this script has been inconsistent for me - yesterday AM it

Re: [sqlite] How to decrease IO usage

Hi Simon, I include all the operation made by my action (so open/close are included). I create one base per user, so I prefer not to merge database to make one bigger. Thanks for your help. -- View this message in context:

Re: [sqlite] How to decrease IO usage

Hi Igor, Well it's a interesting solution, and I already explored this possibility. Now, it will be too expansive and complicated for us to migrate data from sqlite to nosql solution. We choose sqlite about 5 years ago, when nosql was not an industrial solution. Sqlite was the best choice. Now

Re: [sqlite] How to decrease IO usage

Hi Michael, Thanks for your feed back, but as far as I understand the pragma cache size, it's only increase the cache size during the session. But the cache is deleted when the database is close. In my case, I only make short transaction on the database, like open, read and immediately close. I

Re: [sqlite] showwal.c to find WAL file differences? (trying to analyze some lost commits)

On 11 Jan 2013, at 11:01am, Clemens Ladisch wrote: > Simon Slavin wrote: >> I looked into ways of checking that the file was being accessed locally >> rather than on a network share and totally failed. There didn't seem >> to be any way of doing this under Windows which

Re: [sqlite] showwal.c to find WAL file differences? (trying to analyze some lost commits)

Simon Slavin wrote: > I looked into ways of checking that the file was being accessed locally > rather than on a network share and totally failed. There didn't seem > to be any way of doing this under Windows which worked all the time. So GetDriveType didn't work?

Re: [sqlite] Problem whit sqlite_prepare_v2() in 3.7.5 version andlater

Problem (partially) solved: Using MS Windows 8; MS Visual Studio 2012 for desktop, and SQLite 3.7.15.1 I get consistently the following behavior for the application: Running in Debug-mode, fails as reported in the OP. Running in Release-mode (without debugging), fails as reported. Starting