Re: [Dbix-class] (no subject)

2021-05-20 Thread Darren Duncan
On 2021-05-20 6:49 a.m., jjn1056 wrote: Dbix Looks like someone got hacked. -- Darren Duncan ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx

Re: [Dbix-class] Static / reference data

2018-08-22 Thread Darren Duncan
o maintain? Leaving it as is might be the best solution. -- Darren Duncan ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Arc

Re: [Dbix-class] Twitter accounts

2018-01-31 Thread Darren Duncan
thers project in the community, is that fair to the other projects? -- Darren Duncan ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Sear

Re: [Dbix-class] Avé! Duci Novo, Similis Duci Seneci!*

2018-01-23 Thread Darren Duncan
in general like it were controlled by The Perl Foundation, but DBIC is the only project there. And yet following the DBIC on CPAN pod website->downloads link eventually reaches that. -- Darren Duncan ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/

Re: [Dbix-class] VOTE: Relinquish firstcome rights to Peter Rabbitson

2018-01-17 Thread Darren Duncan
I agree. Since the current running vote results are strongly in favor of dropping the rationale for voting, I'd say this one has no time limits but that we still have the 3 days as a minimum. -- Darren Duncan On 2018-01-17 2:34 PM, John Napiorkowski wrote: Karen's points are well ta

[Dbix-class] subject/content matching re VOTE: Relinquish firstcome rights to Peter Rabbitson

2018-01-17 Thread Darren Duncan
ase explain how. -- Darren Duncan ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk

Re: [Dbix-class] VOTE: Relinquish firstcome rights to Peter Rabbitson

2018-01-17 Thread Darren Duncan
I vote +1 in favor of DBIx::Class namespace firstcome rights and full control being turned over to Peter Rabbitson. Right now that seems the best available path to a good outcome for DBIC. -- Darren Duncan ___ List: http://lists.scsys.co.uk/cgi-bin

Re: [Dbix-class] PROPOSAL: Relinquish firstcome rights to Peter Rabbitson

2018-01-16 Thread Darren Duncan
the stored procedures in Perl is useful. But even if I didn't feel that way, DBIC currently feels like a dead project that I don't feel would get any decent support. Bottom line, I support Matthew's proposal, but not strongly enough to be the proposal seconder, because I make

Re: [Dbix-class] PROPOSAL: merging Haarg's patch and making it easier to do simple merges / emergency fixes

2018-01-13 Thread Darren Duncan
I propose that distinct proposals from now on are submitted in separate email threads and have independent votes. John, do you want to do that with these two (and also with the subject-to I previously mentioned)? -- Darren Duncan On 2018-01-13 9:25 PM, Karen Etheridge wrote: I vote yes on

Re: [Dbix-class] PROPOSAL: merging Haarg's patch and making it easier to do simple merges / emergency fixes

2018-01-13 Thread Darren Duncan
phase vote passes..." to the beginning. That way we can basically have both of these votes completed in a 3 day span rather than unnecessarily taking a 6 day span. -- Darren Duncan ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo

Re: [Dbix-class] VOTE: Removing bootstrap phase

2018-01-13 Thread Darren Duncan
I vote +1. ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk

Re: [Dbix-class] PROPOSAL: merging Haarg's patch and making it easier to do simple merges / emergency fixes

2018-01-12 Thread Darren Duncan
e presumably also carrying a vote of the list members. Otherwise we'll have a failure of the constitution right out of the gate. -- Darren Duncan On 2018-01-12 8:25 AM, John Napiorkowski wrote: Two proposals for the governing committee First proposal: Haarg proposed a small and obvious fix he

Re: [Dbix-class] Proposed: DBIx::Class fork

2017-09-04 Thread Darren Duncan
Personally I think its best to just shelve any discussion related to forks until after Neil Bowers and Andreas Koenig have done their PAUSE namespace revisions, and thus more things are known rather than speculative. In that spirit, I retract my previous question. -- Darren Duncan On 2017-09

Re: [Dbix-class] Proposed: DBIx::Class fork

