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 multi
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 fi
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 16
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 (SQLITE_IO
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 r
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 SQLi
What are our options to extend or change SQL syntax if needed?
Dusan
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
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,
IFNULL(MAX(
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
Subject: [sqlite] GROUP BY in SQ
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 ti
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
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:
>
>
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]
[mai
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 error"
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 36-39
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 should
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 (SQLITE_IOERR error code). I
can wri
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.
---
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
> and
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
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 fas
Hi RBS!
If I understood you correctly you need a tool to transform these data
just once?
So there is a pseudocode describing one of possible approaches. To
convenient transformation SQLite is not enough for me, I suggest to use
any script language like Lua, Ptython, etc.
1) With a statement
SELEC
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
23 matches
Mail list logo