Does Ruby has any default database with it?

Ruby
1

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

2

Normally sqlite is the go to being that it’s the default of rails. Check
into sequel.

3

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

4

Colby C. 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,

5

On Wed, Jan 30, 2013 at 10:54 AM, Colby C.
[email protected] 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.

Also, MagLev has built-in object persistence, but it’s still at 1.8.7.

6

Hassan S. wrote in post #1094424:

On Wed, Jan 30, 2013 at 10:54 AM, Colby C.
[email protected] 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

7

On Wed, Jan 30, 2013 at 11:10 AM, Arup R. [email protected]
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 all :slight_smile:

Good luck.

8

http://sequel.rubyforge.org/

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.

9

Hassan S. wrote in post #1094429:

On Wed, Jan 30, 2013 at 11:10 AM, Arup R. [email protected]
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 all :slight_smile:

Good 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

10

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 S. <

11

Michael Strauss-Cassel wrote in post #1094434:

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 S. <

Didn’t get your point @Strauss

12

On Wed, Jan 30, 2013 at 12:07 PM, Justin C.
[email protected]wrote:

Ruby comes with several database-like libraries in the standard lib: dbm,
gdbm, YAML::DBM, pstore

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

13

On 01/30/2013 10:21 AM, Arup R. 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, pstore

Outside of Ruby, sqlite is probably the easiest to get started with if
you are already familiar with SQL.

-Justin

14

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.

15

Brandon W. 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. :slight_smile:

16

On Thu, 2013-01-31 at 03:21 +0900, Arup R. 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.

17

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.

18

Tony A. wrote in post #1094436:

On Wed, Jan 30, 2013 at 12:07 PM, Justin C.
[email protected]wrote:

Ruby comes with several database-like libraries in the standard lib: dbm,
gdbm, YAML::DBM, pstore

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

Yes,bug Ruby : SDBM documentation is not good. Only list of method
mentioned,but not a single example with them.

19

On 01/30/2013 12:27 PM, Arup R. wrote:

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.

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

20

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.