On Monday, June 10, 2019 03:46:02 AM Simon Slavin wrote:
> On 10 Jun 2019, at 3:44am, Mark Halegua wrote:
> > I probably should figure this out, but in a GUI, how do I recover a
> > graphic from the database?
> Programming. SQLite can't do it since it doesn't even und
On Sunday, June 09, 2019 08:24:10 PM Richard Hipp wrote:
> On 6/9/19, Igor Korot wrote:
> > Now I open this database in sqlite3 CLI binary and would like to insert
> > some png
> > file inside this BLOB field.
>
> INSERT INTO tab1(blob1) VALUES(readfile('some.png'));
I probably should figure thi
On Thursday, October 30, 2014 12:16:17 AM jonathon wrote:
> On 29/10/14 19:46, Billy Huynh wrote:
> > the SQLite Master Suite.
> > It mainly designed to handle a very large database file with lightning
> > fast import and export of data and
> Support for Windows Server 2003, which EOLs on Bastille
Original message ----From: Mark Halegua
> Date:2014-10-08 16:12 (GMT-07:00)
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] In python,
> determine database status
> ___
> sqlite-users mailing list
> sqlite-use
On Wednesday, October 08, 2014 11:04:33 PM Simon Slavin wrote:
> On 8 Oct 2014, at 10:45pm, Mark Halegua wrote:
> > I think my problem is I've opened the database in different modules for
> > different views of the data (there are six tables, one of which relates
> > to
I have an application I'm using sqlite3 as the database for. The program is
designed to
view and add/edit information. The viewing part is set up and working nicely
using pysqlite
and wxpython.
What the problem is is from viewing trying to add data. I get a database is
locked error.
I thi
Is anyone able to tell me why I'm having this commit problem in python?
Mark
On Saturday, October 04, 2014 11:43:41 AM Mark Halegua wrote:
> Just tried the same code on a different system, using sqlite3 3.8.2
>
> Same result.
>
> Mark
>
> On Saturday, October
n.
> >>> import sqlite3
> >>> sqlite3.sqlite_version
>
> '3.8.7'
>
> >>> sqlite3.version
>
> '2.6.0'
>
>
> sqlite3.version is the version number of pysqlite ...
>
> >-Original Message-
> >From
n.
> >>> import sqlite3
> >>> sqlite3.sqlite_version
>
> '3.8.7'
>
> >>> sqlite3.version
>
> '2.6.0'
>
>
> sqlite3.version is the version number of pysqlite ...
>
> >-Original Message-
> &g
and now the windows version, with sqlite 3.8.6 and a local database and local
code in the
same directory is doing the same, database locked. And yet, at the command
line I could
do an insert no problem.
Mark
On Saturday, October 04, 2014 12:00:59 PM Mark Halegua wrote:
> Kieth,
>
o commit or rollback.
>
> Is the database file in use by something else? Do you have a busy wait
> timeout set? What Operating System are you running on?
> On Saturday, 4 October, 2014 08:44, Mark Halegua
> said:
> >Kieth,
> >
> >thanks for the info, however, I te
Just tried the same code on a different system, using sqlite3 3.8.2
Same result.
Mark
On Saturday, October 04, 2014 10:44:20 AM Mark Halegua wrote:
> Kieth,
>
> thanks for the info, however, I tested the following code on a LOCAL copy of
> the database, one where at the sqlite3 co
output and using an except there.
> >
> >On Friday, October 03, 2014 11:35:08 PM you wrote:
> >> the sqlite3 command line doesn't require a commit, it gave an error
> >> after the attempted insert command.
> >>
> >> pysqlite requires one
sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
> > >boun...@sqlite.org] On Behalf Of Mark Halegua
> > >Sent: Friday, 3 October, 2014 20:58
> > >To: sqlite-users@sqlite.org
> > >Subject: [sqlite] passing error messages to pysqlite
> > >
> >
I have a sqlite3 database. In the networkied are I have the db is locked
(wee've
discussed this before, and I'm using it mostly on a local machine, but I need
to
test certain conditions, networking being one).
In the sqlite3 command line, when I try to insert new info I get a dabase
locked
On Friday, September 19, 2014 08:07:06 PM Simon Slavin wrote:
> No, no he's just working on US Pulp Magazines. All pulp writers have
> traditional names. He's not going to have any trouble.
>
> Except, of course, with Daniel Keys Moran. Who doesn't use his first name
> except when writing. And
Simon,
that resolved it. I didn't know you needed to put the desc with both columns.
It means another table I had thought was properly ordered wasn't.
Thank you.
Mark
On Friday, September 19, 2014 12:50:57 AM Simon Slavin wrote:
> On 19 Sep 2014, at 12:40am, Mark Halegua wrote:
I've come upon a problem in sqlite3.
Here's the table:
CREATE TABLE contributors(
contrib_id integer primary key,
contrib_lname char not null,
contrib_fname char,
contrib_mname char,
writer int,
artist int,
editor int)
I've inserted several names. When I order by contrib_lname, contrib_f
Kieth,
Thanks for the reply. I should have asked sooner and would have wasted less
time trying to
do something sqlite wasn't meant for. I will however look up rolling cursors.
That may help
a little. Again, thanks.
Mark
On Wednesday, September 17, 2014 11:14:36 PM Keith Medcalf wrote:
I'm racking my brain trying to figure out how to get directly to the last item
in a (potentially)
sorted or ordered table. At least oe of the tables will be ordered by a name
and a date,
so uising the rtowid won't work.
Also, how to traverse a table or cursor in a reverse direction.
Going fr
On Saturday, September 13, 2014 01:10:37 AM Kees Nuyt wrote:
> On Sat, 13 Sep 2014 00:55:23 +0200, Kees Nuyt
>
> wrote:
> > It works better on your local filesystem.
>
> Perhaps you can configure (a partition on) the Seagate GoFlex as
> an iSCSI target and configure an iSCSI initiator on the PC
On Friday, September 12, 2014 09:43:39 PM Simon Slavin wrote:
> On 12 Sep 2014, at 9:15pm, Mark Halegua wrote:
> > On Friday, September 12, 2014 06:57:21 PM Simon Slavin wrote:
> >> On 12 Sep 2014, at 5:28pm, Mark Halegua wrote:
> >>> The db file is stored on a sea
On Friday, September 12, 2014 06:57:21 PM Simon Slavin wrote:
> On 12 Sep 2014, at 5:28pm, Mark Halegua wrote:
> > The db file is stored on a seagate goflex device as my kinda file server.
> > on that device I can open the db to read but not to write to.
>
> Do you get an e
I'm developing an application, for single users, using python and wxpyton with
pysqlite. I often go into the database via sqlite3 to modify stuff or add
records to tables for testing.
The db file is stored on a seagate goflex device as my kinda file server. on
that device I can open the db to
Max,
I'm currently creating an application with sqlite using python and wxpython
for the gui. It's a great combo and working out nicely.
Mark
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite
this may seem like a small issue, but I'm not sure if the solutions I've found
on the web will do what I want in a low memory situation.I'd like to iterate
through a table one row at a time. I can do that in pysqlite, but I don't see
a method for determining I'm at the end of the file
Can anyo
26 matches
Mail list logo