[sqlite] SQLite server using execnet ?

considered to use Python execnet-module to realize a simple SLQlite client / server application. If I look at the documentation of execnet, (and I realize that I'm a great optimist) it would take between 20 and 50 lines of Python code. thanks very much for your opinions. cheers, Stef Mientki

Re: [sqlite] what could be the reason that natural join stops working ?

On 15-09-2010 20:12, Nicolas Williams wrote: > On Wed, Sep 15, 2010 at 08:05:26PM +0200, Stef Mientki wrote: >> On 15-09-2010 11:36, Benoit Mortgat wrote: >>> Are you sure that after altering your tables adding columns, natural >>> join still only joins on vlid? &

Re: [sqlite] what could be the reason that natural join stops working ?

On 15-09-2010 11:36, Benoit Mortgat wrote: > On Tue, Sep 14, 2010 at 23:41, Stef Mientki <stef.mien...@gmail.com> wrote: > >> until a few moments ago, this worked perfectly >> >> select Header from vraag >> natural join vraaglist >> where Nr = 0 and v

Re: [sqlite] what could be the reason that natural join stops working ?

> tables along with their indexes and constraints. > > Pavel > > On Tue, Sep 14, 2010 at 6:09 PM, Stef Mientki <stef.mien...@gmail.com> wrote: >> On 14-09-2010 23:50, Oliver Peters wrote: >>> your version of sqlite? >> I used several programs >> SQ

Re: [sqlite] what could be the reason that natural join stops working ?

done before the Natural Join stopped working? converted tables from string to unicode, column rename + columns added + changed column constraints ( through copy table / drop table / rename table ) thanks, Stef > Oliver > > > Am Dienstag, den 14.09.2010, 23:41 +0200 schrieb Stef Mientk

[sqlite] what could be the reason that natural join stops working ?

ect string of the field Header. exchanging the 2 tables in the above statements, gives exactly the same results. Is my database corrupt ? thanks, Stef Mientki ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] is there a program that converts sqlite database from windows-1252 to utf-8 ?

thanks Ralf, nice db-browser, and conversion seems to work. cheers, Stef On 13-09-2010 11:03, Ralf Junker wrote: > On 11.09.2010 20:42, Stef Mientki wrote: > >> is there a program that converts sqlite database from windows-1252 to utf-8? > Yes, SQLiteSpy does this: > >

[sqlite] is there a program that converts sqlite database from windows-1252 to utf-8 ?

thanks Stef Mientki ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Create a GUI for interacting with a test questions sqlite db

On 05-09-2010 10:47, Arthur Avramiea wrote: > I would like to use sqlite to create a question db for test generation. It > will be organized in a couple of questions cathegories. A random function > will generate a test by selecting a couple of questions from each section. > The sqlite db will be

[sqlite] is there a way to extend the field information ?

of a way to combine these result in SQL (e.g. the pragma statement doesn't generate a header, the select does) I combine the results in python. Now I wonder if this combine can also be done in pure SQL. And are there other (better) ways to extend the metadata of fields ?

Re: [sqlite] feature request - field exclusion list in select list

Stephan Wehner wrote: > On Sun, Sep 27, 2009 at 5:19 PM, Darren Duncan > wrote: > >> Following my previous message to the sqlite-users list, I've done a bit more >> research and decided to escalate my reply to a formal feature request. >> >> I was initially going to

Re: [sqlite] SELECT ALL BUT syntax (was Re: less typing possible ?)

thanks Darren, Darren Duncan wrote: > Stef Mientki wrote: > >> hello, >> >> I often want to see most of the columns of a table / view / query, but a >> few I don't want to see. >> So I now create a huge list of fields, >> but isn't there a

[sqlite] less typing possible ?

hello, I often want to see most of the columns of a table / view / query, but a few I don't want to see. So I now create a huge list of fields, but isn't there a more typo-frindly way, like : select * - field33 from table thanks, Stef Mientki

Re: [sqlite] full outer join questions

Pavel Ivanov wrote: >> select coalesce(RT1.PID, RT2.PID) as PID, RT1.V1, RT2.V2 ... >> > > I find function ifnull() more readable in such cases. ;-) > > thanks guys, both (of course ;-) works perfectly. I have to study the functions in SQLite some more !! cheers, Stef

Re: [sqlite] full outer join questions

> Justing adding ORDER BY changes all "left" (from what?) columns in all > rows to NULL? No way! Show the actual output from sqlite3 command line > utility please. > > >> Is it uberhaupt possible to order the resulting table on the column PID >> and preferable

