I will do webpage scraping using Ruby and required Gems. But looking for
a capable database into which I can store the data,which I will fetch
from the script.
Thus asking if Ruby has any inbuilt one or suggest me if any open-source
DB,which is capable with Ruby?
Thanks
--
Posted via http://www.ruby-forum.com/.
Normally sqlite is the go to being that it's the default of rails. Check
into sequel.
On Jan 30, 2013 12:22 PM, "Arup Rakshit" <lists@ruby-forum.com> wrote:
I will do webpage scraping using Ruby and required Gems. But looking for
a capable database into which I can store the data,which I will fetch
from the script.Thus asking if Ruby has any inbuilt one or suggest me if any open-source
DB,which is capable with Ruby?Thanks
--
Posted via http://www.ruby-forum.com/\.
Ruby comes with several database-like libraries in the standard lib: dbm, gdbm, YAML::DBM, pstore
Outside of Ruby, sqlite is probably the easiest to get started with if you are already familiar with SQL.
-Justin
On 01/30/2013 10:21 AM, Arup Rakshit wrote:
I will do webpage scraping using Ruby and required Gems. But looking for
a capable database into which I can store the data,which I will fetch
from the script.Thus asking if Ruby has any inbuilt one or suggest me if any open-source
DB,which is capable with Ruby?Thanks
PostgreSQL or Sqlite would be what I'd recommend.
sqlite would be the easiest to get up and running with.
On Thu, 2013-01-31 at 03:21 +0900, Arup Rakshit wrote:
I will do webpage scraping using Ruby and required Gems. But looking for
a capable database into which I can store the data,which I will fetch
from the script.Thus asking if Ruby has any inbuilt one or suggest me if any open-source
DB,which is capable with Ruby?Thanks
Doesn't Rails come with a built in database called Brick? No additional
set up required. Supposed to be out of the box I believe.
Colby
On Wed, Jan 30, 2013 at 10:23 AM, Brandon Weaver <keystonelemur@gmail.com>wrote:
Normally sqlite is the go to being that it's the default of rails. Check
into sequel.
On Jan 30, 2013 12:22 PM, "Arup Rakshit" <lists@ruby-forum.com> wrote:I will do webpage scraping using Ruby and required Gems. But looking for
a capable database into which I can store the data,which I will fetch
from the script.Thus asking if Ruby has any inbuilt one or suggest me if any open-source
DB,which is capable with Ruby?Thanks
--
Posted via http://www.ruby-forum.com/\.
Hey look at that, finally someone with the right answer.
See also: SDBM
However which of these are available will depend on your Ruby
implementation, unfortunately
On Wed, Jan 30, 2013 at 12:07 PM, Justin Collins <justincollins@ucla.edu>wrote:
Ruby comes with several database-like libraries in the standard lib: dbm,
gdbm, YAML::DBM, pstore
--
Tony Arcieri
Though if you don't know raw SQL you're in for some troubles. Study sql and
play with it for a while before you try making anything expansive. One
hours planning is worth 10 hours of frustrated coding.
On Jan 30, 2013 2:08 PM, "Justin Collins" <justincollins@ucla.edu> wrote:
On 01/30/2013 10:21 AM, Arup Rakshit wrote:
I will do webpage scraping using Ruby and required Gems. But looking for
a capable database into which I can store the data,which I will fetch
from the script.Thus asking if Ruby has any inbuilt one or suggest me if any open-source
DB,which is capable with Ruby?Thanks
Ruby comes with several database-like libraries in the standard lib: dbm,
gdbm, YAML::DBM, pstoreOutside of Ruby, sqlite is probably the easiest to get started with if you
are already familiar with SQL.-Justin
Colby Callahan wrote in post #1094420:
Doesn't Rails come with a built in database called Brick? No additional
set up required. Supposed to be out of the box I believe.Colby
But I need with Ruby 1.9.3. I am not a ROR developer.
Thanks,
--
Posted via http://www.ruby-forum.com/\.
No, you might be thinking about WEBrick, the web server that's a
default Rails component, but that's totally irrelevant to the OP's
question.
To the OP: you can use MySQL, SQLite, PostgreSQL, etc.
Also, MagLev has built-in object persistence, but it's still at 1.8.7.
On Wed, Jan 30, 2013 at 10:54 AM, Colby Callahan <colby.callahan@gmail.com> wrote:
Doesn't Rails come with a built in database called Brick? No additional set
up required. Supposed to be out of the box I believe.
--
Hassan Schroeder ------------------------ hassan.schroeder@gmail.com
twitter: @hassan
Brandon Weaver wrote in post #1094437:
Though if you don't know raw SQL you're in for some troubles. Study sql
and
play with it for a while before you try making anything expansive. One
hours planning is worth 10 hours of frustrated coding.
@Brandon - I am 3 years of experienced with Oracle Sql,PL-sql. So Sql is
not a big deal for me. The worried point is, which database should I
choose. 
--
Posted via http://www.ruby-forum.com/\.
Tony Arcieri wrote in post #1094436:
On Wed, Jan 30, 2013 at 12:07 PM, Justin Collins > <justincollins@ucla.edu>wrote:
Ruby comes with several database-like libraries in the standard lib: dbm,
gdbm, YAML::DBM, pstoreHey look at that, finally someone with the right answer.
See also: SDBM
However which of these are available will depend on your Ruby
implementation, unfortunately
Yes,bug Ruby : SDBM documentation is not good. Only list of method
mentioned,but not a single example with them.
--
Posted via http://www.ruby-forum.com/\.
Hassan Schroeder wrote in post #1094424:
On Wed, Jan 30, 2013 at 10:54 AM, Colby Callahan > <colby.callahan@gmail.com> wrote:
Doesn't Rails come with a built in database called Brick? No additional set
up required. Supposed to be out of the box I believe.No, you might be thinking about WEBrick, the web server that's a
default Rails component, but that's totally irrelevant to the OP's
question.To the OP: you can use MySQL, SQLite, PostgreSQL, etc.
@Hassan
Are all of the above - "MySQL, SQLite, PostgreSQL" open-source? Any good
documentation to use with "SQLite, PostgreSQL" would you like to prefer?
Thanks
--
Posted via http://www.ruby-forum.com/\.
Making sure. You can never tell some times.
Sqlite is good for quick databases, MySQL for midrange, and postgre seems
to be getting a lot of credit for large but I haven't personally used it.
On Jan 30, 2013 2:26 PM, "Arup Rakshit" <lists@ruby-forum.com> wrote:
Brandon Weaver wrote in post #1094437:
> Though if you don't know raw SQL you're in for some troubles. Study sql
> and
> play with it for a while before you try making anything expansive. One
> hours planning is worth 10 hours of frustrated coding.@Brandon - I am 3 years of experienced with Oracle Sql,PL-sql. So Sql is
not a big deal for me. The worried point is, which database should I
choose.--
Posted via http://www.ruby-forum.com/\.
Geez, how could I forget SDBM???
So actually there is documentation, but it's not showing up on ruby-docs.org or rdoc.info.
-Justin
On 01/30/2013 12:27 PM, Arup Rakshit wrote:
Tony Arcieri wrote in post #1094436:
On Wed, Jan 30, 2013 at 12:07 PM, Justin Collins >> <justincollins@ucla.edu>wrote:
Ruby comes with several database-like libraries in the standard lib: dbm,
gdbm, YAML::DBM, pstoreHey look at that, finally someone with the right answer.
See also: SDBM
However which of these are available will depend on your Ruby
implementation, unfortunatelyYes,bug Ruby : SDBM documentation is not good. Only list of method
mentioned,but not a single example with them.
Fairly sure MySQL and Sqlite are OS. Then again, much more than that and
you really should be googling for documentation to these types of things.
On Wed, Jan 30, 2013 at 1:10 PM, Arup Rakshit <lists@ruby-forum.com> wrote:
Hassan Schroeder wrote in post #1094424:
> On Wed, Jan 30, 2013 at 10:54 AM, Colby Callahan > > <colby.callahan@gmail.com> wrote:
>> Doesn't Rails come with a built in database called Brick? No
additional set
>> up required. Supposed to be out of the box I believe.
>
> No, you might be thinking about WEBrick, the web server that's a
> default Rails component, but that's totally irrelevant to the OP's
> question.
>
> To the OP: you can use MySQL, SQLite, PostgreSQL, etc.@Hassan
Are all of the above - "MySQL, SQLite, PostgreSQL" open-source? Any good
documentation to use with "SQLite, PostgreSQL" would you like to prefer?Thanks
--
Posted via http://www.ruby-forum.com/\.
Yes. Really, the choice depends on your use case(s), platform, and
personal preference so I'd just try them all
Good luck.
On Wed, Jan 30, 2013 at 11:10 AM, Arup Rakshit <lists@ruby-forum.com> wrote:
Are all of the above - "MySQL, SQLite, PostgreSQL" open-source?
--
Hassan Schroeder ------------------------ hassan.schroeder@gmail.com
twitter: @hassan
I think the best course for a new project is to start simple, go with
sqlite, if you find you need more performance or some particular
feature, bump up to postgresql. mysql is pretty common, but there are
concerns about its future under oracle. That said, there's no shortage
of opinions everywhere.
The Sequel gem is probably a good place to start, since it sounds like
you're well of in SQL programming:
Even with that, it can take a bit to understand the Ruby that goes
around it, so I'd suggest experimenting a bit, do some prototypes to
figure out what you need, throw them away and then design, write your
tests, then write your app code.
Hassan Schroeder wrote in post #1094429:
On Wed, Jan 30, 2013 at 11:10 AM, Arup Rakshit <lists@ruby-forum.com> > wrote:
Are all of the above - "MySQL, SQLite, PostgreSQL" open-source?
Yes. Really, the choice depends on your use case(s), platform, and
personal preference so I'd just try them allGood luck.
I need 4 tables with more or less 40,000 rows in each,which must be
capable of producing report data as export in excel or CSV. Need to run
all kind of SQl queries into it,to get rows.
Thanks
--
Posted via http://www.ruby-forum.com/\.
what good is your help hasan if you are going to complain about it
rails comes with sqllite < it is official, but you can set easily any
dataengine you like
sql lite is the gig
On Wed, Jan 30, 2013 at 2:24 PM, Hassan Schroeder < hassan.schroeder@gmail.com> wrote:
On Wed, Jan 30, 2013 at 11:10 AM, Arup Rakshit <lists@ruby-forum.com> > wrote:
>
> Are all of the above - "MySQL, SQLite, PostgreSQL" open-source?Yes. Really, the choice depends on your use case(s), platform, and
personal preference so I'd just try them allGood luck.
--
Hassan Schroeder ------------------------ hassan.schroeder@gmail.com
Hassan Schroeder | about.me
twitter: @hassan
tamouse mailing lists wrote in post #1094655:
I think the best course for a new project is to start simple, go with
sqlite, if you find you need more performance or some particular
feature, bump up to postgresql. mysql is pretty common, but there are
concerns about its future under oracle. That said, there's no shortage
My concern is - Does "Sqllite3" capable of storing 30000 rows in each
table? I will use it in my internal projects.
Thanks
--
Posted via http://www.ruby-forum.com/\.