2017-09-04 Thread Darren Duncan
subject line (proposed...fork), are you just proposing that Github/etc be the primary release mechanism for DBIx::Class rather than CPAN, or are you proposing a third fork (the existing 2 being the one Peter controls and the one Matt's governanc

Re: [Dbix-class] Strangely does DBIx change table names from MySQL?

2017-03-10 Thread Darren Duncan
rson ($db->people) { print $person->name, $person->age } And so, DBIC would ideally name any classes/objects/variables representing a single person as Person while any representing a collection would be People, which is the behavior that "code first" Entity Framework def

[Dbix-class] Feature planning - DBP (was Re: Orders of Business)

2017-01-24 Thread Darren Duncan
s://github.com/muldis/Muldis-DBP-Perl6 I had previously discussed this effort here: http://www.nntp.perl.org/group/perl.dbi.dev/2016/11/msg8002.html I will post on this again when I have something ready to execute. -- Darren Duncan ___ List: http:

Re: [Dbix-class] Governance: Proposal A is adopted

2016-12-08 Thread Darren Duncan
Dec 2016 10:41:15 +0100 and Tue, 06 Dec 2016 20:07:48 +0300 respectively). 5. All of the other votes were for Proposal A, meaning a solid 52 votes. Therefore Proposal A carried by 52+ to 2 to 1 or 95%. I would consider the voter participation rate to be quite high, which is great. -- Darren

Re: [Dbix-class] Rights

2016-12-05 Thread Darren Duncan
ll be volunteering my services in Michigan to review marks on optical scan ballots and decide if bubbles were filled out all the way or not. ;-) Also, we got an "Abstain" which despite starting with the letter "A" is clearly not intending to vote for the first proposal. -- Darr

Re: [Dbix-class] ★ VOTE NOW: DBIC Governance and Namespace Control ★

2016-12-05 Thread Darren Duncan
I choose Proposal A. -- Darren Duncan On 2016-12-04 10:15 PM, David Golden wrote: * PROPOSAL A: Primary permissions for DBIx::Class and related namespaces shall be managed under the amended DBIC community governance structure proposed by Matt Trout. Decisions about the future development of

Re: [Dbix-class] Decision time: which fork inherits the existing DBIx::Class namespace

2016-12-03 Thread Darren Duncan
;t really want a mono-culture situation. As good as DBIx::Class or Rose::DB or etc are, there is always room for a new entry to come out that is better than either. -- Darren Duncan ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-clas

Re: [Dbix-class] Decision time: which fork inherits the existing DBIx::Class namespace

2016-12-03 Thread Darren Duncan
proposal. Assuming Peter's on-install trick can work both ways, we have room in the future to revisit what "cpan DBIx::Class" resolves to in the future, but for now I propose MST's gets it. -- Darren Duncan ___ List: http://lists.s

Re: [Dbix-class] Moving Forward

2016-11-19 Thread Darren Duncan
that's ok. -- Darren Duncan On 2016-11-18 8:53 PM, Chase Whitener wrote: Hi Everyone, It seems this is a good time to make a formal request to get the ball rolling, so to speak. This issue has been formally going on since September and we're now more than half-way through November. B

Re: [Dbix-class] An answer and a question

2016-11-13 Thread Darren Duncan
nfrastructure under the control of somebody who thinks "email your managing director to threaten your employer" is an acceptable way to make somebody back down from an argument? I would be interested to see Peter address this, in particular, to either affirm o

Re: [Dbix-class] PROPOSAL: Governance and sustainability

2016-11-08 Thread Darren Duncan
ss out. So 1 week is then also neutral to what day of the week that a vote is called as far as how it affects or is affected by people's schedules, assuming say 99% of people are oriented around 7-day cycles. -- Darren Duncan ___ List: http

Re: [Dbix-class] Please don't try to start voting yet

2016-11-08 Thread Darren Duncan
On 2016-11-08 1:05 PM, Matt S Trout wrote: On Mon, Nov 07, 2016 at 10:42:38PM -0800, Darren Duncan wrote: Here's an idea. In the spirit of your proposal, how about when the discussion seems to be over and it seems time to vote, either Matt or Peter would propose that a vote occurs, wit

