Re: [sqlite] How to insert the BLOB in database?

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 understand th

Re: [sqlite] How to insert the BLOB in database?

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

Re: [sqlite] New kids on block the SQLite Master Suite.

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

Re: [sqlite] In python, determine database status

Original message ----From: Mark Halegua > <phanto...@mindspring.com> Date:2014-10-08 16:12 (GMT-07:00) > To: General Discussion of SQLite Database > <sqlite-users@sqlite.org> Subject: Re: [sqlite] In python, > determine database status > ___

Re: [sqlite] In python, determine database status

On Wednesday, October 08, 2014 11:04:33 PM Simon Slavin wrote: > On 8 Oct 2014, at 10:45pm, Mark Halegua <phanto...@mindspring.com> wrote: > > I think my problem is I've opened the database in different modules for > > different views of the data (there are six tables,

Re: [sqlite] passing error messages to pysqlite

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 04,

Re: [sqlite] passing error messages to pysqlite

e3 > >>> sqlite3.sqlite_version > > '3.8.7' > > >>> sqlite3.version > > '2.6.0' > > > sqlite3.version is the version number of pysqlite ... > > >-Original Message- > >From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- >

Re: [sqlite] passing error messages to pysqlite

e3 > >>> sqlite3.sqlite_version > > '3.8.7' > > >>> sqlite3.version > > '2.6.0' > > > sqlite3.version is the version number of pysqlite ... > > >-Original Message- > >From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users

Re: [sqlite] passing error messages to pysqlite

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: > Ki

Re: [sqlite] passing error messages to pysqlite

lback. > > 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 <phanto...@mindspring.com> > said: > >Kieth, > > > >thanks

Re: [sqlite] passing error messages to pysqlite

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

Re: [sqlite] passing error messages to pysqlite

lite3 command line doesn't require a commit, it gave an error > >> after the attempted insert command. > >> > >> pysqlite requires one? > >> > >> Mark > >> > >> On Friday, October 03, 2014 09:06:56 PM Keith Medcalf wrote: >

Re: [sqlite] passing error messages to pysqlite

ers-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 hav

[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

Re: [sqlite] An order by problem, maybe a bug?

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.

Re: [sqlite] An order by problem, maybe a bug?

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 <

[sqlite] An order by problem, maybe a bug?

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,

Re: [sqlite] I'm trying to figure out how to ...

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:

[sqlite] I'm trying to figure out how to ...

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

Re: [sqlite] sqlite db is locked on network drive

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

Re: [sqlite] sqlite db is locked on network drive

On Friday, September 12, 2014 09:43:39 PM Simon Slavin wrote: > On 12 Sep 2014, at 9:15pm, Mark Halegua <phanto...@mindspring.com> wrote: > > On Friday, September 12, 2014 06:57:21 PM Simon Slavin wrote: > >> On 12 Sep 2014, at 5:28pm, Mark Halegua <phanto...@mindspri

Re: [sqlite] sqlite db is locked on network drive

On Friday, September 12, 2014 06:57:21 PM Simon Slavin wrote: > On 12 Sep 2014, at 5:28pm, Mark Halegua <phanto...@mindspring.com> 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 writ

[sqlite] sqlite db is locked on network drive

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

[sqlite] SQLITE GUI

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

[sqlite] how best to determine # of rows in a table

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