rd in advance from sqlite3_step.
>
What do you mean by "last record"?
--
Chris Green
·
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
* Start of column names in pragCName[] */
u8 nPragCName; /* Num of col names. 0 means use pragma name */
u64 iArg; /* Extra argument */
} PragmaName;
Thank you,
Richard Green
___
sqlite-users mailing list
sq
On Tue, Dec 18, 2018 at 4:00 PM Peter da Silva wrote:
> On Tue, Dec 18, 2018 at 3:49 PM Nathan Green wrote:
>
> > Except the problem isn't just in Chrome. Apparently, any system that
> allows
> > SQL injection is vulnerable.
> >
>
> That's kind of a t
On Tue, Dec 18, 2018 at 3:14 PM Simon Slavin wrote:
> On 18 Dec 2018, at 9:00pm, Peter da Silva wrote:
>
> > I have to say I'm pretty boggled that Chrome allows hostile users to
> feed code directly into an SQL interpreter that wasn't written from the
> ground up to be secure.
>
> Chrome has pro
On Tue, Dec 4, 2018 at 11:25 AM Digital Dog wrote:
> On Tue, Dec 4, 2018 at 5:57 PM Richard Hipp wrote:
> >
> > On 12/4/18, Digital Dog wrote:
> > >
> > > I vote for GENERATE_SERIES to be included in official sqlite3 binary
> and
> > > libraries.
> >
> > We are under pressure to keep SQLite as
My typical use case is trying to determine how many rows I just wrote out
to a file. Window functions are no help because they alter the output
format, which is usually undesirable. It's sort of absurd to run `wc -l`
over the newest 25MiB file in my system to get an answer that's probably
already i
Hi,
According to the online documentation (https://www.sqlite.org/series.html),
generate_series is compiled into the command line shell. As it turns out,
this is not so. It is not even an option in the build system from what I
can tell. It would be nice to at least have a build flag to enable it.
Darren Duncan wrote:
> On 2018-10-10 10:51 AM, Chris Green wrote:
> > Warren Young wrote:
> >> Fossil forum email alerts include the full content of the message.
>
> That's great! Especially if the alert email subject includes the forum
> thread
> sub
ave to go and get them
> >>
> >> So do Fossil email alerts.
> >
> > So there's an unecessary email I've just received telling me to go to the
> > forum.
>
> Fossil forum email alerts include the full content of the message.
And
Gary R. Schmidt wrote:
> On 10/10/2018 22:20, Petite Abeille wrote:
> >
> [SNIP]
> > ( Also, fwiw: please keep the mailing list, it's perfectly functional as
> > is. )
> >
> Seconded.
>
> It isn't broken, so please don
the locale setting
to give them to you in your own language.
--
Chris Green
·
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
x wrote:
> Don’t think you’ll get it any less ugly than
>
> substr('SunMonTueWedThuFriSat',strftime('%w',Date)*3+1,3);
>
Yes, thanks, that's where I had got to! :-)
--
Chris Green
·
___
s
I want to get Sun, Mon, Tue, Wed etc. from a date, what's the easiest
way of doing this in a sqlite select?
I guess I can do something (horrible?) with the numeric day of week
and substr() but is there not an easier way?
--
Chris Green
·
___
s
command after table name in changeset because there is
nothing to update...
I have simple workaround in SQLDiff for this situation if you want.
--
Regards
Green
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqli
I have had this problem. Essentially, precompiled binaries (SQLite3.dll,
and System.Data.Sqlite) for Windows do not appear to allow extension
loading using the SQL function.
I have raised this before,
http://sqlite.1065341.n5.nabble.com/Extension-Loading-td93885.html but it
may need custom compilin
Jacob Sylvia wrote:
> I know what the problem was... bash was interpreting the `table_name` piece
> as a command. I had to escape the backticks...
>
Yes, `command` is the old-fashioned way of saying $(command) in bash.
--
Chris Green
·
_
I have attempted to compile 3.17.0 in MSVS using the 32 bit native command
line
No editing of sources was done
I have tried the amalgamation download with
cl sqlite3.c -link -dll -out:sqlite3.dll
and sqlite-autoconf-317.tar.gz with
nmake /f makefile.msc
In both cases the dll was produced wi
>You could create a user-defined function to call LoadExtension(), but
>why do you need to do this from SQL?
A good question, but I am attempting to use a different .Net wrapper for
this project which has not imported sqlite3_enable_load_extension().
The simplest thing would be to import the funct
Hi
I'm using System.Data.SQLite Nuget package and attempting to load an
extension.
All depenent libraries are in the bin\debug output directory.
Extension is 32 bit and the project is set to compile for 32 bit
Using
conn.EnableExtensions(true);(I think this is enabled by default)
conn.LoadEx
Is it possible to force the creation of an automatic covering index for a
subquery?
Like, 'cross join' can force the join order, 'indexed by' can force index
use on a table, but it doesn't seem like there's anything to force the
creation of an automatic index.
The reason that I ask is that one of
desktop?
Thanks
Duncan
From: Green Fields [mailto:defn...@gmail.com]
Sent: Sunday, 18 January 2015 3:46 PM
To: 'sqlite-users@sqlite.org'
Subject: System.Data.SQLite for Pocket PC & RTREE
Hi
I hope this message doesn't double up but the last one did not appear
Hi
I hope this message doesn't double up but the last one did not appear to
make it.
I'm new to the list and newish to SQLite and would appreciate some tips.
I'm attempting to create an application that requires a spatial rtree query,
and this works extremely well using the x86 version of the
Hi
I'm new to the list and newish to SQLite and would appreciate some tips.
I'm attempting to create an application that requires a spatial rtree query,
and this works extremely well using the x86 version of the
System.Data.SQLite library
(sqlite-netFx40-static-binary-bundle-Win32-2010-1.0.94.
> Thanks guys, I have already tried WAL and it does speed things up, but I
> still need the daily processing to be done asynchronously. The computations
> are complex, involving around 16 inputs from the player table and resulting
> in 8 outputs. This is core to the game and not a simple score
On Tue, Jan 17, 2012 at 06:21:48PM +0100, noel.frankinet wrote:
> Le 17/01/2012 18:15, Chris Green a écrit :
>
> Hello Chris,
>
> You should look at Dojo javascript library, I think they have the
> widget you are looking for. Of course you still need the back-end
> pl
t doesn't edit in situ. To edit a
row you have to click on the row and then move up to the row at the top
and change the values there. ... and *then* you have to click on the
Update Table button to put the values back into the table.
> On Tue, Jan 17, 2012 at 8:05 AM, Chris Green w
n a grid and allows
me to edit. I don't want to have to navigate through menus and options
to get there.
Any ideas or suggestions would be very welcome.
--
Chris Green
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
OK, I think I misread that !
I was reading the navigation to SQLite.Net\bin\Designer as being a
*workround* for the temporary absence of the design time installer, but
on second glance I conclude that it is only describing how to do
something that is not yet implemented.
So, what should I do i
I'm a new user trying *sqlite-dotnet-x86-1007300.exe* at
http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki
According to SQLite.NET Class Library Documentation bundled with the
download and the section "*Installing SQLite Visual Studio Design-Time
Support*" I should begin by
ong # of entries in index IXED_EventDetails
wrong # of entries in index sqlite_autoindex_EventDetails_1
The wrongly-located data was still present afterwards. EventDetails was not
involved in this mis-placed data issue.
James
On 12 April 2011 15:01, James Green wrote:
> Incidentally running prag
On 13 April 2011 15:33, Simon Slavin wrote:
>
> On 13 Apr 2011, at 12:14pm, James Green wrote:
>
>> sync=full does not work well for our app (no transactions). Far too slow.
>
> If you're not syncing, then section 3.2 of the page Richard probably
> indicates w
ansactions). Far too slow.
James
On 13 April 2011 11:47, Richard Hipp wrote:
> On Tue, Apr 12, 2011 at 5:15 AM, James Green wrote:
>
>> My question is does anyone have pointers
>> to help us isolate the problems we are seeing.
>>
>
> http://www.sqlite.org/howtocorru
Another follow-up in the hope someone can shed light on the situation
or ask for further specific testing.
I am told the only thing we change from the default settings is that
synchronous=0. Apparently full mode was far too slow. Reading the
documentation it clearly states that there are limited c
Incidentally running pragma integrity_check on one of the samples I
have been given returns:
*** in database main ***
On tree page 1824 cell 0: invalid page number 218103808
On page 73608 at right child: 2nd reference to page 92497
Page 92110 is never used
Page 92494 is never used
Page 92496 is ne
On 12 April 2011 11:27, Simon Slavin wrote:
>
> On 12 Apr 2011, at 10:15am, James Green wrote:
[ ... ]
> Was it built threadsafe ? See
>
> http://www.sqlite.org/threadsafe.html
Apparently so - the odbc drivers use -DTHREADSAFE=1 when building sqlite.
[ ... ]
> You don't
We have an application that we distribute to our clients each of whom
run Windows - often it's a desktop XP machine. Our app consists of a
set of Delphi services and a PHP web front end each of which use ODBC
for database connectivity.
The vast majority of installations have shipped with sqliteodb
& testing the system
carefully when multiple writes may be an issue due to bugs in the file system
locking. Moreover, like sqlite, other databases are known to work well relying on
the system file locking.
David
---
David M X Green
|||"Mike Owens" (2007-02-1
but just with some
remaining problems.
Any way of fixing these issues?
Thank you
David M X Green
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
edded environments where actual power consumption is a limiting
factor. "
--
Is it really a good idea to network a data base that relies on the OS file
systems like this? Is it ever going to be safe enough?
David M X Green
|||"Alex Roston" (2007-02-02 20:05) wrote
I am contemplating something on similar lines.
Just wanted to make sure that I am not trying to reinvent the wheel.
Thanks!
On 10/26/06, Igor Tandetnik <[EMAIL PROTECTED]> wrote:
Ever Green <[EMAIL PROTECTED]> wrote:
> I am using sqlite3_column_text16 to retrieve data.
>
>
I dont think so!
These functions would help to get the parameter names from a prepared
statement. I want to retrieve data using column headings after a
sqlite3_step.
On 10/26/06, [EMAIL PROTECTED] <
[EMAIL PROTECTED]> wrote:
"Ever Green" <[EMAIL PROTECTED]>
I am using sqlite3_column_text16 to retrieve data.
The problem is that sqlite3_column_text16 takes the column number as
argument. This breaks my existing code if I insert new columns in the
beginning of the column list that was specified in the SELECT statement.
I was not able to figure out the
rg/sqlite-3.2.1.tar.gz
To convert to the older database format:
sqlite334 334.db .dump | sqlite321 321.db
And then perform your timings with both SQLite versions against
the 321.db file to level the playing field.
Just having an index on utime should be optimal for SQLite 3.2.1.
--- Steve Gre
ions on a workaround so that optimal performance can be achieved
with all data set sizes?
Thanks for your help,
Steve
Steve Green wrote:
Sorry, I forgot to mention that I'm using sqlite v3.3.4 on redhat linux
v7.3
Steve
Steve Green wrote:
Hi,
I have the following schema
CREATE TABLE data
Kurt,
Thanks, the single primary index you suggested does give us the
desired results.
Steve
Kurt Welgehausen wrote:
Steve Green <[EMAIL PROTECTED]> wrote:
CREATE UNIQUE INDEX pk_data on data( utime, r_id, u_id );
...
CREATE INDEX ix_data_ut on data( u_id, utime );
Wouldn'
where u_id >= 0 and utime >= ..., it will cuase the optimal index to be
used (however, if we every started using negative u_id values, it would
break).
What is the best way to send you sample data (and what is the maximum
file size that you'd like)?
Steve
[EMAIL PROTECTED] wrote:
Ste
Sorry, I forgot to mention that I'm using sqlite v3.3.4 on redhat linux
v7.3
Steve
Steve Green wrote:
Hi,
I have the following schema
CREATE TABLE data(
utime int4,
r_id int2,
u_id int4,
data1 int8,
data2 int8
);
Each row is uniquely defined by utime, r_id, and u_i
s this would involve rewritting the query, but
I'm at a loss as to how that could be done.
Thanks for your time,
Steve
--
Steve Green
SAVVIS
Transforming Information Technology SM
This message contains information which may be confidential and/or
privileged. Unless you are the intended rec
be made in SQLite or the CPAN DBD package?
Thanks,
Christian Werner
--
Steve Green
SAVVIS
Transforming Information Technology SM
This message contains information which may be confidential and/or
privileged. Unless you are the intended recipient (or authorized
to receive for the intended
indexes of yours tables
so that this bug may be corrected when CROSS JOIN is not used.
--- Steve Green <[EMAIL PROTECTED]> wrote:
Interestingly, using
from t1
cross join t2
fixes the problem; using this, causes indices from both tables to be used.
aps there is a bug in the join optimizer.
Try using an explicit CROSS JOIN.
select t1.a, t1.b, t2.c, t2.d
from t1
cross join t2
where t1.x = t2.x and t1.a >= 100 and t1.a < 200
group by t1.a, t1.b, t2.c, t2.d
--- Steve Green <[EMAIL PROTECTED]> wrote:
The performance
missing.
This would cover 99% of the pre-SQLite3.2.3 legacy databases
out there where the queries have already been hand-tuned.
--- Steve Green <[EMAIL PROTECTED]> wrote:
Hi,
I currently have a v3.2.0 database that contains two tables that I regularly
query with a join, e.g.,
selectt1.a
x?
Any ideas on how we can improve the performance using v3.3.x (we'd really like
to
use the most current version of the database, but the performance difference
would
be a killer)?
Thanks,
Steve
--
Steve Green
SAVVIS
Transforming Information Technology SM
This message contains information w
Thanks, that seems to have fixed the problem...
Steve
Eric Bohlman wrote:
Nathan Kurz wrote:
On Mon, Mar 06, 2006 at 06:24:13PM -0800, Steve Green wrote:
Hi,
I'm hoping that someone can shed some light on the following issue that
I'm seeing. When I attempt to create a temp t
type TEXT,
notes TEXT)" );
};
die ( $@ ) if ( $@ );
$dbh->disconnect();
exit 0;
When this code is run using SQLite v3.3.2 (or apparently any older version; we
also tried 3.3.1, 3.3.0, 3.2.7 and 3.2.0), there is no error. No modifications
to any of the installations were
55 matches
Mail list logo