Re: [Dbix-class] Please don't try to start voting yet

2016-11-07 Thread Darren Duncan
s to be over and it seems time to vote, either Matt or Peter would propose that a vote occurs, with the VOTE email etc, and then the other one of those two would second it if they agree, at which point the vote happens. -- Darren Duncan ___ List: ht

Re: [Dbix-class] PROPOSAL: Governance and sustainability

2016-11-07 Thread Darren Duncan
;s upcoming one. -- Darren Duncan ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/g

Re: [Dbix-class] GOVERNANCE: Aggregation and conclusion

2016-11-07 Thread Darren Duncan
It is important to realize that the current governance issue under discussion is actually more akin to trademark rights than copying rights, in a sense; it is about who has the canonical privilege for the NAME "DBIx::Class" within the context of PAUSE/CPAN. -- Darren Duncan On 201

Re: [Dbix-class] GOVERNANCE: Aggregation and conclusion

2016-11-02 Thread Darren Duncan
urely there are names for this. Thank you. -- Darren Duncan ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.gro

Re: [Dbix-class] GOVERNANCE: Aggregation and conclusion

2016-10-31 Thread Darren Duncan
s unchanged. I see that as a main complicating factor. Applications, not so much; if they want stability, Peter's version should serve them; if they want substantial changes or new features that more likely may be in the fork, they would have to be changed a

Re: [Dbix-class] IMPORTANT: A discussion of DBIC governance and future development

2016-10-23 Thread Darren Duncan
s should always get the "safe" option by default and explicitly opt-in to risk, rather than the opposite. This assumes the use of multiple namespaces, and is inapplicable if only one name is used. -- Darren Duncan ___ List: http://lists.s

Re: [Dbix-class] IMPORTANT: A discussion of DBIC governance and future development

2016-10-23 Thread Darren Duncan
lved further, at all. His plan, as far as i saw it stated, was to remove all other accesses and hand FIRSTCOME over to an unnamed successor who would handle things. AFAIK, Riba said he would be available to answer technical questions by whomever takes on the DBIC management, and that AFAIK this

Re: [Dbix-class] GOVERNANCE: An actually concrete proposal w/bootstrap governance system

2016-10-18 Thread Darren Duncan
be changed without holding up the other stuff. As an initial followup, I propose talking with the remainder of Peter's EXAMPLE preferred core team, those not also in Matt's list, namely HAARG and SYSPETE in that order, and see if they would be interested in

Re: [Dbix-class] Alternative proposals proposal

