similar to: adding sequences to postgresql DBMS via migration generator

Hello. I''m working the "proper way" with creating the initial db schema via migrations and db/schema.rb. However, I have a bit of a special need, and need to know if anyone knows the solution to this; I need a sequence that is common to several tables - a "data id" that gives a sort of unique object number to every row in every table. Some associated tables (a

I'm currently trying to do analysis on a 565k record database of Philadelphia's property assessments. I read the Data Import/Export .pdf and am still conflicted about which DBMS I should use to maintain reliability and ensure I don't crash while trying to do my calculations. Should I go with PostgreSQL for the option of Proxy Data Frames or should I go with MySQL for the "lean

Is there any way of preserving order of ordered factors when storing a table in PostgreSQL? I have been using PostgreSQL and the RPgSQL package to store a large table with answers such as "Strong disagreement", "Strong agreement", "Mild disagreement". "Mild agreement". When reading the table, such answers are turned into factors, apparently in

Hi R users, I am new to using DBMS with R for large datasets. Thanks to all who responded with useful suggestion to my earlier postings about using large datasets and DBMS with R. I am writing to get some help about how to design good tables in DBMS to take full advantage of the wonderful built-in facilities in R, like labels. I am using RMySQL client. Because R makes good use of variable

I'm using Samba to allow my users to store their database on a Redhat 6.1 file server. I've got some who want to shift to using Linux instead of Windows but the DBMS they use is not supported (yet... I'm told) on Linux and I'm afraid that multi-user access on different OS's are going to screw things all to high heck anyways... But that being said... Are there existing

How do I best migrate the data? For small databases I can text-edit the dump file from MySQL. The postgresql compatibility switch doesn''t help on mysqldump. Any ideas. Can MySQL export CSV that postgresql can import ? W Fred -------------- next part -------------- An HTML attachment was scrubbed... URL:

<PRE>I am looking for suggestions for a good Database Management System to use with R. The main use of this will be to format, query and make subsets of large datafiles for use in R. I recall reading a comparative write-up either in the newsletter, in the mails or someone's webpage last summer, but cant seem to find it now. I will be thankful if someone can help in locating such

Can anyone supply me with a simple, succinct explanation of what the difference is between the "new" controller and the "create" controller that the scaffold generator produces? I run: > script/generate scaffold modelname controllername And now I need to do some work inside the controllername.rb file. For example, pulling a list from another database table to supply

I am seeking to hire a hardware/software consultant to help me build a stem with a 64 bit OS, R, and a SQL-compatible DBMS. Please contact me if you know of anyone qualified. Details: I am in need of a robust system that will run R, and a SQL compatible database. I will be working with large datasets, and wish to take advantage of as much RAM as possible, and therefore think I should use a 64

Hi I'm a new user with Asterisk Realtime. I'm trying to write a web application in PHP that will show me asterisk *conf files configuration and that can help me to add/remove users/peers etc... I know that from asterisk 1.0.7 on (with cvs upload) asterisk configuration files can be managed trough aDBMS in my case Mysql. I'd want to know if someone knows how can I "map"

http://www.regdeveloper.co.uk/2008/02/18/stonebraker_dbms_outdated/ <quote> Stonebraker and his group also advocate abandoning SQL because they see no need for a separate data manipulation language. Data manipulation, they said, can be performed with other tasks using languages such as Ruby. </quote> -- There is nothing wrong with America that the faith, love of freedom,

hey all, I feel like I must be missing something rather plain, but I don't get it. how is one supposed to use R as a PgSQL client on Windows? Assume my windows desktop is on the same network as a PgSQL server, and I just need to use R to connect and pull down some data. The thing that is confusing me is that RODBC doesn't seem to know anything about PgSQL, in that

This might be a problem with postgresql, but I''m not sure. In a migration I have renamed a table so I wanted to rename a sequencer as well. It looks like: execute "ALTER TABLE global_vacations_id_seq RENAME TO vacations_id_seq;" execute "ALTER TABLE vacations ALTER COLUMN id SET DEFAULT nextval(''vacations_id_seq''::regclass);" But the process of

Hi R users, I am a beginner trying to connect to PostgreSQL using R When I give the following command drv<-dbDriver("PostgreSQL") I am getting the following error Error in do.call(as.character(drvName), list(...)) : could not find function "PostgreSQL" I have installed PostgreSQL 8.1 in my system. I am currently using R 2.3.1. Any help would be

I have a specific need to ''fixate'' my ''roles'' table sequence when migrating. at migration #4, I have 28 records in my roles tables and I can manually reset the roles_id_seq but it stands to reason that since I am doing everything else in the migration, I might as well reset the sequence there too. so I tried this in my migration file... execute

Dear Friends Greetings, i have a question for you, i am sure someone can help. The pfsense captive portal is up and running. Time countdown vouchers are working without issue, such as 30m, 45m, 1h & so on. However, I'd like to set up a download quota of 200MB per voucher. but then you need to login with a username and password, instead of vouchers. but I haven't found a way to

Hi, All I have so many files in my directory. I got the following error. At this time, I couldn't use debug() to check error one by one because so many files getting invloved. How can I get some idea about my error?? ..... Skipping book_log-20060222T143612.txt Skipping book_log-20060222T162828.txt Skipping book_log-20060222T162833.txt Skipping book_log-20060222T183742.txt Skipping

Hi every one How are you? after a days and searching in forums i still can not find some things that helping me to connect Rails with postgre SQL of course those are helpful but not for a stupid person like me :D So i need my friends helping me here and advice me to how can i connect this two things (ROR and Postgre Sql) I need your help so much My eyes going blind because of searching and

Hi, I have a sequence set up on one of my tables called seq_user_mytable. I tried the following with no joy: set_primary_key "user_id", :sequence => "seq_user_mytable" and: ActiveRecord::Base.seq_user_mytable again with no joy. How do I implement a sequence in Rails/ActiveRecord? -- Regards Andrew --~--~---------~--~----~------------~-------~--~----~ You received this

Hi all, Rails 1.0 Postgresql 8.1 Ruby 1.8.4 Is there a way to reset sequences in unit tests when loading fixture data? I came across mention of a "Fixtures.reset_sequences method here: http://api.rubyonrails.com/files/vendor/rails/activerecord/CHANGELOG.html However, when I tried to call Fixtures.reset_sequences in the setup method, I got a NoMethodError. Any ideas? Thanks, Dan