Rails - Jan 2005 - DB Intro / Table Design book - article recommendations?

Hi

I am new to playing with rails and web app building. I was wondering
if anyone had any recommendations on any decent books or online
tutorials / articles about DB usage, SQL, Table design and what not.

Thanks in advance.

Rob

On Sat, Jan 08, 2005 at 09:25:59PM +0000, Robert McGovern
wrote:
> I am new to playing with rails and web app building. I was wondering
> if anyone had any recommendations on any decent books or online
> tutorials / articles about DB usage, SQL, Table design and what not.
> 
> Thanks in advance.
Philip Greenspun has a few free books on his site about SQL and web apps.

this is one on sql basics:
http://philip.greenspun.com/sql/

this is one on internet applications with sql:
http://philip.greenspun.com/seia/

this is the complete list:
http://philip.greenspun.com/books/

There are probably loads of more rigorous books online but these are
probably sufficient primers.

As far as I remember most it''s all Oracle but Oracle is pretty similar
to
some other SQL''s, e.g. Postgresql.

marcel
-- 
Marcel Molina Jr. <marcel-WRrfy3IlpWYdnm+yROfE0A@public.gmane.org>

If you''re looking for database design as opposed to SQL, i highly
recommend the Handbook of Relational Database Design.

http://www.bookswelike.net/isbn/0201114348

It''s worth reading something about database design which is seperate
from a sql how to book, as many sql books don''t tell you how to design
your database or what your best practices should be.

-rabble

On Sat, 8 Jan 2005 16:31:31 -0500, Marcel Molina Jr.
<marcel-WRrfy3IlpWYdnm+yROfE0A@public.gmane.org>
wrote:
> On Sat, Jan 08, 2005 at 09:25:59PM +0000, Robert McGovern wrote:
> > I am new to playing with rails and web app building. I was wondering
> > if anyone had any recommendations on any decent books or online
> > tutorials / articles about DB usage, SQL, Table design and what not.
> >
> > Thanks in advance.
> 
> Philip Greenspun has a few free books on his site about SQL and web apps.
> 
> this is one on sql basics:
> http://philip.greenspun.com/sql/
> 
> this is one on internet applications with sql:
> http://philip.greenspun.com/seia/
> 
> this is the complete list:
> http://philip.greenspun.com/books/
> 
> There are probably loads of more rigorous books online but these are
> probably sufficient primers.
> 
> As far as I remember most it''s all Oracle but Oracle is pretty
similar to
> some other SQL''s, e.g. Postgresql.
> 
> marcel
> --
> Marcel Molina Jr. <marcel-WRrfy3IlpWYdnm+yROfE0A@public.gmane.org>
> _______________________________________________
> Rails mailing list
> Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org
> http://lists.rubyonrails.org/mailman/listinfo/rails
>

- Robert McGovern :
> Hi
> 
> I am new to playing with rails and web app building. I was wondering
> if anyone had any recommendations on any decent books or online
> tutorials / articles about DB usage, SQL, Table design and what not.
> 
> Thanks in advance.
I''d suggest books from Chris Date or Fabian Pascal: look at
http://www.dbdebunk.com/books.html.
They are _hard_ to grasp, but also correct, and I really can''t say the 
same thing for other books I''ve read on the argument. They provide a
really solid foundation and IMHO are the best place to start.

HTH,
  ngw
-- 
checking for life_signs in -lKenny... no
	Oh my god, make (1) killed Kenny ! You, bastards !

nicholas_wieland-at-yahoo-dot-it

Just wanted to say thanks Marcel, evan and Nicholas I shall look into
all your suggestions.

To answer your question Evan, I am more interested in DB design as
using Rails seems to mean I can forgo worrying about SQL for the
moment but I do want to understand how best to build tables and the
relationships between them.

Rob
-- 
Personal responsibility is battling extinction.

Continuing to work with my RubyGems install issues, I setup a fresh 
installation of Ubuntu Linux to test it out.  All the latest Ubuntu 
packages are installed ("hoary") with the available ruby packages 
(ruby1.8-dev, ruby1.8, libruby1.8, libruby1.8-d).  I''ve attempted to 
install RubyGems, but get "No such file to load -- rubygems/builder 
(LoadError)".  The full output is listed below.  I believe this is 
related to my other problems on a sgi-solaris machine, if I could figure 
out a fix for this than I may be able to fix those as well.  Thanks for 
any help or suggestions any one has to offer.  This is a very 
frustrating problem that''s affecting me in multiple environments and I 
have no idea where to start with it.