2016-10-13 Thread Darren Duncan
I support either of these team proposals, assuming the prospective members agree. -- Darren Duncan On 2016-10-13 1:42 PM, Peter Rabbitson wrote: It was suggested elsewhere I am against any "core team" plan. This is entirely false. As an *EXAMPLE* (I have not spoken to either of the

Re: [Dbix-class] IMPORTANT: A discussion of DBIC governance and future development

2016-10-12 Thread Darren Duncan
On 2016-10-12 12:14 AM, Hartmaier Alexander wrote: On 2016-10-06 21:15, Darren Duncan wrote: On 2016-10-06 8:43 AM, Matt S Trout wrote: On Tue, Oct 04, 2016 at 08:17:49PM -0700, Darren Duncan wrote: That would be good, also in light with how that sentence continues: "I suspect what we

Re: [Dbix-class] Let's call things what they are 2/2

2016-10-11 Thread Darren Duncan
nd thank you for all your work over the years. -- Darren Duncan ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive:

Re: [Dbix-class] A slightly more concrete proposal

2016-10-08 Thread Darren Duncan
On 2016-10-08 2:33 PM, Peter Rabbitson wrote: I have been battling a severe cold, and can't manage to write sufficiently clear prose. I hope to have David's questions addressed by Monday However I need to unambiguously address the following right now: On 10/08/2016 09:33 PM, Dar

Re: [Dbix-class] A slightly more concrete proposal

2016-10-08 Thread Darren Duncan
would help address the elephant in the room, the unknown person element. Thank you in advance. -- Darren Duncan ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos

[Dbix-class] CPAN release requested (was Re: Traffic pattern changes ahead)

2016-10-07 Thread Darren Duncan
On 2016-10-07 1:34 PM, Darren Duncan wrote: On 2016-10-07 10:08 AM, Peter Rabbitson wrote: master (dc7d89911b) itself is *in a fully releasable state*. It passes its extensive CI checks. It has also been tested against downstream dependencies extensively as indicated in the commit message of

Re: [Dbix-class] Traffic pattern changes ahead

2016-10-07 Thread Darren Duncan
en if not all of them. That being said, I say more power to you where you want to write/commit the other pieces that you would prefer to ship, particularly the warnings. Thanks again for all your work over the years, DBIC users are better for it. -- Dar

Re: [Dbix-class] A slightly more concrete proposal

2016-10-06 Thread Darren Duncan
ply to projects like DBIC for whom the option of stability is paramount. For that matter, I think the multiple release branch scenario is common and important enough that C4 should be updated to explicitly support that as an option. -- Darren Duncan On 2016-10-06 10:07 AM, fREW Schmidt wrote:

Re: [Dbix-class] A slightly more concrete proposal

2016-10-06 Thread Darren Duncan
7;ve had for the last decade) have appreciated the hard work you've put into this project. I also agree with what Aaron added here. -- Darren Duncan ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class

Re: [Dbix-class] IMPORTANT: A discussion of DBIC governance and future development

2016-10-06 Thread Darren Duncan
On 2016-10-06 8:43 AM, Matt S Trout wrote: On Tue, Oct 04, 2016 at 08:17:49PM -0700, Darren Duncan wrote: That would be good, also in light with how that sentence continues: "I suspect what we need to try and achieve is to get DBIC a bit more decentralised - have it be a specific fram

Re: [Dbix-class] IMPORTANT: A discussion of DBIC governance and future development

2016-10-04 Thread Darren Duncan
it more for maintainability, so it is easier for others to add features or make changes or otherwise just be more confident that it works properly. If things go as I hope, this should start to land in about a month. -- Darren Duncan ___ List: http:

Re: [Dbix-class] A slightly more concrete proposal

2016-10-04 Thread Darren Duncan
by design intended to be fully backwards-compatible with regular user code. -- Darren Duncan On 2016-10-04 1:17 PM, Matt S Trout wrote: Since people seem to be unsure as to what the alternative to riba's project freeze would actually be, let me provide something a little more concrete.

Re: [Dbix-class] IMPORTANT: A discussion of DBIC governance and future development

2016-10-03 Thread Darren Duncan
is limited, I request that you don't halt on the code until the 8th as mentioned, unless you need to rest anyway, and use the time you have to try and finish what you started and leave a better legacy. Thank you for all your effort over the last years. -- Darren Duncan On 2016-10-03

Re: [Dbix-class] PostREST

2016-06-16 Thread Darren Duncan
. Note that it makes a difference which Postgres version you use, the later the better. -- Darren Duncan On 2016-06-16 9:02 AM, Bill Moseley wrote: We are splitting up a larger schema into separate databases -- there's a set of tables that have a very small set of relations to the other t

Re: [Dbix-class] Operator Overloads in DBIC?

2016-05-14 Thread Darren Duncan
mostly are not; the Unicode are for people who want a concise mathy look and have a Perl version supporting Unicode operators. Note that the addition and union only differ for multisets; for sets they are the same operation. -- Darren Duncan ___

[Dbix-class] DBIC branch naming

2016-05-13 Thread Darren Duncan
later when I intend to have something merge-able. For now, would I be best to name any branches like people/myusername/foo like some of the examples I see or is there a different method that is more highly recommended? Thank you. -- Darren Duncan

Re: [Dbix-class] Getting numeric columns as numeric values