[sqlite] full outer join questions

hello, I'm trying to join 2 tables, so I guess I need to perform a full outer join. On wikipedia, I found this solution for sqlite3: http://en.wikipedia.org/wiki/Join_%28SQL%29 select * from RT0 left join RT1 on RT1.PID = RT0.PID union select RT0.*, RT1.* from RT1 left

Re: [sqlite] I'm surprised what the author of web2py on web2py mailing list just said about sqlite

the answer of Massimo (the web2py author): I apologize and I conclude my statement is not correct. I have experienced this problem once (out of disk space and sqlite database corruption) but I made the mistake of confusing correlation with causality. Except in that occasion I never had any

Re: [sqlite] I'm surprised what the author of web2py on web2py mailing list just said about sqlite

D. Richard Hipp wrote: > On Sep 9, 2009, at 5:35 PM, Stef Mientki wrote: > >> >> The worse thing about sqlite is that if the file grows and you run out >> of memory, the file gets corrupted and you lose data. >> >> > > The web2py author s

[sqlite] I'm surprised what the author of web2py on web2py mailing list just said about sqlite

The worse thing about sqlite is that if the file grows and you run out of memory, the file gets corrupted and you lose data. cheers, Stef ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] how to get "One to many" in 1 row of a table ?

Shaun Seckman (Firaxis) wrote: > It seems like the more ideal solution would be to create a third table for > ownership that contains a person ID and a vehicle ID. thanks Shaun, but that's what I (i'm not a database expert) call the Bind table. I read some articles about normalization, and I

Re: [sqlite] how to get "One to many" in 1 row of a table ?

Simon Slavin wrote: > On 9 Sep 2009, at 5:15pm, Stef Mientki wrote: > > >> The situation is like this (simplified): >> >> I've a table with persons: name, address, phone, etc. >> I've another table with vehicles: car_or_bike, brand, type, build- >>

Re: [sqlite] how to get "One to many" in 1 row of a table ?

Igor Tandetnik wrote: > Stef Mientki <s.mien...@ru.nl> wrote: > >> I'm just an amateur struggling with databases, >> so forgive if I ask a question every database user should know. >> >> The situation is like this (simplified): >> >> I've

[sqlite] how to get "One to many" in 1 row of a table ?

(in Python) ? Any suggestions to make it faster and /or more structural will be greatly appreciated. thanks, Stef Mientki ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Is there an easy way to concatenate 2 views ?

s in b, if > not then build a column list and use that indtead of * > > Woody > > -Original Message- > From: Stef Mientki <s.mien...@ru.nl> > Sent: Saturday, July 25, 2009 3:19 PM > To: SQLite List <sqlite-users@sqlite.org> > Subject: [sqlite] Is the

[sqlite] Is there an easy way to concatenate 2 views ?

hello, I've 2 views ( or maybe tables) with same columns, is there an easy way to concatenate those 2 views to 1 new view ? thanks, Stef Mientki ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo

[sqlite] Use the result of a query, as a variable name in another query ?

. Is there a way realize this in the command line ? So I need to get the result of a query into a variable and then use that variable in a new query. thanks, Stef Mientki ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin

[sqlite] one or many tables, what gives the best performance ?

hat's how I use the data: when I extract data from this database, - I search for a row in table "A" - I read all the 50 extra rows of other information thanks, Stef Mientki ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] database is slowing down, caused by Sophos

hello, No question, just some information that might be useful to someone. We have a number of small SQLite databases, which are located on a network drive. Users are complaining the last months that these databases becomes slower every week. After investigating the case, we found that Sophos

Re: [sqlite] Delete, sometimes doesn't seem to work ...

dy deleted the records, I'll try to rmemeber that for the next time. cheers, Stef > Simon > > On Sat, Feb 7, 2009 at 4:28 PM, Stef Mientki <s.mien...@ru.nl> wrote: > >> hello, >> >> I'm a very happy user of sqlite for about 2 years. >> And as I'm happy for

[sqlite] Delete, sometimes doesn't seem to work ...

as an integer field. In Delphi I'm using SQLite 3.3.8 One other point, those rows with Indx=0 were inserted by a wrong statement (can't remember exactly what) Anyone has a clue ? btw. for the moment I solved the problem by recreating the whole database again. thanks, Stef Mientki

Re: [sqlite] Recommended wrapper for Python?

Gilles Ganault wrote: Hello I browsed through the archives at Gname, but most threads regarding wrappers for Python date back to 2005. There are several wrappers listed in the wiki (http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers), so I'd like some feedback about which you would

