Paul Bainter wrote:
> >
> > Not sure what happened to this post previously, so I guess I'll try it
> > again with some additional information
>
GMail considered these messages spam for some reason. Check your spam
folder.
e
___
sqlite-users mailing lis
Paul Bainter wrote:
>
> Not sure what happened to this post previously, so I guess I'll try it
> again with some additional information
>
It was posted to the list, see:
http://www.mail-archive.com/sqlite-users%40sqlite.org/msg79938.html
And my original reply, here:
http://w
Not sure what happened to this post previously, so I guess I'll try it again
with some additional information
I'm wondering if there is a bug somehow in the "System.Data.SQLite" dll
file.
When deploying my application to a clean Windows 7 x64 virtual machine
(VMWare Workstation 10), I got
On 23 Oct 2013, at 7:33pm, David Simmons wrote:
> The paths we follow are sometimes clouded with ego that prevent seeing the
> obvious. Making code changes to first find and then include an explicit path
> to the sqlite database solved the problem. Thanks for your help I can now
> move forw
I'm not sure if this is the appropriate place to send this and if not,
please accept my humble apologies!
I slapped something together I think this community *might* be interested
in:
https://code.google.com/p/android-sqlite-scaffolding/
BSD license... (honestly I don't really care, if they had
Thank you. We'll improve that.
2013/10/23 Donald Griggs
> Congratulations to the team!
>
> Just a note in the spirit of helpfulness:
> Note that one of the major headings on the website is misspelled
> "Purhase."There are numerous grammar errors in the website text. I
> suggest you ma
On Wed, Oct 23, 2013 at 2:34 PM, Vinay Boocha wrote:
> Dear Rich,
>
> I try to communicate better this time.
>
> If I go by calls to my VFS then Yes. The subsequent SQL executions (same
> SQL ran multiple times) will not result in page fetches (only fetch is for
> offset=24 length=16).
>
> Here i
On Wed, Oct 23, 2013 at 8:33 PM, David Simmons wrote:
> The paths we follow are sometimes clouded with ego that prevent seeing the
> obvious. Making code changes to first find and then include an explicit
> path to the sqlite database solved the problem. Thanks for your help I can
> now move for
Dear Rich,
I try to communicate better this time.
If I go by calls to my VFS then Yes. The subsequent SQL executions (same
SQL ran multiple times) will not result in page fetches (only fetch is for
offset=24 length=16).
Here is the pseudo scenario:
1. attach 'portfolio.db' as pdb;
2. cre
The paths we follow are sometimes clouded with ego that prevent seeing the
obvious. Making code changes to first find and then include an explicit path
to the sqlite database solved the problem. Thanks for your help I can now move
forward.
BTW - I could not isolated Error Code 255 to a spec
On Wed, Oct 23, 2013 at 1:50 PM, Vinay Boocha wrote:
> Dear Rich,
>
> Thanks for the response. I guessed it might need some cache but thought it
> will refetch every time to ensure consistency.
>
> My main issue is that temp views are not picking up the update after the
> pages of joined tables g
Dear Rich,
Thanks for the response. I guessed it might need some cache but thought it
will refetch every time to ensure consistency.
My main issue is that temp views are not picking up the update after the
pages of joined tables got updated (tables are updated by another actor in
the system).
An
On Wed, Oct 23, 2013 at 1:20 PM, Vinay Boocha wrote:
> Dear All,
>
> We are observing that temp views are using page cache even after setting
> the cache_size= 0. I am stuck debugging this issue for the last two days.
> Any pointers will be greatly appreciated.
>
Depending on the query and the s
Dear All,
We are observing that temp views are using page cache even after setting
the cache_size= 0. I am stuck debugging this issue for the last two days.
Any pointers will be greatly appreciated.
When we run a SQL query multiple times on a temp view our custom vfs is
getting read call only for
Congratulations to the team!
Just a note in the spirit of helpfulness:
Note that one of the major headings on the website is misspelled
"Purhase."There are numerous grammar errors in the website text. I
suggest you may want to have a native English speaker proof it.
On Wed, Oct 23, 201
Hi,
we are happy to announce a final release of SqliteDog: a modern SQLite
database manager.
http://sqlitedog.com
--
Regards,
SqliteDog support team
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinf
On 23 Oct 2013 at 15:02, Simon Slavin wrote:
> On 23 Oct 2013, at 1:15pm, Tim Streater wrote:
>
>> HmmmOK. I'm therefore making a second attempt to use the sqlite3 PHP
>> interface in my application instead of PDO. There will be about 35 modules to
>> alter so I hope I can work through any issu
On 23 Oct 2013, at 1:15pm, Tim Streater wrote:
> HmmmOK. I'm therefore making a second attempt to use the sqlite3 PHP
> interface in my application instead of PDO. There will be about 35 modules to
> alter so I hope I can work through any issues.
Sorry to put you to the work. Might be worth
On 22 Oct 2013, at 11:00pm, David Simmons wrote:
> I am becoming more and more frustrated when I attempt to create a local Mac
> app with py2app when sqlite3 database is being used. The py2app creates the
> application, however; executing it immediately causes the app to exit with
> error co
Tim Streater wrote:
> select count(*),x,y,z from sometable where …;
>
> or is that a bad idea?
An aggregate function prevents you from getting the individual records:
sqlite> create table sometable(x,y,z);
sqlite> insert into sometable values (1,2,3), (4,5,6);
sqlite> select count(*),x,y,z from
On 22 Oct 2013 at 09:11, Simon Slavin wrote:
> If you are writing code specifically intended for use with SQLite (like your
> library was meant to be) then please use PHP's sqlite3 library rather than the
> PDO. The advantage of using PDO is that if you transfer from one DBMS to
> another, you
I am becoming more and more frustrated when I attempt to create a local Mac app
with py2app when sqlite3 database is being used. The py2app creates the
application, however; executing it immediately causes the app to exit with
error code 255. I've spent days searching the internet for a soluti
22 matches
Mail list logo