2015-02-25 Thread Darren Duncan
t accurate semantics and performance without loss of precision. (I assume the JSON modules deal with Math::BigInt/etc correctly.) How does that work for people? -- Darren Duncan On 2015-02-25 3:30 PM, Augustus Saunders wrote: Seems a little backwards to create a helper to work around a c

Re: [Dbix-class] Getting numeric columns as numeric values

2015-02-25 Thread Darren Duncan
Augustus, what is the problem with DBIC stringifying numeric values? That ensures full precision and in particular when you want to use them as numbers you can just do so, Perl does that automatically. -- Darren Duncan On 2015-02-25 1:15 PM, Augustus Saunders wrote: For reasons unknown to us

Re: [Dbix-class] Escaping placeholders, take 2

2014-12-28 Thread Darren Duncan
It would be a great help to developers in principle if the native way for working with parameters was named rather than positionally. However, that is really a separate matter to deal with and I think it is a good idea for Tim's proposal in some form to happen regardless of dealing with

Re: [Dbix-class] Escaping placeholders

2014-12-21 Thread Darren Duncan
L having ? in operator names such as it did. Its not like the SQL standard reserves ? or whatever for prepared statement parameters, that's defined to be implementation dependent I believe (WD 9075-2:200w(E) 20.6 ). -- Darren Duncan On 2014-12-21 7:17 AM, Greg Sabino Mullane (the tenth

Re: [Dbix-class] Using Postgres JSONB operators in queries

2014-12-18 Thread Darren Duncan
Keep in mind that those dollar-names are a PostgreSQL specific feature, their native way to refer positional routine parameters. In your Perl code the SQL will have to be making those literals, eg non-interpolating dollar signs. -- Darren Duncan On 2014-12-17 10:28 AM, Augustus Saunders

Re: [Dbix-class] Using Postgres JSONB operators in queries

2014-12-16 Thread Darren Duncan
of using PostgreSQL, not that this can't change. -- Darren Duncan ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable

Re: [Dbix-class] join ON *AND*

2014-03-18 Thread Darren Duncan
e the join result would still supposed to have a row but columns from response_comment would be null. Your proposed solution would eliminate "query" rows too because it is applied after the join, not before as expected. Note that an alternative SQL syntax to using ON is to replace

Re: [Dbix-class] Re: Reusing defined columns (inheritance?)

2014-01-04 Thread Darren Duncan
ypes that way, the generic instantiable type being a Perl hash say. -- Darren Duncan ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchabl

Re: [Dbix-class] Moving table out of database

2013-12-27 Thread Darren Duncan
think. -- Darren Duncan On 2013.12.10 10:38 AM, neil.lunn wrote: On 11/12/2013 5:00 AM, Bill Moseley wrote: One of our tables has become very large in our database and we are looking at moving it into a separate, partitioned database. Is there anything more "clever" we can do with D

Re: [Dbix-class] Help ribasushi find his lost mojo ;)

2013-07-15 Thread Darren Duncan
See https://github.com/blogs-perl-org/blogs.perl.org/issues as this seems to be a known bug that's also affecting a bunch of other people. There is also a workaround, which is submitting from the main comment page rather than from the preview page. -- Darren Duncan On 2013.07.15 2:

Re: [Dbix-class] Help ribasushi find his lost mojo ;)

2013-07-12 Thread Darren Duncan
Submission Error Your comment submission failed for the following reasons: Your session has expired. Please sign in again to comment. This happened twice, in 2 different web browsers. -- Darren Duncan ___ List: http://lists.scsys.co.uk/cgi-bin/mailman

Re: [Dbix-class] Regarding Oracle's 1000 element limit in IN clause

2011-10-22 Thread Darren Duncan
e than say using subqueries or other SELECT that involve collecting a mass of temporary data. There's no reason they shouldn't be able to grant you this. -- Darren Duncan ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IR

Re: [Dbix-class] Proposed readonly patch for DBIx::Class

2011-08-19 Thread Darren Duncan
rite attempts, or at the individual table level using privileges, where the application doesn't have privileges to write tables, just read. -- Darren Duncan ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#db