[sqlite] Found the problem: Re: [sqlite] Is this a valid syntax

') I'ld consider this as a bug, but I'm not sure who's to blame ;-), SQLite or the Delphi wrapper or my own program I'll study the datatype page again: http://www.sqlite.org/datatype3.html Thank you all for your suggestions, which finally solved my problem, cheers, Stef Mientki

Re: [sqlite] Is this a valid syntax

Dennis Cote wrote: Stef Mientki wrote: But it doesn't solve my problem :-( I've the feeling that despite the suggestions of Igor, the problem still exists, caused by the zero values ?? I'll try tomorrow again with some other values. Stef, Oh... I though Igor had solved your problem so I

Re: [sqlite] Is this a valid syntax

Dennis Cote wrote: Stef Mientki wrote: I don't know if this is the problem, but, for some reason you're mixing C/C++ syntax in with SQL there. You don't use '==', you should just use '=' You don't use '!=', you should use '<>' thanks Paul, but although I can neve

Re: [sqlite] Re: Is this a valid syntax

Igor Tandetnik wrote: Stef Mientki <[EMAIL PROTECTED]> wrote: I use the following syntax, and I get 7 records back, (which is not correct in my opinion) SELECT PO.* FROM Koppel LEFT JOIN PO WHERE (Koppel.K_App == PO.App) AND (Koppel.K_naam == 'MVE') AND (PO.ALL_an

Re: [sqlite] Is this a valid syntax

I don't know if this is the problem, but, for some reason you're mixing C/C++ syntax in with SQL there. You don't use '==', you should just use '=' You don't use '!=', you should use '<>' thanks Paul, but although I can never find this information when I need it :-( AFAIK, both

[sqlite] Is this a valid syntax

statements etc, but most of them (may be all, can't remember anymore), returns 16-0-7 records. Sorry, I must be doing something terrible wrong, but I don't see the clue. thanks, Stef Mientki Kamer van Koophandel - handelsregister 41055629 / Netherlands Chamber of Commerce - trade register 41055629

Re: [sqlite] trim available ??

Dennis Cote wrote: Stef Mientki wrote: I don't know which version I'm running, how can I detect that ? Stef, You can call sqlite3_libversion (see http://www.sqlite.org/capi3ref.html#sqlite3_libversion for details). Thanks Dennis, Yes, I see now, I've 3.3.8 ;-) cheers, Stef Mientki

Re: [sqlite] trim available ??

Liam Healy wrote: An option for versions that do not have trim is http://sqlite.org/contrib//download/extension-functions.tgz?get=17 thanks Liam, but I think it's better to recreate the database, with trimmed itesm. cheers, Stef

Re: [sqlite] trim available ??

The TRIM function was added on 2007-03-17 17:52:42. Thanks, that explains .. cheers, Stef -- D. Richard Hipp <[EMAIL PROTECTED]> Kamer van Koophandel - handelsregister 41055629 / Netherlands Chamber of Commerce - trade register 41055629

Re: [sqlite] trim available ??

Mohd Radzi Ibrahim wrote: Hi, I'm running 3.3.15. No problem at all. Maybe your version does not have this implemented yet... I don't know which version I'm running, how can I detect that ? I use the SQLITE3.DLL dated 8 october 2006, but windows can't find the version info in that file.

[sqlite] trim available ??

** Error executing SQL "SELECT App FROM PO WHERE LOWER(App_Type) = TRIM(LOWER('{ Afzuigapparaat } ')) " :: no such function: TRIM **/ What am I doing wrong ? thanks, Stef Mientki Kamer van Koophandel - handelsregister 41055629 / Netherlands Chamber of

Re: [sqlite] ANN: SQLcc another open source Database manager

try again. -- cheers, Stef Mientki http://pic.flappie.nl - To unsubscribe, send email to [EMAIL PROTECTED] -

[sqlite] ANN: SQLcc another open source Database manager

have fun ! -- cheers, Stef Mientki http://pic.flappie.nl - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Re: to quote or not ?

Thanks very much Igor, that explains it, cheers, Stef Mientki Igor Tandetnik wrote: Stef Mientki <[EMAIL PROTECTED]> wrote: So I would expect that I now can always double quote the selection fields, but unfortunately that doesn't seem to be true. From a graphical design, I get for in

[sqlite] to quote or not ?

o I can think of the following solutions: 1. never double quote selection fields, unless there's a ':' or a space in the name 2. always double quote selection fields, unless there's a '.' in it Which one is the most general, or are there even better ways ? Thanks, -- cheers, Stef

Re: [sqlite] Re: Meta Information: How to retrieve the column names of a table ?

How can I get all the names of a table without doing a query against the table ? PRAGMA table_info(table-name); And it also works for views, as just found out by trial and error ;-) Is this standard SQL behavior ? -- cheers, Stef Mientki http://pic.flappie.nl

Re: [sqlite] Pragma table_info(), why no fields like UNIQUE, AUTOINCREMENT

COS wrote: Hi, - Original Message - From: "Stef Mientki" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Tuesday, March 13, 2007 3:47 PM Subject: Re: [sqlite] Pragma table_info(), why no fields like UNIQUE, AUTOINCREMENT You should also consider

Re: [sqlite] Pragma table_info(), why no fields like UNIQUE, AUTOINCREMENT

() - query sqlite_master, to get the SQL string with which the table was generated - parse the SQL string from sqlite_master - and add it to my edit grid form table_info or are there simpler ways ? -- cheers, Stef Mientki http://pic.flappie.nl

[sqlite] Pragma table_info(), why no fields like UNIQUE, AUTOINCREMENT

, or is it (deliberately) left out of the pragma ? thanks, Stef Mientki KvK: 41055629 - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] are nested joins possible ?

Stef Mientki wrote: thanks guys, for the fast and different responses, I really appreciate that. ... now I need a couple hours to study all your ideas. After studying all your suggestions, I must conclude that my knowledge of SQL is too low to create a real fool proof solution

Re: [sqlite] are nested joins possible ?

thanks guys, for the fast and different responses, I really appreciate that. ... now I need a couple hours to study all your ideas. -- cheers, Stef Mientki http://pic.flappie.nl - To unsubscribe, send email to [EMAIL

[sqlite] are nested joins possible ?

such a nested statement working ?? I'm looking for some construct that can used to generated code from a visual design, through recursion of the links, so it must be simple. thanks, -- cheers, Stef Mientki http://pic.flappie.nl

Re: [sqlite] Script Language

Cesar Rodas wrote: I am planning to develop a interpreted language with LEMON && FLEX. The main goal is to provide a easy way to script commons actions, and to teach algorithm in my University (National University of Asuncion - Paraguay). The language have syntax as PHP and Python I wonder

Re: [sqlite] Argh, this must be a very stupid question ...

ill be manipulating ini-files, thanks for SQLite! -- D. Richard Hipp <[EMAIL PROTECTED]> -- cheers, Stef Mientki http://pic.flappie.nl - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Re: Argh, this must be a very stupid question ...

thanks Igor, so it was indeed a stupid question ! -- cheers, Stef Mientki http://pic.flappie.nl - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] I Need database fot some test

thanks Dennis, Single quote delimit a string literal. Double quotes delimit a quoted identifier (i.e a column or table name etc that contains special characters such as a space). I just checked Sybase Manual, and there it's exactly as you say. -- cheers, Stef Mientki http://pic.flappie.nl

Re: [sqlite] I Need database fot some test

thanks Dennis, Marco, And the standard SQL syntax should work from any standard compliant database program. SELECT * FROM "Order Details" I'm just a novice, and although both suggested solutions work, I thought SINGLE QUOTES were thé standard ? -- cheers, Stef Mi

Re: [sqlite] I Need database fot some test

f the well known Microsoft Northwind sample that can be found for MS Access and SQL Server. -- cheers, Stef Mientki http://pic.flappie.nl - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Re: Re: A few (probably) simple questions ...

Igor Tandetnik wrote: Stef Mientki <[EMAIL PROTECTED]> wrote: Q2: Why isn't ALIAS supported in the JOIN-line, or am I doing something wrong ? SELECT Patient_text.*, Opnamen.* FROM Patient INNER JOIN Patient_text, Opnamen AS O WHERE Patient.PatNr = Patient_text

Re: [sqlite] A few (probably) simple questions ...

unfortunately it only supports sqlite 2 :-( I wondered if the source for the database interface of http://OpenOffice.org might help, since they appear to implement exactly that -- even including an sqlite driver. -- cheers, Stef Mientki http://pic.flappie.nl

Re: [sqlite] A few (probably) simple questions ...

thanks Donald, I should be ashamed, as OpenOffice is my standard office package, didn't know OpenOffice supported SQLite (MS-Access didn't ), so I'll take a look. -- cheers, Stef Mientki http://pic.flappie.nl

Re: [sqlite] Re: A few (probably) simple questions ...

quote is from http://www.sqlite.org/lang_select.html where nothing is said about not supporting "RIGHT", and now I assume this page lists a lot more that's not supported (yet) ;-) -- cheers, Stef Mientki http://pic.flappie.nl

[sqlite] A few (probably) simple questions ...

= Patient_text.PatNr ANDPatient.PatNr = '1' Q3: In the SQL help on the web, I read: "/join-op/ ::= *, *|* *[*NATURAL*]* *[*LEFT *|* RIGHT *|* FULL*]* *[*OUTER *|* INNER *|* CROSS*]* JOIN*" But when I try a RIGHT JOIN, I get an error message ??? thanks, -- cheers, Stef Mi

Re: [sqlite] I Need database for some test

lordphoenix wrote: Le Sun, 04 Mar 2007 22:01:30 +0100, Stef Mientki <[EMAIL PROTECTED]> a écrit : lordphoenix wrote: I'm developing an SQlite database administration tool (web site is there : http://litemanager.tuxamily.org) this link doesn't seem to work :-(

Re: [sqlite] I Need database for some test

lordphoenix wrote: I'm developing an SQlite database administration tool (web site is there : http://litemanager.tuxamily.org) this link doesn't seem to work :-( cheers, Stef Mientki - To unsubscribe, send email

Re: [sqlite] Re: Re: How to change or add fields to a table ?

SQLite, (It's the first database I found without difficult couplings / logins, so I really love it), but I wondered if there was a special nifty reason to omit the renaming of columns. thanks again, Stef Mientki

Re: [sqlite] Re: How to change or add fields to a table ?

tand how I can change a columns name. On the other hand I fear that I can only change the name of the Table. If the later is true, why isn't possible to change the name of a column (shouldn't be difficult to implement) ? cheers, Stef Igor Tandetnik wrote: Stef Mientki <[EMAIL PROT

[sqlite] How to change or add fields to a table ?

With the pragma table_info I can get the complete table structure Pragma table_info(Patient) Are there SQL commands to add or change the fields of an existing table, or should the table completely be rebuild ? -- thanks, Stef Mientki http://pic.flappie.nl

Re: [sqlite] Re: Quotes in SQLite ?

Dennis, Igor thanks very much, I think I'm getting the picture. cheers, Stef - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Re: Quotes in SQLite ?

Igor Tandetnik wrote: Stef Mientki <[EMAIL PROTECTED]> wrote: This might be a stupid question, but how do you store quotes in textstrings ? Is it really so that you have to replace, both single and double quotes, each time you read or write something ? You need to escape single

[sqlite] Quotes in SQLite ?

This might be a stupid question, but how do you store quotes in textstrings ? Is it really so that you have to replace, both single and double quotes, each time you read or write something ? Are there other such kind of special characters ? thanks, Stef Mientki

[sqlite] The best way to delete a column ?

be welcome ;-) thanks, Stef Mientki - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] (newbie) pictures in tables, what's the best way ?

Roger Binns wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Stef Mientki wrote: Uptill now the dbase is small so no performance problems yet. Wait until you have performance problems and then solve them :-) It is almost always the case that performance issues don't crop up

Re: [sqlite] Re: Re: how to get field names of empty tables ?

Scott Hess wrote: I think only the dot commands are special (.help, etc). Everything else is fair game. Best reference for what you can feed a prepare or exec is http://www.sqlite.org/lang.html . Scott, thanks for this valuable information. Now how beautiful it would be if it was all in 1

Re: [sqlite] Re: how to get field names of empty tables ?

Igor Tandetnik wrote: Stef Mientki <[EMAIL PROTECTED]> wrote: is there an SQL statement to get the field-names of empty tables ? PRAGMA table_info(tableName); Igor Tandetnik Thanks Igor, I had seen that command, but I wrote something about that these commands could only be ru

[sqlite] how to get field names of empty tables ?

is there an SQL statement to get the field-names of empty tables ? thanks, Stef Mientki - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] (newbie) pictures in tables, what's the best way ?

lected line. I've never seen such a construct in examples, so maybe I see ghosts where there are none. forgive me my ignorance. cheers, Stef Mientki here is a C example http://www.sqlite.org/cvstrac/wiki?p=BlobExample On 23/02/07, Stef Mientki <[EMAIL PROTECTED]> wrote: hello, I've s

[sqlite] (newbie) pictures in tables, what's the best way ?

with the first 2 bytes of a blob solution 2: put the blob fields in a separate table, with a link to the main table any suggestions would be appreciated. thanks, Stef Mientki - To unsubscribe, send email to [EMAIL PROTECTED] -