root@tabby:~/rubygems-0.8.4 # ruby -v
ruby 1.8.2 (2004-12-23) [i386-linux]
root@tabby:~/rubygems-0.8.4 # ruby setup.rb
---> bin
<--- bin
---> lib
---> lib/rubygems
<--- lib/rubygems
<--- lib
---> bin
<--- bin
---> lib
---> lib/rubygems
<--- lib/rubygems
<--- lib
rm -f InstalledFiles
---> bin
mkdir -p /usr/bin/
install generate_yaml_index.rb /usr/bin/
install update_rubygems /usr/bin/
install gem_server /usr/bin/
install gem /usr/bin/
<--- bin
---> lib
mkdir -p /usr/local/lib/site_ruby/1.8/
install rubygems.rb /usr/local/lib/site_ruby/1.8/
install ubygems.rb /usr/local/lib/site_ruby/1.8/
---> lib/rubygems
mkdir -p /usr/local/lib/site_ruby/1.8/rubygems
install timer.rb /usr/local/lib/site_ruby/1.8/rubygems
install specification.rb /usr/local/lib/site_ruby/1.8/rubygems
install source_index.rb /usr/local/lib/site_ruby/1.8/rubygems
install old_format.rb /usr/local/lib/site_ruby/1.8/rubygems
install command.rb /usr/local/lib/site_ruby/1.8/rubygems
install custom_require.rb /usr/local/lib/site_ruby/1.8/rubygems
install installer.rb /usr/local/lib/site_ruby/1.8/rubygems
install validator.rb /usr/local/lib/site_ruby/1.8/rubygems
install remote_installer.rb /usr/local/lib/site_ruby/1.8/rubygems
install config_file.rb /usr/local/lib/site_ruby/1.8/rubygems
install gem_runner.rb /usr/local/lib/site_ruby/1.8/rubygems
install format.rb /usr/local/lib/site_ruby/1.8/rubygems
install open-uri.rb /usr/local/lib/site_ruby/1.8/rubygems
install rubygems_version.rb /usr/local/lib/site_ruby/1.8/rubygems
install loadpath_manager.rb /usr/local/lib/site_ruby/1.8/rubygems
install doc_manager.rb /usr/local/lib/site_ruby/1.8/rubygems
install builder.rb /usr/local/lib/site_ruby/1.8/rubygems
install cmd_manager.rb /usr/local/lib/site_ruby/1.8/rubygems
install package.rb /usr/local/lib/site_ruby/1.8/rubygems
install version.rb /usr/local/lib/site_ruby/1.8/rubygems
install gem_commands.rb /usr/local/lib/site_ruby/1.8/rubygems
install user_interaction.rb /usr/local/lib/site_ruby/1.8/rubygems
<--- lib/rubygems
<--- lib

As of RubyGems 0.8.0, library stubs are no longer needed.
Searching $LOAD_PATH for stubs to optionally delete (may take a while)...
...done.
No library stubs found.

/usr/local/lib/site_ruby/1.8/rubygems/custom_require.rb:26:in
`require'':
No such file to load -- rubygems/builder (LoadError)
       from /usr/local/lib/site_ruby/1.8/rubygems.rb:58:in
`manage_gems''
       from /root/rubygems-0.8.4/./post-install.rb:63:in
`install_sources''
       from /root/rubygems-0.8.4/./post-install.rb:74:in
`instance_eval''
       from setup.rb:583:in `instance_eval''
       from setup.rb:583:in `try_run_hook''
       from setup.rb:577:in `run_hook''
       from setup.rb:1315:in `exec_task_traverse''
       from setup.rb:1168:in `exec_install''
       from setup.rb:887:in `exec_install''
       from setup.rb:705:in `invoke''
       from setup.rb:674:in `invoke''
       from setup.rb:1352
root@tabby:~/rubygems-0.8.4 #

Thanks again,
Trevor

This seems to be a bug related to the newest version of RubyGems.  I''m
getting it on Win32 as well.

Bill

