Re: [sqlite] sqlite3 tool bug

On Fri, Jan 16, 2015 at 2:02 PM, Dave Dyer wrote: > the input side of the pipe. Perhaps there is some windows conditioning > that ought to be done by sqlite, on STDIN, to make it into a binary data > source ? You should be able to do a freopen(NULL, "rb", stdin); to

Re: [sqlite] sqlite3 shell in windows

On Fri, Jan 16, 2015 at 2:21 PM, James K. Lowden wrote: > 5. The 32-bit windows sqlite3 shell supports extensions? Yes, it does. The version on sqlite.org is compiled with that support. > 6. The above messages come from the OS, and result from LoadLibrary > failing?

[sqlite] Windows 8.x security requirements / SafeSEHCheck - NXCheck - DBCheck

On Thu, Apr 2, 2015 at 10:58 AM, wrote: > > This are basically compiler switches as far as I understand. > > I am not a C programmer, so also quite difficult for me to link the library > statically. These tests basically map to the /SAFESEH, /DYNAMICBASE, and /NXCOMPAT linker flags. Though,

[sqlite] SQLite database becomes corrupt on iOS

On Fri, Aug 14, 2015 at 8:38 AM, Simon Slavin wrote: > I have seen a problem like this only in one context, and it had nothing to do > with SQLite. When an iDevice's power starts running low, it sends out > notifications to all running Apps and expects their cooperation in shutting > down.

[sqlite] How to see SQLite debugging information

On Tue, Dec 8, 2015 at 4:30 PM, Bart Smissaert wrote: > So, what/where is that standard output channel? > This is on a Win7 machine. How do I bring up that console window? > There is no development environment here. I am running this from Excel. > So, I have a standard Windows sqlite3.dll, a

[sqlite] How to see SQLite debugging information

On Wed, Dec 9, 2015 at 10:14 AM, Adam Devita wrote: > To run MS-excell from the command line, you can call it from the full > path (check version): > > "C:\Program Files\Microsoft Office\Office15\Excel.exe" You can also run "start excel" to launch the current version of Excel. Both of these are

[sqlite] REGEXP pcre DLL for Windows

On Mon, May 18, 2015 at 9:43 AM, sonypsx wrote: > may i kindly ask again about REGEX pcre DLL for Windows? > > Do someone have an idea or even a precompiled DLL which works under sqlite? As you've found, you don't just need a pcre dll for windows, you need a sqlite3 module to implement the

Re: [sqlite] Preferred cast in C#

Could you not do something like this to handle the nullable types? T GetValue(string field) { object obj = reader[field]; if (obj is System.DBNull) return default(T); else return (T)obj; } Assuming the type is nullable, it should do

Re: [sqlite] Automating the build of a sqlite database

On Fri, Apr 22, 2011 at 8:18 AM, Maurice Marinus wrote: > On a windows platform I have the following: > schema.sql (contains the sql scripts) > sqlite3.exe (command shell for sqlite -> downloaded from sqlite.org) > build.bat : A batch file containing the line :

Re: [sqlite] Critical issue

On Wed, Jun 22, 2011 at 10:57 AM, Cyrille wrote: > As you said, I have been surprised by the result. One of my users copied > the missing DLL indicated by Depends (IEShims.dll) to the application > folder and Depends indicates now another missing DLL: ieframe.dll which > seems

Re: [sqlite] Critical issue

On Wed, Jun 22, 2011 at 1:11 PM, Cyrille wrote: > I confirm also that my project was set to "anycpu". If I change the > setting to "x86", is the VS 2010 C++ Redistributable package still > necessary? Yes. ___ sqlite-users mailing

Re: [sqlite] Critical issue

On Wed, Jun 22, 2011 at 10:48 PM, Cyrille wrote: >> Alternatively, you could recompile SQLite.Interop.dll to use the >> static CRT library (/MT). > Could you please let me know how to proceed to do this? Download the source from

Re: [sqlite] Critical issue

On Thu, Jun 23, 2011 at 9:27 AM, Cyrille wrote: > Thank you for these guidelines. Unfortunately, it seems that Visual > Studio is necessary and I just have the Express version. Do you confirm > that with the Express version, rebuilding is not possible? Sorry, I'd think Visual

