Funny, I was just doing the same thing.
I have hacked together some Python code to convert the MySQL exports from the
Workbench into SQLite format for import.
It's not pretty, and is a work in progress, but you are welcome to it.
Uncheck everything from the advanced tab and select Dump
@mailinglists.sqlite.org
Subject: Re: [sqlite] CREATE FUNCTION
Rousselot, Richard A wrote:
> This communication is the property of CenturyLink and may contain
> confidential or privileged information.
So, officially, you did not ask anything? Well, then I'm not going to answer.
But it should be men
Are there any plans to add a CREATE FUNCTION function for SQLite? Is this an
SQLite4 type thing?
Something similar PostgreSQL?
https://www.postgresql.org/docs/9.5/static/sql-createfunction.html
This particular class of function is not mentioned in "SQL Features That SQLite
Does Not Implement"
: Wednesday, August 17, 2016 8:05 PM
To: SQLite mailing list
Subject: Re: [sqlite] 64-bit SQLite3.exe
Richard,
On Thu, Aug 18, 2016 at 2:23 AM, Rousselot, Richard A
<richard.a.rousse...@centurylink.com> wrote:
> I was only interested in doing these calculations quickly; that is my
>
-bit vs 64-bit.
Richard
-Original Message-
From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On
Behalf Of Simon Slavin
Sent: Wednesday, August 17, 2016 11:09 AM
To: SQLite mailing list
Subject: Re: [sqlite] 64-bit SQLite3.exe
On 17 Aug 2016, at 4:54pm, Rousselot
spinning HDD. There is a slight improvemnt (~5%
faster) going to SSD but wanted to stay consistent.
I don't plan on testing Cygwin, I am happy with the MinGW results.
Thanks everyone for your help.
Richard
-Original Message-
From: Rousselot, Richard A
Sent: Monday, August 15, 2016 12
Correction on description:
Test 2: 32-bit 3.13 (sqlite.org), with PRAGMA but not temp_store = 2;
-Original Message-
From: Rousselot, Richard A
Sent: Monday, August 15, 2016 12:20 PM
To: sqlite-users@mailinglists.sqlite.org
Cc: Rousselot, Richard A
Subject: Re: [sqlite] 64-bit SQLite3.exe
Speed improvements based on 64-bit Visual Studio build.
SQLite 3.14.0, built with MSVC 18.00.30723 for x64.
Built with VS options /O2 /Ot /Ox.
Built with SQLITE options of SQLITE_ENABLE_FTS3 SQLITE_ENABLE_STAT2
SQLITE_ENABLE_RTREE.
Module SQL Script (146k records)T1 Sec T2 Sec T3 Sec
, 2016 at 8:39 AM, Rousselot, Richard A
<richard.a.rousse...@centurylink.com> 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 debu
, Richard A
Sent: Saturday, August 13, 2016 10:40 AM
To: SQLite mailing list
Cc: Rousselot, Richard A
Subject: RE: [sqlite] 64-bit SQLite3.exe
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
To: SQLite mailing list
Subject: Re: [sqlite] 64-bit SQLite3.exe
On Fri, Aug 12, 2016 at 10:06 AM, Rousselot, Richard A
<richard.a.rousse...@centurylink.com> wrote:
> I, and others, have tried to compile this as a 64-bit library but it will not
> load from the command line (using .loa
Update to my 64-bit saga.
I was able to work with some helpful mailing list members to create a 64-bit
SQLite3.exe. Far as I can tell it works fine but unfortunately I also use the
math extension library (extensions-functions.c) in my CTE queries which is also
32-bit.
I, and others, have
First of all thanks for the discussion. Special thanks out to DD. ;)
I will just summarize my main view.
* CTEs can easily exceed memory limits of the 32-bit SQLite3.exe. So I have a
valid need and am not on a crusade to kill 32-bits. Telling me that other
people don't have my problems is
, August 10, 2016 12:09 AM
To: SQLite mailing list
Subject: Re: [sqlite] 64-bit SQLite3.exe
> On 10/08/2016, at 3:30 PM, Rousselot, Richard A
> <richard.a.rousse...@centurylink.com> wrote:
>
> As I said, I am not a software engineer. I could spend a few hours figuring
>
>On Aug 9, 2016, at 9:30 PM, Rousselot, Richard A
><richard.a.rousse...@centurylink.com> wrote:
>
>> I could spend a few hours figuring this out and be fine but it will be
>> painful for me.
>
>Or you can spend many hours waiting for someone to build it for you.
Rousselot, Richard A <
richard.a.rousse...@centurylink.com> wrote:
> I would like to request a SQLite official 64-bit SQLite3.exe CLI (not
> DLL) be created.
>
> I have reviewed the prior discussions regarding 64-bit SQLite3 and the
> reasoning for which why creating a 64-
I would like to request a SQLite official 64-bit SQLite3.exe CLI (not DLL) be
created.
I have reviewed the prior discussions regarding 64-bit SQLite3 and the
reasoning for which why creating a 64-bit version is denied are "it does not
make a real difference", "you can just use ram disks",
Any way we could have the mailing list strip tabs from the subject lines? I
have been getting very odd subject formatting lately.
Ex.
Re: [sqlite] How to use sqlite3_blob_open when the blobcolumn is
empty?
Re: [sqlite] Are BLOB stored inline with the rest of the
What no love for their own Access DB?
Congrats!
-Original Message-
From: sqlite-users-bounces at mailinglists.sqlite.org
[mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Stephen
Chrzanowski
Sent: Tuesday, November 10, 2015 2:19 PM
To: SQLite mailing list
Subject:
...@mailinglists.sqlite.org] On Behalf Of Scott Hess
Sent: Friday, October 23, 2015 10:05 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Simple Math Question
On Fri, Oct 23, 2015 at 7:39 AM, Dominique Devienne
wrote:
> On Fri, Oct 23, 2015 at 4:16 PM, Rousselot, Rich
|no
-Original Message-
From: sqlite-users-bounces at mailinglists.sqlite.org
[mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Dominique
Devienne
Sent: Friday, October 23, 2015 8:54 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Sim
not produce something like 25.03 or 22.999? Shouldn't
the result have all significant digits showing? I guess that is why these
results seem misleading.
Richard
From: Rousselot, Richard A
Sent: Thursday, October 22, 2015 2:45 PM
To: 'sqlite-users at mailinglists.sqlite.org'
Cc
: [sqlite] Simple Math Question
On Thu, Oct 22, 2015 at 9:45 PM, Rousselot, Richard A < Richard.A.Rousselot at
centurylink.com> wrote:
> Doing the following math, why is it that the results are not all
> returning "yes"?
>
> SELECT
> (9.2+7.9+0+4.0+2
Doing the following math, why is it that the results are not all returning
"yes"?
SELECT
(9.2+7.9+0+4.0+2.6+1.3),
case when (9.2+7.9+0+4.0+2.6+1.3)=25.0 then "yes" else "no" end,
(9.2+7.8+0+3.0+1.3+1.7),
case when
What is the equivalent SQLite syntax for the Oracle SQL syntax below?
row_number() OVER (PARTITION BY x ORDER BY y DESC, z) AS aField
Example...
SELECT department_id, first_name, last_name, salary
FROM
(
SELECT
department_id, first_name, last_name, salary,
I have noticed that SQLite Query Browser is running slower than other IDEs,
including SQLitespeed, for some reason. Even when each IDE is set to using
similar versions of the SQLite3.dll. We had a recursive query in SQB take 6
min, on other IDEs it would be less than 2 min.
My $0.02
Are all your customers on the latest version of iOS? Maybe you need to make
your app only compatible with current versions that behave properly? What
version of iOS and model is the customer that has the issue running?
Regards,
A fly on the wall...
-Original Message-
From:
How slow is too slow?
-Original Message-
From: sqlite-users-bounces at mailinglists.sqlite.org
[mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of James Qian
Wang
Sent: Thursday, July 30, 2015 5:13 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Query
28 matches
Mail list logo