Does Ruby has any default database with it?

Ruby
21

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

22

Subject: Re: Does Ruby has any default database with it?
Date: Fri 01 Feb 13 12:30:50PM +0900

Quoting Arup R. ([email protected]):

My concern is - Does “Sqllite3” capable of storing 30000 rows in each
table? I will use it in my internal projects.

If you want to adopt a database engine, you’d better read some of the
documentation that comes with it. For example, look at the last item
in this page:

http://www.sqlite.org/limits.html

(I will add that a database engine that cannot not handle 30000
records would have very limited applications)

Carlo

23

Carlo E. Prelz wrote in post #1094684:

Subject: Re: Does Ruby has any default database with it?
Date: Fri 01 Feb 13 12:30:50PM +0900

Quoting Arup R. ([email protected]):

My concern is - Does “Sqllite3” capable of storing 30000 rows in each
table? I will use it in my internal projects.

If you want to adopt a database engine, you’d better read some of the

@Carlo :

Thank you very much! That’s the information I was looking from you like
experienced people.

24

On Fri, Feb 1, 2013 at 7:50 AM, Arup R. [email protected]
wrote:

@Carlo :

Thank you very much! That’s the information I was looking from you like
experienced people.

If it’s just 30,000 items then Marshal or PStore might do as well. If
the whole data set easily fits into memory that would probably be the
easiest choice. Sample:

$ time ruby -e ‘h={};30_000.times {|i|
h[i]=10.times.map(&:to_s)};t=Time.now;File.open(“x”,“wb”){|io|Marshal.dump(h,
io)};puts(Time.now-t)’
0.3430196

real 0m0.597s
user 0m0.452s
sys 0m0.124s

Kind regards

robert

25

On Thu, Jan 31, 2013 at 11:50 PM, Robert K.
[email protected]wrote:

If it’s just 30,000 items then Marshal or PStore might do as well

Note PStore really sucks because it rewrites the entire database every
single time you mutate it. It’s about the most brain dead persistence
model
ever.

26

On Fri, Feb 1, 2013 at 9:50 AM, Tony A. [email protected]
wrote:

On Thu, Jan 31, 2013 at 11:50 PM, Robert K. [email protected]
wrote:

If it’s just 30,000 items then Marshal or PStore might do as well

Note PStore really sucks because it rewrites the entire database every
single time you mutate it. It’s about the most brain dead persistence model
ever.

It’s a tool. There are use cases where it’s appropriate and others
where it’s not. That has nothing to do with “brain dead”. The
approach to serialize objects is actually quite common in various
programming languages.

Cheers

robert

27

On Thu, Jan 31, 2013 at 9:30 PM, Arup R. [email protected]
wrote:

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.

It might depend on how many tables, how many fields in each table, and
how much information is in each field, being used in a single
application. That said, sqlite is quite capable. Where sqlite tends to
fall down is when you have very complex relationships between tables
with many inserts/updates; and THAT said, that’s where most databases
start to degrade in performance anyway, unless you’re really good at
designing them AND understand how to do the SQL.

28

On Fri, 2013-02-01 at 12:30 +0900, Arup R. wrote:

My concern is - Does “Sqllite3” capable of storing 30000 rows in each
table? I will use it in my internal projects.

easily.