[sqlite] [AGAIN] SQLite on network share

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:

[sqlite] Sqlite fd problem!

On Mon, Nov 16, 2015 at 3:02 AM, Nader Lavasani wrote: > Bug? or my silly mistake?! >From the documentation for sqlite3_prepare_v2: "The calling procedure is responsible for deleting the compiled SQL statement using sqlite3_finalize() after it has finished with it." You're not doing this.

[sqlite] Problems with v3.9.0: entry point sqlite3_finalize could not be located

On Wed, Oct 14, 2015 at 9:55 AM, jose isaias cabrera wrote: > "The procedure entry point sqlite3_finalize could not be located in the > dynamic link library SQLITE3.DLL." > > and the program aborts. I had to go back to v3.8.11.1 to make the program > work again. Any thoughts? I thought that

[sqlite] IS a SQLite db of small size as good as reliable cache?

On Wed, Feb 3, 2016 at 3:53 PM, Howard Chu wrote: > No. Windows will toss clean pages out even in the total absence of memory > pressure. It is moronic, but true. You can repeat the steps I outlined for > yourself and see. > >

Re: [sqlite] SQLite and Windows 95

On Tue, Dec 21, 2010 at 10:06 AM, wrote: > I wonder about something : those functions are in kernel32.dll on a XP > computer. Is it possible (I never do that before), to take the file > "kernel32.dll" on my XP computer, to put it on the Win95 computer in the

Re: [sqlite] Speed up count(distinct col)

On Feb 13, 2011, at 3:38 PM, BareFeetWare wrote: > On 13/02/2011, at 1:04 AM, Yuzem wrote: > >> I am grabbing the data from the each movie imdb webpage. > > Does IMDB allow use of their data this way? After my brief reading of their > site, I thought they charge a

Re: [sqlite] SQLite on 64-bit Windows O/S

On Tue, Mar 16, 2010 at 6:21 PM, Rashed Iqbal wrote: > Has anyone compiled and used SQLite on 64-bit Windows? Are there any > code changes that would be needed before compiling? Would the same DB > file work on 32-bit and 64-bit Windows platforms? I routinely run SQLite on

Re: [sqlite] Windows-Specific 2-c-files Amalgamation?

On Wed, Mar 13, 2013 at 1:14 PM, Dominique Devienne wrote: > On Mon, Mar 11, 2013 at 5:21 PM, Bert Huijben wrote: >> Since Visual C++ 2005 the limit in PDB files was increased to 24 bit. You >> might still get a warning for compatibility with older tools, but

Re: [sqlite] Programming API vs console

On Tue, Apr 23, 2013 at 8:47 PM, Igor Korot wrote: > query = wxString::Format(...); > if( ( result = sqlite3_prepare_v2( m_handle, query, -1, , 0 ) ) != > SQLITE_OK ) > It's been a while since I've worked with wxWidgets, but when I did, wxString didn't support an implicit

Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5

On Thu, Feb 9, 2012 at 9:57 AM, Tim Leland wrote: > Ok so what would be the process of compiling the c#? Ive never done anything > like that before. Unless you have a need for the C# library, you should skip it. Just bring in the C source file and header from the

Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5

On Thu, Feb 9, 2012 at 10:07 AM, Tim Leland wrote: > What software would I need to compile? Persumably whatever software you're using to compile the rest of your application. Visual Studio is the common way to compile Windows Mobile applications. SQLite is a library

Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5

On Thu, Feb 9, 2012 at 10:17 AM, Tim Leland wrote: > Ok now I understand. I need the shell for windows mobile. The reason why im > doing this is the application running on windows mobile is really just an > html5 browser storing data in a sqlite database. I need to

Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5

On Thu, Feb 9, 2012 at 2:34 PM, Tim Leland wrote: > I can use CE if that's the problem. Can someone get sqlite3.exe shell to run > on windows CE? I'm sure someone can, but they'll need to know which architecture you're running on, and possibly what CE components are in

Re: [sqlite] FW: Problem with SQLite when deployed.

On Fri, May 25, 2012 at 9:40 AM, Pavel Ivanov wrote: > Except that 64-bit executable cannot load 32-bit DLL and vice versa. > I'm not sure how this rule is applied to managed executables and DLLs > loading unmanaged DLLs. On a 64-bit machine managed executables run as 64-bit

