Re: [sqlite] combining multiple queries

two tings I would do. 1. further normalize your tag field make it a table keyed by id and tag join to this in your query 2. for genre = "comedy" OR genre = "drama" I would genre IN ("comedy", "drama") you might consider further normalizing genre, to reduce duplication and also allow

[sqlite] combining multiple queries

heya folks, I'm trying to figure out the proper syntax for doing a query of something like this: I have two different types of things that people will be querying for, and I want to do an OR on each, but and AND between them.. So let's say i've got a table that looks like this: Create TABLE

[sqlite] Ответ: Re: [sqlite] count up how much an free space on DB

Thanks Richard. I will try. --- [EMAIL PROTECTED] пишет: > Artem Yankovskiy <[EMAIL PROTECTED]> wrote: > > Question, whether probably to count up how much an > > free space there is in this a DB? > > > > If the first byte of the database file is called > byte 0, > then bytes 16 and 17 form a

Re: [sqlite] disk I/O error writing files mounted via samba

Guy Hindell wrote: > I would like to use sqlite (v3.3.8) on a linux box (fedora core 5) to > read/write a database file in a directory which is actually on a windows > share mounted via samba/cifs. I can open the file, and read from it, but > writing produces "disk I/O error" messages

Re: [sqlite] SQLiteJDBC is now 100% Pure Java

On 14/12/06, Christian Smith <[EMAIL PROTECTED]> wrote: > http://www.zentus.com/sqlitejdbc Is locking now handled by NestedVM so that the driver is useable with native SQLite processes? Yes, that's why it took me so long. :) I have implemented fcntl() locking using java.nio.*, which means it

Re: [sqlite] SQLiteJDBC is now 100% Pure Java

David Crawshaw uttered: For several months now I have been providing a Java JDBC driver for SQLite 3. Now I am happy to announce with v030, the completion of a 100% Pure Java version. http://www.zentus.com/sqlitejdbc This is accomplished with the support of the great NestedVM project. The

[sqlite] SQL extension

What are our options to extend or change SQL syntax if needed? Dusan - To unsubscribe, send email to [EMAIL PROTECTED] -

[sqlite] Re: Re: Select with left outer join - Am I going mad ? Second edition

Alexandre Guion <[EMAIL PROTECTED]> wrote: I tried this one of course, and it doesn't work, it could be a bug. It returns every property for every medium (not just 'myprops') This one is tested and appears to work: SELECT m.MediumID AS id, IFNULL(MAX(pn.Text), '') AS name,

Re: [sqlite] GROUP BY in SQLite

Give each line a few extra spaces. I don't know why, but I had the same error. I gave a few extra spaces, specially at the end, and it worked just find... - Original Message - From: <[EMAIL PROTECTED]> To: Sent: Thursday, December 14, 2006 7:15 AM

[sqlite] ANN: SQLite Maestro 6.12 released

Hi All, SQL Maestro Group is happy to announce the release of SQLite Maestro 6.12, a powerful Windows GUI tool for SQLite databases administration and development. The new version is immediately available at http://www.sqlmaestro.com/products/sqlite/maestro/ Also we're happy to grant you a

Re: [sqlite] Transpose table

On Thu, 14 Dec 2006 09:53:22 - (GMT), you wrote: >Hi Denis, > >Yes, it is a one-off action and the only purpose is to present the data >into and Excel sheet in a more readable way. >I had done your suggestion in VBA, but I thought it was a bit slow >and wondered if there was a better way. If

Re: [sqlite] GROUP BY in SQLite

Hi Bart, First of all, you clearly try to start a new subject here, so please don't reply to something completely different, but start a new thread. TIA. On Thu, 14 Dec 2006 12:15:57 - (GMT), you wrote: >Just wondering about the implementation of GROUP BY in SQLite. >It looks I can do: >

RE: [sqlite] Transpose table

It's nice that problem was solved. JFYI. In common, task for creating sparse matrix from plain sql normalized table is very common for OLAP. Maybe you shall read something about it if these task arised from time to time. Best regards, Denis -Original Message- From: [EMAIL PROTECTED]

Re: [sqlite] disk I/O error writing files mounted via samba

Guy Hindell <[EMAIL PROTECTED]> wrote: > I would like to use sqlite (v3.3.8) on a linux box (fedora core 5) to > read/write a database file in a directory which is actually on a windows > share mounted via samba/cifs. I can open the file, and read from it, but > writing produces "disk I/O

Re: [sqlite] count up how much an free space on DB

Artem Yankovskiy <[EMAIL PROTECTED]> wrote: > Question, whether probably to count up how much an > free space there is in this a DB? > If the first byte of the database file is called byte 0, then bytes 16 and 17 form a 16-bit big-endian integer which is the number of bytes per page. Bytes

[sqlite] GROUP BY in SQLite

Just wondering about the implementation of GROUP BY in SQLite. It looks I can do: select field1, field2, field3 from table group by field1 and I will get the last row in the field1 group. This is fine and I can use that, but I thought that the SQL standard was that all non-aggregate fields

Re: [sqlite] Re: File Syste

At 22:03 13/12/2006, you wrote: I am developing a File System, and I'd like to use B+ Tree and not lost time and CPU understanding SQL... Check HFS(16/32 bits) and HFS+(64 bits) filesystems from Apple, they use B+ trees. The code is open source and you can find it on Darwin repository.

RE: [sqlite] Transpose table

Have tested this now and it seems to work fine. Faster as well than my old method. RBS > Hi Denis, > > Yes, it is a one-off action and the only purpose is to present the data > into and Excel sheet in a more readable way. > I had done your suggestion in VBA, but I thought it was a bit slow >

Re: [sqlite] building sqlite on windows in Unicode

Check the requirements in: http://www.sqlite.org/copyright.html for patches and other submissions to SQLite. This could be what is holding up inclusion of the patch. Christian Brodie Thiesfield uttered: Hi, Building sqlite on windows in Unicode mode broke with the addition of the loadable

RE: [sqlite] Transpose table

Hi Denis, Yes, it is a one-off action and the only purpose is to present the data into and Excel sheet in a more readable way. I had done your suggestion in VBA, but I thought it was a bit slow and wondered if there was a better way. I have just found a possible way to do this and maybe it is

[sqlite] count up how much an free space on DB

Hello. There is a DB. auto_vacuum is not used. One of tables of a database contains 500 records. We for example delete from it 300 records. The place in a database was released, but the size of a file has not decreased how is not set auto_vacuum. Question, whether probably to count up how much an