Re: [Dbix-class] deleting from a view

2011-07-12 Thread Darren Duncan
. Some DBMSs do natively support writing to views, and for those that don't, DBIC should be able to implement it, especially for simpler cases like deletes on simple union views. If DBIC doesn't do this, its just a matter of tuits. -- Darren Duncan _

Re: [Dbix-class] any factual comparisons of Oracle, PostgreSQL, MySQL ?

2011-04-13 Thread Darren Duncan
rature about MySQL issues mentions lots of things, but I've read those and all of the above I still had to discover for myself when trying to use it. -- Darren Duncan ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc

Re: [Dbix-class] Howto create Oracle WITH statements

2011-03-25 Thread Darren Duncan
y in one place, but the above alternative will work with more or older ORMs or DBMSs. -- Darren Duncan ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBI

[Dbix-class] test PostgreSQL 9.0 rc1

2010-08-31 Thread Darren Duncan
needs testing, this being a minor update.) -- Darren Duncan Original Message Subject: [ANNOUNCE] PostgreSQL 9.0 Release Candidate 1 Date: Tue, 31 Aug 2010 09:05:01 -0700 From: Josh Berkus To: pgsql-annou...@postgresql.org The first release candidate for PostgreSQL 9.0 is now

[Dbix-class] test DBD::SQLite 1.30_04 - write-ahead logging

2010-08-25 Thread Darren Duncan
system is no longer updateable by the public; posting in the list can cause an update there by a registered SQLite developer). Please do not reply to me directly with your responses. Instead send them to the forums or file with RT as is appropriate. Thank y

Re: [Dbix-class] Moose

2010-07-19 Thread Darren Duncan
at my Muldis::Rosetta toolkit (not yet useable) is intended to support your stated goal, erasing the boundary between Perl and the underlying storage. For now I am helping best by working on M::R, which the functionality you propose or a future DBIC/etc can be more easily

Re: [Dbix-class] Moose

2010-07-19 Thread Darren Duncan
, and then the ORM's API eventually just becomes a proprietary alternate syntax of SQL, in order to meet the user's needs that they would otherwise have written in SQL, and so the users haven't really avoided having to know something about SQL after all.

Re: [Dbix-class] Moose

2010-07-19 Thread Darren Duncan
://thebuild.com/blog/2010/07/18/orms-and-their-discontents-2/ might be interesting to some people; it was presented at PGDay yesterday. Not specific to but applicable to Perl. -- Darren Duncan ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class

Re: [Dbix-class] Automatic quoting

2010-06-08 Thread Darren Duncan
could say "sub sub { sub( $sub ) }" and there's no ambiguity as to what that means, I believe. -- Darren Duncan ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst

Re: [Dbix-class] Automatic quoting

2010-06-08 Thread Darren Duncan
fiers being automatically quoted or not quoted would have different semantics. So the semantics of DBIC would be different if it automatically did or didn't quote identifiers, all other things being equal. -- Darren Duncan ___ List: http://lists.s

[Dbix-class] ANNOUNCE - Muldis D version 0.129.1

2010-05-19 Thread Darren Duncan
rious media and forums. Support is welcome in providing significant financial sponsorship towards my further work, in which case you have more of a say in its direction and priorities. But mainly I want to see it get used to enrich projects and their users and developers. This project and anci

Re: [Dbix-class] seeming error in Manual's CD db example

2010-05-13 Thread Darren Duncan
Darren Duncan wrote: Peter Rabbitson wrote: Darren Duncan wrote: Darren Duncan wrote: http://search.cpan.org/dist/DBIx-Class/lib/DBIx/Class/Manual/Example.pod Generally speaking, I'm coming up with a number of clean-up ideas with the above, where I mentioned one already, and here'

Re: [Dbix-class] seeming error in Manual's CD db example

2010-05-13 Thread Darren Duncan
Peter Rabbitson wrote: Darren Duncan wrote: Darren Duncan wrote: http://search.cpan.org/dist/DBIx-Class/lib/DBIx/Class/Manual/Example.pod Generally speaking, I'm coming up with a number of clean-up ideas with the above, where I mentioned one already, and here's another: Album i

