Displaying 20 results from an estimated 4000 matches similar to: "Composite Primary Keys"
2006 Feb 18
14
Composite primary key support in ActiveRecord?
Hi,
As I understand, composite primary keys aren''t supported in
ActiveRecord yet. May I ask if there are plans for this feature?
Better yet, if this feature is under development, how''s the progress
going?
I''m not trying to use legacy databases. I tend to think that using
multiple integer column id''s (composite primary key) are often
natural way to
2009 May 26
0
rake db:schema:dump doesn't produce composite primary key instructions
Hey there,
I''ve adjusted some of my many to many join tables recently to use a
composite primary key based on the id''s in the two columns - instead
of using a surrogate key.
I just did a db:schema:dump, and it looks something like this:
create_table "class_members", :id => false, :force => true do |t|
t.integer "user_id", :default => 0,
2005 Dec 09
1
composite primary keys
Hello,
Is it true that Rails doesn''t support composite primary keys? I have a
legacy system and was pondering adding a new interface to it. This whole
Rails thing (and yes, Ruby too) seems pretty interesting but I''d feel
ashamed of myself adding an additional column called ''id'' when there''s
already a perfectly good composite key.
Assuming the rumors
2006 Jan 11
1
Composite primary key
Hi All,
How do I specify a composite primary key for a table in ActiveRecord?
For example the table Recipe which has the primary key [cookie id, version
number] where cookie id is also a foreign key referencing Cookie.
Also: Thanks to Nic and Adam for helping with the Cookie -> Cooky problem.
/Hugo
--SQL
*
CREATE* *TABLE* `Raw_Materials`*
(*
id *INT*
2006 Apr 03
4
How to fake composite primary keys?
I know ActiveRecord doesn''t support composite primary keys, but I need to use
one, and I need it ASAP. I don''t need any composite foreign keys, luckily;
what I have is a table that stores old versions of rows in another table, so
the composite key is an id + date stamp. Would someone tell me a hack I can
use to support this?
--
View this message in context:
2016 Mar 16
2
Index corruption in 2.2.18
We are using dbox with lz4 compression and dovecot-lda + sieve for delivery.
Mail recieved:
Mar 16 06:27:55 mail2 dovecot: lda(svs at example.com): sieve: msgid=<20160316032754.4C89D2C4 at rdbms.oldstable.office.example.com>: stored mail into mailbox 'INBOX'
Around 08:14:00 user start his thunderbird with local filters. He found one mail without headers.
Around that time user do
2006 Jun 21
1
about composite primary keys
hello,
what is the strategy you use for composite primary keys ?
I saw the solution proposed by Graham Glass ( ticket 3201) using a
set_composite_key..., but it seems it is not in AR ....(why ?)
thanks for feedback
arnaud
2004 Jul 02
1
reading large data
Hello,
I have trouble using read.table for flat files of larger than about
300MB on windows 2000. Any ideas of how to file a bug report? Is it a
known issue? I have three cuts of data, a 1%, 10% and 100% sample in
flat text files. The 100% sample is about 350MB. When I read the 1%
and 10% files, besides being slow, everything works. RAM footprint
appears to increase approximately 2x of text
2010 Aug 19
1
Composite primary keys and :joins=>
I have a legacy db with the following simplified structure:
Table-A:
type_key, code_key, name, ... # PKs are type_key and code_key,
there is no id col and I cannot alter this db
Table-B: # each row has only the code as a foreign_key, the type_key
is hard-coded to "FOOKEY"
an_id, code, ...
Models:
class TableB < AR::Base
set_table_name ''table_b''
2006 Apr 17
7
Should Perl talk to Rails via LWP
Hi folks,
I need your opinions on a basic design issue.
I''ve seen the light of RoR and have replaced my Perl (DBI/CGI) based web
server <-> RDBMS communication with RoR, but I still have a whole host
of users (other servers/OS''s etc) out there wanting to talk to my
RDBMS and they only talk Perl. Also they don''t want to talk Perl/DBI
directly (they are not allowed
2006 Aug 14
0
Composite Primary Keys - now works with Rails 1.1.6
Due to the foolish implied assumption that there''d never be a revision
to activerecord library, the Composite Primary Key code promptly broke
for anyone who updated their apps to Rails 1.1.6 (with its
activerecord-1.14.4)
Now the gem dependencies are fixed and your legacy databases are free to
wield composite primary keys without fear again.
Description:
Composite Primary Keys
2008 Apr 08
4
Practical Data Limitations with R
We are new to R and evaluating if we can use it for a project we need to
do. We have read that R is not well suited to handle very large data
sets. Assuming we have the data prepped and stored in an RDBMS (Oracle,
Teradata, SQL Server), what can R reasonably handle from a volume
perspective? Are there some guidelines on memory/machine sizing based
on data volume? We need to be able to handle
2006 Aug 02
0
Composite Primary Keys support for Associations
Announcement:
Composite Primary Keys gem now includes support for ActiveRecord
Associations.
Summary:
Composite Primary Keys allows an ActiveRecord to support 2+ primary keys
using the set_primary_keys class method. Previous versions provided full
CRUD and find support. This latest release provides support for more
ActiveRecord magic: associations (has_many, belongs_to, etc)
Full report:
2006 Dec 14
1
Actually what is the SQL DB used for?
Is a RDBMS required for Dovecot to run in small (SOHO) environments? (Does it store indexes to the mail, etc.?) Or is it strictly leveraged for larger-scale environments?
I'm asking, because the INSTALL says ./configure and make is enough for most...but as my previous post requested...there isn't anywhere that lists Required Packages/Software. We need to get that out there before 1.0RC
2006 Jul 23
0
Composite Primary Keys 0.3.2
ActiveRecords with composite primary keys now seem to happily support
find/create/update/destroy options.
Url: http://compositekeys.rubyforge.org
Background:
Rails/ActiveRecords has long been critised for not supporting legacy
databases, especially composite primary keys. This gem extends ARs with
this support.
Cheers
Nic
--
Posted via http://www.ruby-forum.com/.
2014 May 15
0
composite primary key - Rails 4.1
Hi,
I am facing issue with composite primary key
In my gem file I have the below entries -
gem 'rails', '>= 4.1.0.rc2'
gem 'mysql2'
gem 'rb-readline', "~> 0.5.1"
gem 'sdoc', '~> 0.4.0', group: :doc
gem 'spring', group: :development
gem 'bcrypt', '~> 3.1.7'
gem
2009 Aug 20
3
Wind-data analysis with R?
Hello,
are there people outside who use R for analysis of wind-measurement data
(meteorological or for planning of wind power stations)?
Are there already scripts/modules available for analysing and
displaying/plotting wind data in the way it is done in projection/planning
of wind power stations?
If not, would it be of interest to use R for this, and therefore
adapt data-logger output to R (by
2006 May 25
2
Best way to validate an integer field?
I am trying to validate an integer field called quantity. I don''t know
how to chack if it has gone beyond or below the maximum or minimum value
allowed by the Firebird RDBMS. I tired adding this code to the validate
method in the model:
if (quantity > -2147483648) and (quantity < 2147483648)
errors.add("quantity", "is out of range (must be between
2005 Nov 18
1
Can Dovecot work with an RDBMS for mail/attachment storage?
This may seem off the wall, but can dovecot be configured to support a
connection to a database server and use the database server to store the
e-mail message and its attachments?
While you can use Postgres and MySQL for storing and authenticating users,
there is a possibility to use an RDBMs to control the mail itself.
Thoughts?
--
Michael Segel
Principal
MSCC
2006 Jul 26
15
Rails without a primary key
I''ve been trying to use Rails on a database where the biggest
datawarehouse-style table doesn''t have a primary key. It really
doesn''t make sense and just adds extra unnecessary space. I do have,
however, a column that I normally use to search on (IP) that returns
many rows. The table also references several other tables through
rails-friendly foreign keys.
Simple AR