Re: [OSM-dev] database schema

2009-04-01 Thread Pierre-André Jacquod
Thanks to all for the answers. Shaun McDonald wrote: > > On 31 Mar 2009, at 17:29, Pierre-André Jacquod wrote: >> >> By the way, would it be possible to setup the internet page in order to >> see the date / time of file commit? As hint about the accuracy of the >> entry? > > http://trac.openstre

Re: [OSM-dev] database schema

2009-03-31 Thread Shaun McDonald
On 31 Mar 2009, at 17:29, Pierre-André Jacquod wrote: By the way, would it be possible to setup the internet page in order to see the date / time of file commit? As hint about the accuracy of the entry? http://trac.openstreetmap.org/browser/sites/rails_port_branches/api06/ Shaun_

Re: [OSM-dev] database schema

2009-03-31 Thread Iván Sánchez Ortega
El Martes, 31 de Marzo de 2009, Pierre-André Jacquod escribió: > [...] is true that the nodes will still keep the key/val tag > within the node's table as text DB column, and will not have a separated > table / entry for that? (I am speaking with API 0.6 [...]) I have a local installation of 0.6,

Re: [OSM-dev] database schema

2009-03-31 Thread Matt Amos
2009/3/31 Pierre-André Jacquod : > After some mapping, I am starting to have a look at the programming side > of OSM. Just a question about the Database. awesome :-) > If I understood what I read under SVN ( > http://svn.openstreetmap.org/sites/rails_port/db/migrate/  currently > Revision 14372)

[OSM-dev] database schema

2009-03-31 Thread Pierre-André Jacquod
Hi, After some mapping, I am starting to have a look at the programming side of OSM. Just a question about the Database. If I understood what I read under SVN ( http://svn.openstreetmap.org/sites/rails_port/db/migrate/ currently Revision 14372) and the wiki http://wiki.openstreetmap.org/wiki/Data

Re: [OSM-dev] Database Schema

2008-10-10 Thread Shaun McDonald
On 9 Oct 2008, at 14:56, Tom Hughes wrote: Shaun McDonald wrote: The api06 branch will check out fine :-) Especially now that I have added the classic_pagination plugin to svn directly, rather than having it access an out of date external. I should probably back port this change ASAP. ht

Re: [OSM-dev] Database Schema

2008-10-09 Thread Brett Henderson
Thanks for all the help. I now have a working rake installation and a database at version 15. I've installed the following gems. gem install -v=2.0.2 rails gem install libxml-ruby (produced a number of what appeared to be errors, hopefully not an issue) gem install -v=0.9.93 composite_primary_ke

Re: [OSM-dev] Database Schema

2008-10-09 Thread Tom Hughes
Shaun McDonald wrote: > The api06 branch will check out fine :-) > Especially now that I have added the classic_pagination plugin to svn > directly, rather than having it access an out of date external. I should > probably back port this change ASAP. > http://trac.openstreetmap.org/changeset/110

Re: [OSM-dev] Database Schema

2008-10-09 Thread Shaun McDonald
On 9 Oct 2008, at 14:24, Shaun McDonald wrote: [...] I've fixed the externals issue I had. That was dumb on my part. I checked out a few hours ago and forgot it failed due to external sites being down. I've used TomH's vendor.zip to get the external files. The api06 branch will check

Re: [OSM-dev] Database Schema

2008-10-09 Thread Shaun McDonald
On 9 Oct 2008, at 13:53, Brett Henderson wrote: MilesTogoe wrote: ruby and rails have gone thru some changes the past few months - you most likely need a newer gems package - try downloading the latest gems source and compiling that - then from the newer gems install the rails packages I curr

Re: [OSM-dev] Database Schema

2008-10-09 Thread Tom Hughes
Brett Henderson wrote: > I currently have rubygems 1.2.0. I see the latest is 1.3.0. I don't > know much about ruby. So should I upgrade to 1.3.0? I'd rather not > install from source unless I have to ... The version of rubygems you have is largely irrelevant - that is just the ruby package

Re: [OSM-dev] Database Schema

2008-10-09 Thread Brett Henderson
MilesTogoe wrote: > ruby and rails have gone thru some changes the past few months - you > most likely need a newer gems package - try downloading the latest > gems source and compiling that - then from the newer gems install the > rails packages I currently have rubygems 1.2.0. I see the late

Re: [OSM-dev] Database Schema

2008-10-09 Thread Tom Hughes
Brett Henderson wrote: > I haven't had much luck either. Does anybody have any suggestions on > where I've gone wrong below. > > I installed the following packages. > > yum install ruby ruby-devel ruby-irb ruby-libs ruby-rdoc ruby-ri rubygems > ruby-sqlite3 > yum install ruby-mysql ruby-postg

Re: [OSM-dev] Database Schema

2008-10-09 Thread MilesTogoe
Brett Henderson wrote: > Brett Henderson wrote: > >> Hi Sagar, >> >> I hope to get time to test this at home tonight but hopefully others >> have better answers in the meantime. >> >> These links might also help in the meantime: >> http://wiki.openstreetmap.org/index.php/The_Rails_Port >> http:

Re: [OSM-dev] Database Schema

2008-10-09 Thread Brett Henderson
Brett Henderson wrote: > > I haven't had much luck either. Does anybody have any suggestions on > where I've gone wrong below. > I suspect my errors have something to do with some missing externals. I better fix that before making any more noise and wasting anybody's time. ___

Re: [OSM-dev] Database Schema

2008-10-09 Thread Brett Henderson
Brett Henderson wrote: > Hi Sagar, > > I hope to get time to test this at home tonight but hopefully others > have better answers in the meantime. > > These links might also help in the meantime: > http://wiki.openstreetmap.org/index.php/The_Rails_Port > http://wiki.openstreetmap.org/index.php/Rai

Re: [OSM-dev] Database Schema

2008-10-08 Thread Brett Henderson
Hi Sagar, I hope to get time to test this at home tonight but hopefully others have better answers in the meantime. These links might also help in the meantime: http://wiki.openstreetmap.org/index.php/The_Rails_Port http://wiki.openstreetmap.org/index.php/Rails_on_Fedora Cheers, Brett On Thu, O

[OSM-dev] Database Schema

2008-10-08 Thread sagar anand
Hi All I am trying to replicate the database schema of openstreet map on MySQL server running on Fedora Ver 9. I am almost through to all stages but seems I am not getting the resolution for the last stage where it says rake db: migrate This was the first error I got: *Missing the Rails 2.0.2 g