Re: [Dbix-class] seeming error in Manual's CD db example

2010-05-12 Thread Darren Duncan
Darren Duncan wrote: http://search.cpan.org/dist/DBIx-Class/lib/DBIx/Class/Manual/Example.pod Generally speaking, I'm coming up with a number of clean-up ideas with the above, where I mentioned one already, and here's another: It seems that the terms 'album' and

[Dbix-class] seeming error in Manual's CD db example

2010-05-12 Thread Darren Duncan
s, so that component would never be used. So maybe that line can be removed? And if not then why not? -- Darren Duncan ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk

Re: [Dbix-class] RFC - merits of overloading ops versus not doing so

2010-04-18 Thread Darren Duncan
Darren Duncan wrote: Thank you to both G. Wade Johnson and Rob Kinyon for your replies to my RFC; they have been very helpful. I think what I will do in light of this is add overloading for math and string functions + shorthands ("+" parses into the same thing as "sum()"

Re: [Dbix-class] RFC - merits of overloading ops versus not doing so

2010-04-15 Thread Darren Duncan
t yet for collection types, and see how that goes. -- Darren Duncan ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://ww

[Dbix-class] RFC - merits of overloading ops versus not doing so

2010-04-14 Thread Darren Duncan
$...@{bar,baz} $...@{%new<-old1,old2} $...@{new1,new2<-%old} $t%{x<-y,a<-b} $t%{bar,baz} $t%{%new<-old1,old2} $t%{new1,new2<-%old} Thank you in advance for any feedback. -- Darren Duncan ___ List: http://lists.scsys.co.uk/cgi-bin/

Re: [Dbix-class] Excluding columns from a query

2010-02-22 Thread Darren Duncan
racter string column is short enough to include? What is a reasonable cutoff? Or would you return all character string columns but truncate them to some maximum length suitable for giving a preview? -- Darren Duncan ___ List: http://lists.scsys.c

Re: [Dbix-class] Excluding columns from a query

2010-02-17 Thread Darren Duncan
ons being logically associative (except when duplicates or nulls are involved). That's how I see this anyway. -- Darren Duncan ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.

Re: [Dbix-class] Excluding columns from a query

2010-02-12 Thread Darren Duncan
mented, well the process would be related to how DBIx::Class supports "select * from foo"; to know what result columns you will have, you consult metadata you have about the structure of foo, either that you already hold or you ask the DBMS. -- Darren Duncan __

Re: [Dbix-class] Excluding columns from a query

2010-02-11 Thread Darren Duncan
l the columns I want to be excluded including prefetched ones. Or am I missing something? I don't know if you can do that, but it is certainly a very reasonable thing to want to do. -- Darren Duncan ___ List: http://lists.scsys.co.uk/cgi-bin/m

Re: [Dbix-class] Re: RFC - some DBMS features you use

2010-02-05 Thread Darren Duncan
itted". Dagfinn, thanks for that note. I believe Sam Vilain also mentioned PostgreSQL having MVCC in that 2007 proposal about Git as well. Generally speaking, I am hoping that PostgreSQL would stand to be one of the most solid platforms to build on, and its looking better all the time.

Re: [Dbix-class] RFC - some DBMS features you use

2010-02-04 Thread Darren Duncan
Darren Duncan wrote: Rob Kinyon wrote: Locking, afaict, is a way of managing the conflicting transactions problem. Even though it's harder to program (at least, initially), database engines should really support indicating that a transaction commit would have a "merging conflict&qu

Re: [Dbix-class] RFC - some DBMS features you use

2010-02-04 Thread Darren Duncan
Rob Kinyon wrote: On Thu, Feb 4, 2010 at 17:07, Darren Duncan wrote: Hello, Rob, Thank you very much for your reply; your comments are extremely helpful. Your sentiments also generally agree with my own preferences, and in the few cases where I had thought differently, those weren&#

[Dbix-class] RFC - some DBMS features you use

2010-02-04 Thread Darren Duncan
ommit. (I think the subjugate-or-fail should be the case, and the implicit commit is always bad.) What DBMSs currently support each behavior? (AFAIK, SQLite does not automatically commit, but MySQL does. Know otherwise?) I may have more questions, but that's for now. Thank you in

Re: [Dbix-class] Removing rows older than a given number of minutes ...

2010-01-24 Thread Darren Duncan
ard; it is badly named though, given that an INTERVAL in SQL isn't an interval (pair of ordered endpoints) at all, but rather is a duration (an amount of time). -- Darren Duncan ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-cl

Re: [Dbix-class] Naming conventions

2009-12-26 Thread Darren Duncan
result values. I believe a DBIx::Class ResultSet object is like a SQL view but its generally implemented on the Perl side; you could possibly name your variables that hold such objects like with SQL views. -- Darren Duncan ___ List: http://lists.s

Re: [Dbix-class] Moved over to windows Apache and lost my SQLite database

2009-12-04 Thread Darren Duncan
along with them, they ended up with read-only file permissions, but typically you'd want your database to be writable. -- Darren Duncan ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://d

Re: [Dbix-class] Unique constraint isn't good enough for update_or_create?

2009-11-12 Thread Darren Duncan
Sean McAfee wrote: On Wed, Nov 11, 2009 at 10:21 PM, Darren Duncan wrote: >From my quick reading, the ResultSet documentation appears to be saying you need to provide an explicit 'key' attribute value when a match is being done on a non-primary key (aka uniq

Re: [Dbix-class] Unique constraint isn't good enough for update_or_create?

2009-11-11 Thread Darren Duncan
n explicit 'key' attribute value when a match is being done on a non-primary key (aka unique constraint), rather than it figuring things out for itself if you have exactly 1 unique constraint. Have you set 'key' explicitly? -- Darren Duncan

[Dbix-class] test DBD::SQLite 1.26_06 please

2009-10-28 Thread Darren Duncan
ed SQLite developer). Please do not reply to me directly with your responses. Instead send them to the forums or file with RT as is appropriate. Thank you. -- Darren Duncan ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/d

Re: [Dbix-class] Left join with an extra condition

2009-10-24 Thread Darren Duncan
est certainly is expressible as a join, if you consider the "6" to be a single-column,single-row table, and then you are joining 3 tables. Is the syntax you propose supposed to be a shorthand for that? What DBMSs would support this syntax, as I

[Dbix-class] test DBD::SQLite 1.26_05 - foreign keys!

2009-10-14 Thread Darren Duncan
here by a registered SQLite developer). Please do not reply to me directly with your responses. Instead send them to the forums or file with RT as is appropriate. Thank you. -- Darren Duncan P.S. DBD::SQLite has at least 1 known bug, also in version 1.25, with regard to full-text search (FTS3);

[Dbix-class] ANN : new SQL builder module starting development

2009-08-23 Thread Darren Duncan
e I can instead make it the Artistic v2+, which is the same license as Parrot and Rakudo, and which is the "modern 'same version as Perl'" license. Thank you. -- Darren Duncan ___ List: http://lists.scsys.co.uk

Re: [Dbix-class] '' != NULL for great sadness

2009-07-09 Thread Darren Duncan
in some other way, such as by having an undefined-because meta-data field. -- Darren Duncan ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchabl

[Dbix-class] test DBD::SQLite 1.25 please (was Re: ANN ...)

2009-04-23 Thread Darren Duncan
y list members again :) On that note, as I anticipated, Adam has already today released the amalgamation as stable, as DBD::SQLite version 1.25. http://search.cpan.org/dist/DBD-SQLite/ So here's the "noting it's out once it is". -- Darren Duncan __

Re: [Dbix-class] ANN - DBD::SQLite version 1.24_01 - amalgamation

2009-04-23 Thread Darren Duncan
fferent kinds of posts can differ, being better suited for the recipients. -- Darren Duncan ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/

  1   2   >