FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Search found 35 matches
Forum Index
Author Message
  Topic: Statement...the pain.
aaronc542

Replies: 38
Views: 99732

PostForum: DDBI   Posted: Sun Feb 01, 2009 1:13 pm   Subject: Statement...the pain.
http://dev.mysql.com/doc/refman/5.0/en/c-api-multiple-queries.html

See the part that says "Failure to process the result this way may result in a dropped connection to the server"
  Topic: Statement...the pain.
aaronc542

Replies: 38
Views: 99732

PostForum: DDBI   Posted: Sun Feb 01, 2009 12:46 pm   Subject: Statement...the pain.

I think I have a strategy for how to solve this in a better fashion though, but I would like to hear your thoughts on what all the issues are;


* Result/Statement needs the MYSQL* to do some ...
  Topic: Statement...the pain.
aaronc542

Replies: 38
Views: 99732

PostForum: DDBI   Posted: Sun Feb 01, 2009 12:45 pm   Subject: Statement...the pain.

I think I have a strategy for how to solve this in a better fashion though, but I would like to hear your thoughts on what all the issues are;


* Result/Statement needs the MYSQL* to do some ...
  Topic: Statement...the pain.
aaronc542

Replies: 38
Views: 99732

PostForum: DDBI   Posted: Sat Jan 31, 2009 2:39 pm   Subject: Statement...the pain.
detachResult is not a good compromise because it means you need to have the decoupled version there in any case, but only invoking in on request.

Well I think the idea with detachResult is to hide ...
  Topic: Statement...the pain.
aaronc542

Replies: 38
Views: 99732

PostForum: DDBI   Posted: Sat Jan 31, 2009 2:06 pm   Subject: Statement...the pain.
In any case, going away from decoupled interfaces needs good reasons, not the opposite.

I think the burden is on us both. I think you have good points and I think I have good points. And I hope w ...
  Topic: Statement...the pain.
aaronc542

Replies: 38
Views: 99732

PostForum: DDBI   Posted: Sat Jan 31, 2009 11:56 am   Subject: Statement...the pain.

It seems that decoupling:
1) introduces a cyclic import dependency - this is how Mysql trunk is - unless you get around it with an interface


Please point me to the cyclic dependencies.



...
  Topic: Statement...the pain.
aaronc542

Replies: 38
Views: 99732

PostForum: DDBI   Posted: Thu Jan 29, 2009 8:45 pm   Subject: Statement...the pain.
Ok, I still need to be convinced that Database and Result should be decoupled.

A technical reason? I don't have one.

It's a matter of expectations. As an end user, I see a class named Database a ...
  Topic: Statement...the pain.
aaronc542

Replies: 38
Views: 99732

PostForum: DDBI   Posted: Thu Jan 29, 2009 8:28 pm   Subject: Statement...the pain.
That's not a "MultiResult" - this is just row by row fetching.

Okay. The fact remains that I don't see how to accomplish this in ddbi or in your fork.

Hmm... well Mysql doesn't allow ...
  Topic: Statement...the pain.
aaronc542

Replies: 38
Views: 99732

PostForum: DDBI   Posted: Thu Jan 29, 2009 8:22 pm   Subject: Statement...the pain.
Oh! I finally understand Statement now!

Statement.execute executes a query. This query can return multiple rows, but you don't actually retrieve them in this step.

Statement.fetch retrieves a ro ...
  Topic: Statement...the pain.
aaronc542

Replies: 38
Views: 99732

PostForum: DDBI   Posted: Thu Jan 29, 2009 11:14 am   Subject: Statement...the pain.
Ok, I still need to be convinced that Database and Result should be decoupled.

It seems that decoupling:
1) introduces a cyclic import dependency - this is how Mysql trunk is - unless you get arou ...
  Topic: Statement...the pain.
aaronc542

Replies: 38
Views: 99732

PostForum: DDBI   Posted: Thu Jan 29, 2009 10:26 am   Subject: Statement...the pain.


Additionally, you don't allow anyone to bind anything without using strong typing, and you don't allow people to bind one argument to a Statement at a time. This means that I wouldn't be able to u ...
  Topic: Statement...the pain.
aaronc542

Replies: 38
Views: 99732

PostForum: DDBI   Posted: Thu Jan 29, 2009 8:49 am   Subject: Statement...the pain.

Ok, with regards to prepared statements and multi-result sets, can you please mention a database that supports this feature?

You didn't quote me, so I assume you're talking about this:

It isn' ...
  Topic: Statement...the pain.
aaronc542

Replies: 38
Views: 99732

PostForum: DDBI   Posted: Wed Jan 28, 2009 10:49 pm   Subject: Statement...the pain.

If you had Tango-style variadic functions (that is, a variadic function, as well as a function that takes _arguments and _argptr), I could work with that quite well. While it's hard to support both ...
  Topic: Statement...the pain.
aaronc542

Replies: 38
Views: 99732

PostForum: DDBI   Posted: Wed Jan 28, 2009 10:41 pm   Subject: Statement...the pain.

Looking through the code, for instance, it's doing string catenation on MysqlDatabase.setXXX methods for binding parameters to the database's current query. Eugh. If you're worried about efficiency, ...
  Topic: Statement...the pain.
aaronc542

Replies: 38
Views: 99732

PostForum: DDBI   Posted: Tue Jan 27, 2009 10:38 pm   Subject: Statement...the pain.
Ok, I would like to make a decision fairly soon as to whether not this gets merged into the trunk - and if not what API changes need to be made. FYI, I believe this code is fairly stable - I currentl ...
 
Page 1 of 3 Goto page 1, 2, 3  Next
All times are GMT - 6 Hours
Jump to:  


Powered by phpBB © 2001, 2005 phpBB Group