similar to: Database Modeller (Mac)

For a really long time, I''ve been using DBDesigner from FabForce.net. For those of your who''ve never used it, its a freeware visual entity-relationship diagram tool, which allows you to make database designs visually instead of in SQL DDL. You can then use it to generate the SQL to make your databse design into reality, or even run a "synchronize" to make any

I''ve written a simple Rails migration that adds an index to an existing Postgres table: class AddIndexToEvents < ActiveRecord::Migration > def change > add_index :sf_events, :account_id > end > end However, when I run the migration, it fails due to a syntax error on the CREATE INDEX line. I''m expecting some SQL like this to be generated: CREATE INDEX

Hi! It seems that migration doesn''t use single transcation to execute the needed migrations for the database upgrade, so if I have database at version 5, and I wrote some migrations 6..10, and error occurs while executing migration 7, the database stays in state 6? I also think that migration taks could use some more verbosity, for example if migration fails, there''s no

Hello all, I am curious about what tools you guys use to make your databases. I know David uses CocoaMySQL. Are there other tools for other platforms and for other databases? I''m not very good with the SQL language, so I would like being able to do all my database setup with an easy-to-use tool (defining tables, fields, primary keys, foreign keys, indexes, etc.) Big kisses, Vincent.

Hi all, Can I safely assume that each migration is excuted within a transaction, so that''s it''s safe to have migrations executing failing statements? Thanks, - Rowan -- Morality is usually taught by the immoral.

Hi All I am trying to understand if I can use migrations to migrate data under the following conditions 1. Across 2 different databases (Oracle/DB2) with same schemas. 2. Across 2 different databases (Oracle/DB2) with different schemas. I am trying to avoid writing DBI/OCI8 scripts. Can somone please shed some light if this is even possible? thanks -daya -------------- next part

I read in various places that although migrations aren''t transactional, all you need to do is wrap you migration method in "ActiveRecord:: Base.connection.transaction do" to make the self.up or self.down transactional. In my experience (Rails + PostgreSQL), this doesn''t work very well. If my migration hits an exception, any tables that were touched remain modified.

HI R users, I would appreciate information/examples/suggestions on building GUIs for R applications. I am currently working on a project that would require the following functionalities : 1) Display a window to the user. Provide a function to scan local drive and choose dataset file. 2) Display the column names for the user to choose the dependent variable and the independent variables. 3) Fit

Hi all I have a new migration file created that adds some tables and fills one with some data: create_table :sound_styles do |t| t.column :name, :string, :null => false end create_table :show_types do |t| t.column :name, :string, :null => false end create_table :countries do |t| t.column :name, :string, :null => false end ActionView::Helpers::FormOptionsHelper::COUNTRIES.each

Just wondering if there''s a way to use migrations to generate join tables (where the table columns comprise only of foreign keys to other tables, and where the primary key is all the foreign keys taken together). I made the changes manually in MySQL, then did rake db_schema_dump and it gave something like this: create_table "apples_oranges", :id => false, :force

I am getting a bug building Cygwin on latest SVN :- llvm[1]: Compiling Process.cpp for Debug build In file included from /home/ang/git/workbench/lib/System/Process.cpp:29: /home/ang/git/workbench/lib/System/Unix/Process.inc: In function 'unsigned int g etColumns(int)': /home/ang/git/workbench/lib/System/Unix/Process.inc:209: error: aggregate 'winsi ze ws' has incomplete type and

Hi list, I have hacked together a small script to generate an ActiveRecord model from a DBDesigner 4 (fabForce.net) model file. Take it apart and feed it to the pigs ;). the article: http://tua.ch/ruby/current.html and the script: http://tua.ch/ruby/dbmodel/compute_model.rb best of whishes for the new year, kaspar code manufacture & ruby lab at http://www.tua.ch/ruby

I have button that slides down a menu using Effect.BlindDown, but the function that slides it down also makes it so that the opening link now slides the menu back in. If the user double clicks the link (thuse opening & closing immediatley) the slide animation breaks, then will not extend correctly (but no JS errors). How would you go about stopping this happening? Also, is it just me or is

Are there any XML databinding frameworks available for Ruby / Rails, such as Castor or JaXB for Java? Also are there framework such as Apache Axis for WebServices for Rails or Ruby? Regards, Harm de Laat -------------- next part -------------- An HTML attachment was scrubbed... URL: http://wrath.rubyonrails.org/pipermail/rails/attachments/20060310/3cf0cfd3/attachment.html

Hi, I'm trying to use StatEt IDE for Eclipse as my R editor, but I'm completely lost. I've read all I could find online, made apparently all I had to do (installing rj, configuraing StatEt, etc.) but still cannot make R running. Below is the error log file. Thank you so much for assistance. Matteo !ENTRY de.walware.statet.r.console.ui 1 0 2011-12-05 16:21:51.355 !MESSAGE

On May 15, 2009, at 11:03 AM, Aaron Gray wrote: > I am getting a bug building Cygwin on latest SVN :- > > llvm[1]: Compiling Process.cpp for Debug build > In file included from /home/ang/git/workbench/lib/System/Process.cpp: > 29: > /home/ang/git/workbench/lib/System/Unix/Process.inc: In function > 'unsigned int g > etColumns(int)': >

I''ve upgraded to Rails 1.1.2, and I''m trying to push this change through to our build server (Linux/Oracle) and we are getting some errors in the unit tests using Oracle. Looking at the data in the tests reveals a precision problem. Looking at the tables tells the whole story. My development database contains this table: SQL> describe dls_grids; Name

----- Original Message ----- From: Douglas Gregor To: LLVM Developers Mailing List Sent: Friday, May 15, 2009 7:24 PM Subject: Re: [LLVMdev] [Cygwin] bug on SVN On May 15, 2009, at 11:03 AM, Aaron Gray wrote: I am getting a bug building Cygwin on latest SVN :- llvm[1]: Compiling Process.cpp for Debug build In file included from

Hi all, Rails 1.1.4 Rake 0.7.1 PostgreSQL 8.1.4 Windows XP Pro I checked for errata on pragmaticprogrammer.com, but didn''t see any explicit mention of this issue. I''m going over the depot example in AWDwR, 2nd ed, and I can''t get the migration to work on p. 82. Specifically, the AddTestData example (with reduced description text to save my fingers some typing):

Hi, I''m a real newbie both in Rails and Ubuntu but I''m going to learn Ruby on Rails for a schoolproject. I''ve tried to find out what IDE is best according to different tutorials and blogs and have chosen to download easyeclipse-ruby-rails-1.2.2.2.tar.gz. My problem is that when i start the program an error popup is shown: "An error has occurred. See the log file.