Re: [sqlite] I consider this a bug. Anyone else?

On Tue, Jun 26, 2012 at 8:55 AM, wrote: > I do realize and appreciate the public domain source is available. My best > option is recompiling the DLL but since the project and make files aren't > designed for Visual Studio it will require time that like everyone her I > cherish.

Re: [sqlite] 64-bit SQLite3.exe

On Fri, Aug 12, 2016 at 10:06 AM, Rousselot, Richard A wrote: > I, and others, have tried to compile this as a 64-bit library but it will not > load from the command line (using .load) and gives the "Error: The specified > module could not be found." > >

Re: [sqlite] 64-bit SQLite3.exe

On Sat, Aug 13, 2016 at 8:39 AM, Rousselot, Richard A wrote: > Thanks, this does allow the library to load and process. The thing is your > build is by far the slowest I have received, slower even than the 32-bit > version. Sorry about that, it was a debug

Re: [sqlite] 64-bit SQLite3.exe

.org] On > Behalf Of Random Coder > Sent: Saturday, August 13, 2016 12:17 PM > To: SQLite mailing list > Subject: Re: [sqlite] 64-bit SQLite3.exe > > On Sat, Aug 13, 2016 at 8:39 AM, Rousselot, Richard A > <richard.a.rousse...@centurylink.com> wrote: >> Than

Re: [sqlite] SQLite3 Pros / Cons

On Feb 4, 2017, at 12:47 PM, Drago, William @ CSG - NARDA-MITEQ wrote: >> -Original Message- >> From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On >> Behalf Of Clyde Eisenbeis >> Sent: Saturday, February 04, 2017 2:58 PM >> To: SQLite

Re: [sqlite] Problem compiling 3.17.0 in MSVS 12

On Tue, Feb 14, 2017 at 1:23 PM, Bart Smissaert wrote: > C:\Program Files (x86)\Microsoft Visual Studio > 12.0\VC\vcprojects\Win32\SQLite\s > qlite-autoconf-317>nmake /f Makefile.msc What?! You're building from the installation directory? There's no way to do this

Re: [sqlite] Problem with compiled dll on Windows

On Wed, Jan 11, 2017 at 10:28 AM, Rael Bauer wrote: > 1) Should the howtocompile.html webpage not include this in the "Building A > Windows DLL" instructions? Tough question. Normally, I'd say this is toolset knowledge, and really doesn't belong in those sort of

Re: [sqlite] Problem with compiled dll on Windows

On Wed, Jan 11, 2017 at 2:11 AM, Rael Bauer wrote: > I am trying to compile the latest amalgamation (3160200) as a dll on Windows > 10 x64, using VS2015 x86 Native Tools Command Prompt. The dll compiles fine, > however trying to use this dll in various tools (Delphi)

Re: [sqlite] SQLite mailing list [was: SQLite Windows GUI alternative to Excel?]

On Wed, Oct 10, 2018 at 3:45 PM Warren Young wrote: > Fossil currently has no restrictions on password length[1] or content. The > input text is simply salted, hashed, and inserted into the user table: > [...] > The salt is the project code combined with the user ID, not a secret per-user >

Re: [sqlite] Problems loading extensions on Windows 10

On Tue, Mar 5, 2019 at 2:30 PM Kyle wrote: > I have downloaded both sqlite3 and mod_spatialite.dll (the extension) and > copied them to C:\Windows\System32. > > When I run > SELECT load_extension('mod_spatialite') > sqlite returns "Error: the specified module could not be found" Helpfully,

[sqlite] Tracking item history using SQLite

First off, if this sort of "code review" style question is inappropriate for this list, please feel free to reply to me directly and tell me to stop, and I'll know to not do this again. That said, I have a question on the use of SQLite. At the risk of falling into the XY problem, I'll give some

Re: [sqlite] Tracking item history using SQLite

On Fri, Aug 30, 2019 at 3:35 PM Keith Medcalf wrote: > Seems fine, other than that event.first_seen and event.last_seen can be NULL, > in which case that field will never be updated. So while you may claim that > you never store NULL in those fields, doing so will cause non-workage due to >