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
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
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"
On Wed, Oct 10, 2018 at 3:45 PM Warren Young wrote:
> Fossil currently has no restrictions on password length 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
On Tue, Feb 14, 2017 at 1:23 PM, Bart Smissaert
> C:\Program Files (x86)\Microsoft Visual Studio
> qlite-autoconf-317>nmake /f Makefile.msc
You're building from the installation directory?
There's no way to do this
On Feb 4, 2017, at 12:47 PM, Drago, William @ CSG - NARDA-MITEQ
>> -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
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
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)
> 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:
On Sat, Aug 13, 2016 at 8:39 AM, Rousselot, Richard A
> 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
Sorry about that, it was a debug
On Fri, Aug 12, 2016 at 10:06 AM, Rousselot, Richard A
> 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."
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.
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
On Tue, Dec 8, 2015 at 4:30 PM, Bart Smissaert
> 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
On Mon, Nov 16, 2015 at 3:02 AM, Nader Lavasani
> 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.
On Fri, Nov 13, 2015 at 1:46 PM, A. Mannini
> 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:
On Wed, Oct 14, 2015 at 9:55 AM, jose isaias cabrera
> "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 v18.104.22.168 to make the program
> work again. Any thoughts? I thought that
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
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
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
These tests basically map to the /SAFESEH, /DYNAMICBASE, and /NXCOMPAT
linker flags. Though,
On Fri, Jan 16, 2015 at 2:21 PM, James K. Lowden
> 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
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
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)
Assuming the type is nullable, it should do
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
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
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
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
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
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
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
SQLite is a library
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
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
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
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
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
On Fri, Apr 22, 2011 at 8:18 AM, Maurice Marinus
> 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 :
On Feb 13, 2011, at 3:38 PM, BareFeetWare
> 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
On Tue, Dec 21, 2010 at 10:06 AM,
> 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
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
Mail list logo