-Talkers:
I’ve been truly impressed by SQLite, a small database with support for much of
SQL-92. This is a swift, ACIDic, customizable database that could be useful
to a great many Ruby developers.
Looking around RAA, I found a few extensions for using SQLite, but very little
documentation. Distilling the SQLite documentation can be a lot to take in
at once, so I’ve started to collect my own experience into a quick guide for
the uninitiated.
http://whytheluckystiff.net/articles/2003/07/02/aQuickGuideToSQLite
I will continue to add to this page as I experiment. Thank you.
_why
Awesome!
But the page says “No Story Found”
Bummer!
-rich
···
On Wednesday, July 2, 2003, at 07:55 PM, why the lucky stiff wrote:
-Talkers:
I’ve been truly impressed by SQLite, a small database with support for
much of
SQL-92. This is a swift, ACIDic, customizable database that could be
useful
to a great many Ruby developers.
Looking around RAA, I found a few extensions for using SQLite, but
very little
documentation. Distilling the SQLite documentation can be a lot to
take in
at once, so I’ve started to collect my own experience into a quick
guide for
the uninitiated.
http://whytheluckystiff.net/articles/2003/07/02/aQuickGuideToSQLite
I will continue to add to this page as I experiment. Thank you.
_why
why the lucky stiff wrote:
-Talkers:
I’ve been truly impressed by SQLite, a small database with support for much of
SQL-92. This is a swift, ACIDic, customizable database that could be useful
to a great many Ruby developers.
Looks like version 5 of of PHP includes SQLite.
http://news.php.net/article.php?group=php.announce&article=40
Something to consider for Ruby?
Looking around RAA, I found a few extensions for using SQLite, but very little
documentation. Distilling the SQLite documentation can be a lot to take in
at once, so I’ve started to collect my own experience into a quick guide for
the uninitiated.
http://whytheluckystiff.net/articles/2003/07/02/aQuickGuideToSQLite
I will continue to add to this page as I experiment. Thank you.
No, thank you.
_james
···
_why
very cool. i used the package a bit using one extension - i can’t remember
which - and was getting alot of bizzare errors which would leave the ruby
object in an invalid state…
anyhow - this must certainly be the coolest embedable rdbms out there and
should be a good match for ruby. one thing i’ll comment on though - the
speeds are not quite what i’d hoped (or claimed) - not bad though.
something like this (perhaps just like this) distributed with ruby would be
simply unreal IMHO… having web and database packages standard with a
language is a powerful combo, especially an embedded database like sqlite;
i’ve been using pstore, cgi, and cgi::session::pstore (my own package) for
most of my web work since it makes moving an app to another server a simple
matter of tar/un-tar. sqlite also would have this advantage.
one other note - i’ve successfully used sqlite from different machines on an
nfs mounted db file. pretty cool…
enough rambles.
-a
···
On Thu, 3 Jul 2003, why the lucky stiff wrote:
-Talkers:
I’ve been truly impressed by SQLite, a small database with support for much of
SQL-92. This is a swift, ACIDic, customizable database that could be useful
to a great many Ruby developers.
Looking around RAA, I found a few extensions for using SQLite, but very little
documentation. Distilling the SQLite documentation can be a lot to take in
at once, so I’ve started to collect my own experience into a quick guide for
the uninitiated.
http://whytheluckystiff.net/articles/2003/07/02/aQuickGuideToSQLite
I will continue to add to this page as I experiment. Thank you.
–
Ara Howard
NOAA Forecast Systems Laboratory
Information and Technology Services
Data Systems Group
R/FST 325 Broadway
Boulder, CO 80305-3328
Email: ara.t.howard@noaa.gov
Phone: 303-497-7238
Fax: 303-497-7259
~ > ruby -e ‘p(%.\x2d\x29..intern)’
====================================
Biggest problem I have with ruby-dbi and Sqlite: if you set db[‘AutoCommit’]
= false, which is actually the default, then ruby-dbi keeps a transaction
open at all times. That is, it issues “begin transaction” as soon as the
database is opened, and then after a “commit” it issues another “begin
transaction” immediately.
SQLite locks the entire database when a transaction is in progress, and
therefore the database can only ever be seen by a single connection /
thread / process.
$ cat x.rb
#!/usr/local/bin/ruby
require ‘dbi’
a = DBI.connect(‘dbi:Sqlite:foobar’)
b = DBI.connect(‘dbi:Sqlite:foobar’)
$ ruby x.rb
/usr/local/lib/ruby/site_ruby/1.6/dbi/dbi.rb:567:in Connect': database is locked(database is locked) (DBI::DatabaseError) from /usr/local/lib/ruby/site_ruby/1.6/dbi/dbi.rb:567:in Connect’
from /usr/local/lib/ruby/site_ruby/1.6/dbi/dbi.rb:367:in `Connect’
from x.rb:5
Unfortunately it seems that ruby-dbi’s transaction support is broken (it has
a concept of ‘commit’ but not of ‘begin’) so it’s hard to fix this without
major surgery to ruby-dbi itself.
Regards,
Brian.
···
On Thu, Jul 03, 2003 at 08:55:45AM +0900, why the lucky stiff wrote:
I’ve been truly impressed by SQLite, a small database with support for much of
SQL-92. This is a swift, ACIDic, customizable database that could be useful
to a great many Ruby developers.
Rich, what browser are you in? I’m using a bit o’ mod_rewrite, so I’m
thinking this has to do with the path the browser is sending.
_why
···
Richard Kilmer (rich@infoether.com) wrote:
But the page says “No Story Found”
Saluton!
- Karl Lopes; 2003-07-03, 12:20 UTC:
unsubscribe
The mail header contains:
X-ML-Info: If you have a question, send e-mail with the body
“help” (without quotes) to the address ruby-talk-ctl@ruby-lang.org;
help=mailto:ruby-talk-ctl@ruby-lang.org?body=help
List-Post: mailto:ruby-talk@ruby-lang.org
List-Owner: mailto:ruby-talk-admin@ruby-lang.org
List-Help: mailto:ruby-talk-ctl@ruby-lang.org?body=help
List-Unsubscribe: mailto:ruby-talk-ctl@ruby-lang.org?body=unsubscribe
The problem is that many people do not know how or don’t even have a
chance to access that header information. Wouldn’t it be better to
append that information to the mail body?
That would reduce the probability of further such unsubscribe
messages.
Gis,
Josef ‘Jupp’ Schugt
···
–
Someone even submitted a fingerprint for Debian Linux running on the
Microsoft Xbox. You have to love that irony :).
– Fyodor on nmap-hackers@insecure.org
But the page says “No Story Found”
Rich, what browser are you in? I’m using a bit o’ mod_rewrite, so I’m
thinking this has to do with the path the browser is sending.
Doesn’t work for me, either, with either Safari 1.0 or IE 5.2.3 on Mac OS X.
It does work with Mozilla Firebird 0.6.
···
At 11:32 +0900 7/3/03, why the lucky stiff wrote:
Richard Kilmer (rich@infoether.com) wrote:
_why
I am using Safari 1.0 on OS X. I just checked the site though, and
everything appears to be good.
Thanks for doing this!
-rich
···
On Wednesday, July 2, 2003, at 10:32 PM, why the lucky stiff wrote:
Richard Kilmer (rich@infoether.com) wrote:
But the page says “No Story Found”
Rich, what browser are you in? I’m using a bit o’ mod_rewrite, so I’m
thinking this has to do with the path the browser is sending.
_why
On Thu, 3 Jul 2003 11:32:09 +0900, why the lucky stiff
ruby-talk@whytheluckystiff.net wrote (more or less):
But the page says “No Story Found”
Rich, what browser are you in? I’m using a bit o’ mod_rewrite, so I’m
thinking this has to do with the path the browser is sending.
_why
At 14:10 GMT, it worked for me on Opera 5.12 Build 932, on Win32
Thank you for writing this!
Cheers,
Euan
Gawnsoft: http://www.gawnsoft.co.sr
Symbian/Epoc wiki: http://html.dnsalias.net:1122
Smalltalk links (harvested from comp.lang.smalltalk) http://html.dnsalias.net/gawnsoft/smalltalk
···
Richard Kilmer (rich@infoether.com) wrote:
Paul DuBois wrote:
But the page says “No Story Found”
Rich, what browser are you in? I’m using a bit o’ mod_rewrite, so I’m
thinking this has to do with the path the browser is sending.
Doesn’t work for me, either, with either Safari 1.0 or IE 5.2.3
on Mac OS X.
It does work with Mozilla Firebird 0.6.
It works for me on Windows with IE6.
Curt
···
At 11:32 +0900 7/3/03, why the lucky stiff wrote:
Richard Kilmer (rich@infoether.com) wrote:
nor nutscrape 4.7x
at least, i simply get a white page with this as the source:
-a
···
On Thu, 3 Jul 2003, Paul DuBois wrote:
At 11:32 +0900 7/3/03, why the lucky stiff wrote:
Richard Kilmer (rich@infoether.com) wrote:
But the page says “No Story Found”
Rich, what browser are you in? I’m using a bit o’ mod_rewrite, so I’m
thinking this has to do with the path the browser is sending.
Doesn’t work for me, either, with either Safari 1.0 or IE 5.2.3 on Mac OS X.
It does work with Mozilla Firebird 0.6.
–
Ara Howard
NOAA Forecast Systems Laboratory
Information and Technology Services
Data Systems Group
R/FST 325 Broadway
Boulder, CO 80305-3328
Email: ara.t.howard@noaa.gov
Phone: 303-497-7238
Fax: 303-497-7259
~ > ruby -e ‘p(%.\x2d\x29..intern)’
====================================
“Curt Hibbs” curt@hibbs.com wrote in message news:INEGJNJOFAMNDPNEABNEEECHHAAA.curt@hibbs.com…
Paul DuBois wrote:
But the page says “No Story Found”
Rich, what browser are you in? I’m using a bit o’ mod_rewrite, so I’m
thinking this has to do with the path the browser is sending.
Doesn’t work for me, either, with either Safari 1.0 or IE 5.2.3
on Mac OS X.
It does work with Mozilla Firebird 0.6.
It works for me on Windows with IE6.
Curt
works too in Mozilla 1.3 on win2000
Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.3) Gecko/20030312
seems to work to on IE 6?(not sure 'cos I pasted the link from mozilla
mail)
mmmh could you add some info on using binary data in sqlite? whenever
you get around that!
thanks
···
At 11:32 +0900 7/3/03, why the lucky stiff wrote:
Richard Kilmer (rich@infoether.com) wrote:
This is now supplied as well. Although, I believe there is much more that
could be explored on the topic.
http://whytheluckystiff.net/articles/2003/07/02/aQuickGuideToSQLite
_why
···
On Thursday 03 July 2003 03:48 am, Osuka wrote:
mmmh could you add some info on using binary data in sqlite? whenever
you get around that!
Anyone got a prebuilt binary of sqlite-ruby for Windows? I can’t build the
thing, and all this talk about it has made me curious.
Thanks,
David.
···
-----Original Message-----
From: why the lucky stiff [mailto:ruby-talk@whytheluckystiff.net]
This is now supplied as well. Although, I believe there is much
more that
could be explored on the topic.
http://whytheluckystiff.net/articles/2003/07/02/aQuickGuideToSQLite
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.491 / Virus Database: 290 - Release Date: 18/06/2003
Anyone got a prebuilt binary of sqlite-ruby for Windows? I can’t build the
thing, and all this talk about it has made me curious.
Thanks,
David.
A binary for windows would be nice indeed, but telling how to compile
it myself would be even better, windows+mingw+msys, extconf says “no”
to all so no makefile! I found a patch, but haven’t tried it(eternal
question: will it work on windows?).
!warning! OT: seriously, it seems I’ll have to install freebsd or
linux and get a real modem to forget windows “how to compile” and
“with what compiler[none included thank you!!]” blues. I’ll try
freebsd since I’ve used linux before.
And thanks mmh ¿_why? for adding info regarding binary(blobs)!!!