On Mon, 10 Jan 2005 10:42:31 -0600, Trevor
<wenn0029-6BTuCrPg42A3uPMLIKxrzw@public.gmane.org>
wrote:
> Continuing to work with my RubyGems install issues, I setup a fresh
> installation of Ubuntu Linux to test it out.  All the latest Ubuntu
> packages are installed ("hoary") with the available ruby packages
> (ruby1.8-dev, ruby1.8, libruby1.8, libruby1.8-d).  I''ve attempted
to
> install RubyGems, but get "No such file to load -- rubygems/builder
> (LoadError)".  The full output is listed below.  I believe this is
> related to my other problems on a sgi-solaris machine, if I could figure
> out a fix for this than I may be able to fix those as well.  Thanks for
> any help or suggestions any one has to offer.  This is a very
> frustrating problem that''s affecting me in multiple environments
and I
> have no idea where to start with it.
> 
> root@tabby:~/rubygems-0.8.4 # ruby -v
> ruby 1.8.2 (2004-12-23) [i386-linux]
> root@tabby:~/rubygems-0.8.4 # ruby setup.rb
> ---> bin
> <--- bin
> ---> lib
> ---> lib/rubygems
> <--- lib/rubygems
> <--- lib
> ---> bin
> <--- bin
> ---> lib
> ---> lib/rubygems
> <--- lib/rubygems
> <--- lib
> rm -f InstalledFiles
> ---> bin
> mkdir -p /usr/bin/
> install generate_yaml_index.rb /usr/bin/
> install update_rubygems /usr/bin/
> install gem_server /usr/bin/
> install gem /usr/bin/
> <--- bin
> ---> lib
> mkdir -p /usr/local/lib/site_ruby/1.8/
> install rubygems.rb /usr/local/lib/site_ruby/1.8/
> install ubygems.rb /usr/local/lib/site_ruby/1.8/
> ---> lib/rubygems
> mkdir -p /usr/local/lib/site_ruby/1.8/rubygems
> install timer.rb /usr/local/lib/site_ruby/1.8/rubygems
> install specification.rb /usr/local/lib/site_ruby/1.8/rubygems
> install source_index.rb /usr/local/lib/site_ruby/1.8/rubygems
> install old_format.rb /usr/local/lib/site_ruby/1.8/rubygems
> install command.rb /usr/local/lib/site_ruby/1.8/rubygems
> install custom_require.rb /usr/local/lib/site_ruby/1.8/rubygems
> install installer.rb /usr/local/lib/site_ruby/1.8/rubygems
> install validator.rb /usr/local/lib/site_ruby/1.8/rubygems
> install remote_installer.rb /usr/local/lib/site_ruby/1.8/rubygems
> install config_file.rb /usr/local/lib/site_ruby/1.8/rubygems
> install gem_runner.rb /usr/local/lib/site_ruby/1.8/rubygems
> install format.rb /usr/local/lib/site_ruby/1.8/rubygems
> install open-uri.rb /usr/local/lib/site_ruby/1.8/rubygems
> install rubygems_version.rb /usr/local/lib/site_ruby/1.8/rubygems
> install loadpath_manager.rb /usr/local/lib/site_ruby/1.8/rubygems
> install doc_manager.rb /usr/local/lib/site_ruby/1.8/rubygems
> install builder.rb /usr/local/lib/site_ruby/1.8/rubygems
> install cmd_manager.rb /usr/local/lib/site_ruby/1.8/rubygems
> install package.rb /usr/local/lib/site_ruby/1.8/rubygems
> install version.rb /usr/local/lib/site_ruby/1.8/rubygems
> install gem_commands.rb /usr/local/lib/site_ruby/1.8/rubygems
> install user_interaction.rb /usr/local/lib/site_ruby/1.8/rubygems
> <--- lib/rubygems
> <--- lib
> 
> As of RubyGems 0.8.0, library stubs are no longer needed.
> Searching $LOAD_PATH for stubs to optionally delete (may take a while)...
> ...done.
> No library stubs found.
> 
> /usr/local/lib/site_ruby/1.8/rubygems/custom_require.rb:26:in
`require'':
> No such file to load -- rubygems/builder (LoadError)
>        from /usr/local/lib/site_ruby/1.8/rubygems.rb:58:in
`manage_gems''
>        from /root/rubygems-0.8.4/./post-install.rb:63:in
`install_sources''
>        from /root/rubygems-0.8.4/./post-install.rb:74:in
`instance_eval''
>        from setup.rb:583:in `instance_eval''
>        from setup.rb:583:in `try_run_hook''
>        from setup.rb:577:in `run_hook''
>        from setup.rb:1315:in `exec_task_traverse''
>        from setup.rb:1168:in `exec_install''
>        from setup.rb:887:in `exec_install''
>        from setup.rb:705:in `invoke''
>        from setup.rb:674:in `invoke''
>        from setup.rb:1352
> root@tabby:~/rubygems-0.8.4 #
> 
> Thanks again,
> Trevor
> _______________________________________________
> Rails mailing list
> Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org
> http://lists.rubyonrails.org/mailman/listinfo/rails
> 

-- 
$stdout.sync = true
"Just another Ruby hacker.".each_byte do |b|
  (''a''..''z'').step do|c|print
c+"\b";sleep 0.007 end;print b.chr
end; print "\n"

Bill Atkins wrote:
>This seems to be a bug related to the newest version of RubyGems. 
I''m
>getting it on Win32 as well.
>
>Bill
>  
>
That''s (sort of) great news!  It means I''m not crazy after
all.

Trevor