headers
Douglas McCarroll | 1 Apr 2008 02:56

Re: When I try to .read I get a "can't open" message

Thanks all! Yes, dropping the semicolon fixed it...

On Mon, Mar 31, 2008 at 6:11 PM, Kees Nuyt <k.nuyt@...> wrote:

>  On Mon, 31 Mar 2008 17:11:35 -0400, you wrote:
>
> >I'm sure I'm doing something simple and obvious wrong here. I'm a
> complete
> >sqlite n00b.
> >
> >Help?
> >
> >C:\_source>sqlite3 test
> >SQLite version 3.5.7
> >Enter ".help" for instructions
> >sqlite> .read test.sql;
> >can't open "test.sql;"
> >sqlite> .read C:/_source/test.sql;
> >can't open "C:/_source/test.sql;"
>
> Drop the semicolon, .read is not an SQL statement.
> --
>  (  Kees Nuyt
>  )
> c[_]
>  _______________________________________________
> sqlite-users mailing list
> sqlite-users@...
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
(Continue reading)

Permalink | Reply | 0 comments |
headers
Dimitri | 1 Apr 2008 03:43

Re: DBD::SQLite::Amalgamation?

Hi,

> [...]
>>  t/06error...............ok 1/2
>>
>>  (this never finishes)
> 
> well, look in the t directory for the specific test. In my case, I see
> the following --
> [...]
> my $db = DBI->connect('dbi:SQLite:foo', '', '', { RaiseError => 1,

I'm not certain what the call to DBI->connect() does exactly, I understand it 
creates a database called 'foo' in the current directory. Is the current 
directory mounted through NFS?

--
Dimitri
_______________________________________________
sqlite-users mailing list
sqlite-users@...
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Permalink | Reply | 0 comments |
headers
Richard Klein | 1 Apr 2008 04:00

mem5 ("buddy system") usable?

I just downloaded 3.5.7, and noticed that there is a
new memory allocator mem5.c, which apparently uses the
"buddy system" to allocate power-of-two-sized chunks
of memory from a static pool.  This allocator is used
by defining SQLITE_POW2_MEMORY_SIZE.

Is it okay to use this allocator, or is it only exper-
imental (and therefore liable to disappear in a future
release)?

Thanks,
- Richard Klein
_______________________________________________
sqlite-users mailing list
sqlite-users@...
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Permalink | Reply | 3 comments |
headers
Joanne Pham | 1 Apr 2008 04:02
Picon
Favicon

create index with allow duplicate row

Hi All,
Is sqlite3 allow to create the index(non-cluster index) with an option allow duplicate row
Thanks,
JL

      ____________________________________________________________________________________
You rock. That's why Blockbuster's offering you one month of Blockbuster Total Access, No Cost.  
http://tc.deals.yahoo.com/tc/blockbuster/text5.com
_______________________________________________
sqlite-users mailing list
sqlite-users@...
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Permalink | Reply | 1 comment |
headers
D. Richard Hipp | 1 Apr 2008 05:04

Re: mem5 ("buddy system") usable?


On Mar 31, 2008, at 10:00 PM, Richard Klein wrote:
> I just downloaded 3.5.7, and noticed that there is a
> new memory allocator mem5.c, which apparently uses the
> "buddy system" to allocate power-of-two-sized chunks
> of memory from a static pool.  This allocator is used
> by defining SQLITE_POW2_MEMORY_SIZE.
>
> Is it okay to use this allocator, or is it only exper-
> imental (and therefore liable to disappear in a future
> release)?
>

I'm not making any promises about any of the current five
memory allocators.  I might decide to replace them all tomorrow.

But mem5 is high on the list of memory allocators to keep
since it can, under some circumstances, guarantee not to
fragment memory, which is a desirable property for
embedded systems.

D. Richard Hipp
drh@...

_______________________________________________
sqlite-users mailing list
sqlite-users@...
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
(Continue reading)

Permalink | Reply | 2 comments |
headers
Igor Tandetnik | 1 Apr 2008 05:06
Favicon

Re: create index with allow duplicate row

"Joanne Pham" <joannekpham@...>
wrote in message news:414519.46213.qm@...
> Is sqlite3 allow to create the index(non-cluster index) with an
> option allow duplicate row

Yes. Just don't use UNIQUE option in your CREATE INDEX statement.

Igor Tandetnik 

_______________________________________________
sqlite-users mailing list
sqlite-users@...
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Permalink | Reply | 0 comments |
headers
rahed | 1 Apr 2008 10:17
Picon

Re: DBD::SQLite::Amalgamation?

On 3/31/08, Jim Dodgen <jim@...> wrote:

> It makes ok, here is the output from "make test". the hang is after
>  "t/06error" it never finishes
>
>  DBD-SQLite-Amalgamation-3.5.7
>
>  # make test
>  PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e"
>  "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
>  t/00basic...............ok
>  t/01logon...............ok
>  t/02cr_table............ok
>  t/03insert..............ok
>  t/04select..............ok
>  t/05tran................ok
>  t/06error...............ok 1/2
>
>  (this never finishes)

In the beginnig there are unlink and connect commands in t/06 which
were successful in previous tests. So something may go wrong with eval
of the do test which should throw an error in $ <at> . You could step in
with the debugger to see where's the fault.

--

-- 
Radek
_______________________________________________
sqlite-users mailing list
sqlite-users@...
(Continue reading)

Permalink | Reply | 0 comments |
headers
L B | 1 Apr 2008 11:14
Picon
Favicon

Re: sqlite-users Digest, Vol 3, Issue 99

Hi Dennis, may be I understand now.
  I have enabled mail delivery in my sqlite users account options (which was not enabled before), now I should
receive all messages so that I can reply to one of them.

  May be it was my problem, because I have never received any message from sqlite user mailing list.

  Thanks for your patience and your help,

  LB

sqlite-users-request@... wrote:
  Send sqlite-users mailing list submissions to
sqlite-users@...

To subscribe or unsubscribe via the World Wide Web, visit
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
or, via email, send a message with subject or body 'help' to
sqlite-users-request@...

You can reach the person managing the list at
sqlite-users-owner@...

When replying, please edit your Subject line so it is more specific
than "Re: Contents of sqlite-users digest..."

Today's Topics:

1. Re: Scope of sqlite3_changes(), how to reset it? (Igor Tandetnik)
2. Re: DBD::SQLite::Amalgamation? (rahed)
3. Re: DBD::SQLite::Amalgamation? (Jim Dodgen)
(Continue reading)

Permalink | Reply | 0 comments |
headers
Vladimir Volkov | 1 Apr 2008 15:11
Picon

Trigger's actions and callbacks


Hi, all.

I have the following problem: I have some  processes that access the same db
file. When one of them would change some data inside the db it must notify
all other processes about change AND send them changed data (or it's unique
description).

But I didn't find any method to perform this using db triggers or callbacks.
On some certain reasons I am not allowed to write wrapper that will send
notifications using IPC. I would like db to perform this task.

As for triggers and callbacks (hooks): they are fired before the data is
stored to the db (file), so that I coudn't even read changed data back
inside hook. sqlite_update_hook() returnes rowID, but I didn't find any API
to use this value...

I would appriciate any ideas or comments.
Thanks in advance.
--

-- 
View this message in context: http://www.nabble.com/Trigger%27s-actions-and-callbacks-tp16418413p16418413.html
Sent from the SQLite mailing list archive at Nabble.com.

_______________________________________________
sqlite-users mailing list
sqlite-users@...
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Permalink | Reply | 7 comments |
headers
Igor Tandetnik | 1 Apr 2008 15:33
Favicon

Re: Trigger's actions and callbacks

"Vladimir Volkov"
<volodymyr.volkov@...> wrote in
message news:16418413.post@...
> I have the following problem: I have some  processes that access the
> same db file. When one of them would change some data inside the db
> it must notify all other processes about change AND send them changed
> data (or it's unique description).
>
> But I didn't find any method to perform this using db triggers or
> callbacks.

Correct. SQLite is not an interprocess communication mechanism. You will 
have to come up with your own scheme, outside SQLite.

> On some certain reasons I am not allowed to write wrapper
> that will send notifications using IPC.

You mean, you need to perform IPC but you are not allowed to write code 
that performs IPC? That's quite a corner you are painted into.

> I would like db to perform
> this task.

Then I guess SQLite is not suitable for your problem (though I can't 
think of any other DBMS that can do that, either).

> As for triggers and callbacks (hooks): they are fired before the data
> is stored to the db (file), so that I coudn't even read changed data
> back inside hook.
(Continue reading)

Permalink | Reply | 5 comments |

Gmane