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 likesql lite is the gig
On Wed, Jan 30, 2013 at 2:24 PM, Hassan Schroeder <
Didn't get your point @Strauss
--
Posted via http://www.ruby-forum.com/\.
Quoting Arup Rakshit (lists@ruby-forum.com):
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
Subject: Re: Does Ruby has any default database with it?
Date: Fri 01 Feb 13 12:30:50PM +0900
--
* Se la Strada e la sua Virtu' non fossero state messe da parte,
* K * Carlo E. Prelz - fluido@fluido.as che bisogno ci sarebbe
* di parlare tanto di amore e di rettitudine? (Chuang-Tzu)
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.
On Thu, Jan 31, 2013 at 9:30 PM, Arup Rakshit <lists@ruby-forum.com> 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 shortageMy concern is - Does "Sqllite3" capable of storing 30000 rows in each
table? I will use it in my internal projects.
easily.
On Fri, 2013-02-01 at 12:30 +0900, Arup Rakshit wrote:
My concern is - Does "Sqllite3" capable of storing 30000 rows in each
table? I will use it in my internal projects.
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 +0900Quoting Arup Rakshit (lists@ruby-forum.com):
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.
--
Posted via http://www.ruby-forum.com/\.
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
On Fri, Feb 1, 2013 at 7:50 AM, Arup Rakshit <lists@ruby-forum.com> wrote:
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 +0900Quoting Arup Rakshit (lists@ruby-forum.com):
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.
--
remember.guy do |as, often| as.you_can - without end
http://blog.rubybestpractices.com/
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.
On Thu, Jan 31, 2013 at 11:50 PM, Robert Klemme <shortcutter@googlemail.com>wrote:
If it's just 30,000 items then Marshal or PStore might do as well
--
Tony Arcieri
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
On Fri, Feb 1, 2013 at 9:50 AM, Tony Arcieri <tony.arcieri@gmail.com> wrote:
On Thu, Jan 31, 2013 at 11:50 PM, Robert Klemme <shortcutter@googlemail.com> > 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.
--
remember.guy do |as, often| as.you_can - without end
http://blog.rubybestpractices.com/