Re: [Firebird-devel] UUIDs
On Thu, 15 Dec 2011 15:14:20 -0200, Adriano dos Santos Fernandes wrote: > There is no UUID "binary representation" in the RFC. There it's just a > formated string. Yes there is a binary representation defined in http://www.ietf.org/rfc/rfc4122.txt in section 4.1.2. It also explicitly says that bytes should be in network byte order (aka big-endian). " 4.1.2. Layout and Byte Order To minimize confusion about bit assignments within octets, the UUID record definition is defined only in terms of fields that are integral numbers of octets. The fields are presented with the most significant one first. Field Data Type Octet Note # time_low unsigned 32 0-3The low field of the bit integer timestamp time_mid unsigned 16 4-5The middle field of the bit integer timestamp time_hi_and_versionunsigned 16 6-7The high field of the bit integer timestamp multiplexed with the version number clock_seq_hi_and_rese unsigned 88 The high field of the rved bit integer clock sequence multiplexed with the variant clock_seq_low unsigned 89 The low field of the bit integer clock sequence node unsigned 48 10-15 The spatially unique bit integer node identifier In the absence of explicit application or presentation protocol specification to the contrary, a UUID is encoded as a 128-bit object, as follows: The fields are encoded as 16 octets, with the sizes and order of the fields defined above, and with each field encoded with the Most Significant Byte first (known as network byte order). Note that the field names, particularly for multiplexed fields, follow historical practice. 0 1 2 3 0 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9 0 1 +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+ | time_low | +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+ | time_mid| time_hi_and_version | +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+ |clk_seq_hi_res | clk_seq_low | node (0-1)| +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+ | node (2-5)| +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+ " It also describes the exact format string in section 3. > Also we never documented our binary representation, and the only thing > visible on it is that it's the same representation of the formatted string. > > Change this would be wrong IMO, and much worse considering this change > would need new (and hence confusing) format functions. > > For Windows users this binary representation is also wrong now, cause > reserved bits is not documented in it. You might want to look at 4.1.1 Variant Mark -- Learn Windows Azure Live! Tuesday, Dec 13, 2011 Microsoft is holding a special Learn Windows Azure training event for developers. It will provide a great way to learn Windows Azure and what it provides. You can attend the event by watching it streamed LIVE online. Learn more at http://p.sf.net/sfu/ms-windowsazure Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Reason for slow CREATE DATABASE in FB 3 (Linux)
On 16/12/2011 05:24, Vlad Khorsun wrote: So now we're spending time while the database is not even completely created. >>> While we can restore previous behavior (put FW ON flag at header page >>> when database is created but create db file with this flag switched off) i >>> prefer >>> to ask - are we really want to maintain this hack ? Wouldn't it be better >>> to add >>> support of the all existing DBP tags to the CREATE DATABASE statement >>> and adjust TCS and gbak correspondingly ? >>> >> Maybe, but I don't think the wish for a faster CREATE DATABASE with >> FW=ON is a hack. If this is true, seems we have a design problem. > Faster CREATE DATABASE ? It is fast enough :) Faster inserts ? It > depends. > And it depends on FW setting also. And when we have some setting ON on disk > and OFF in memory at the same time - yes, i consider it as a hack. > > No, *it's not* fast enough in the case of ext4. Around 3s to create a blank database is too much. And as I said, there is no need to care about safety database creation while it is still not completely created. I'm not saying to leave the FW=OFF until a next command like 2.5, but to set it to ON *after* the create is complete, not in the middle of it like now. Adriano -- Learn Windows Azure Live! Tuesday, Dec 13, 2011 Microsoft is holding a special Learn Windows Azure training event for developers. It will provide a great way to learn Windows Azure and what it provides. You can attend the event by watching it streamed LIVE online. Learn more at http://p.sf.net/sfu/ms-windowsazure Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] New API? What about protocol enhancements?
AP> With 14 nodes between client and server that's known that we have AP> problems. We perform too many roundtrips between client and server AP> compared with MySQL. Possible solutions are: AP> - modify API to have big calls (like attach database, start transaction, AP> prepare statement and return first row - all in one call) AP> - make client delay more packets (i.e. make it collect everything needed AP> for a single packet representing mentioned big call from a lot of small AP> calls) Whatever the solution is, if any of you have interest on implementing it, I'm willing to try to collect money to sponsor it. If possible, still for FB 3.0. []s Carlos http://www.firebirdnews.org FireBase - http://www.FireBase.com.br -- Learn Windows Azure Live! Tuesday, Dec 13, 2011 Microsoft is holding a special Learn Windows Azure training event for developers. It will provide a great way to learn Windows Azure and what it provides. You can attend the event by watching it streamed LIVE online. Learn more at http://p.sf.net/sfu/ms-windowsazure Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Reason for slow CREATE DATABASE in FB 3 (Linux)
On 12/16/11 13:39, Adriano dos Santos Fernandes wrote: > On 16/12/2011 05:24, Vlad Khorsun wrote: > So now we're spending time while the database is not even completely > created. While we can restore previous behavior (put FW ON flag at header page when database is created but create db file with this flag switched off) i prefer to ask - are we really want to maintain this hack ? Wouldn't it be better to add support of the all existing DBP tags to the CREATE DATABASE statement and adjust TCS and gbak correspondingly ? >>> Maybe, but I don't think the wish for a faster CREATE DATABASE with >>> FW=ON is a hack. If this is true, seems we have a design problem. >> Faster CREATE DATABASE ? It is fast enough :) Faster inserts ? It >> depends. >> And it depends on FW setting also. And when we have some setting ON on disk >> and OFF in memory at the same time - yes, i consider it as a hack. >> >> > No, *it's not* fast enough in the case of ext4. > > Around 3s to create a blank database is too much. And as I said, there > is no need to care about safety database creation while it is still not > completely created. > > I'm not saying to leave the FW=OFF until a next command like 2.5, but to > set it to ON *after* the create is complete, not in the middle of it > like now. I see no problems with suggested solution. Just take into on account that in linux we need reopen file to change SYNC mode, though I do not see at first glance what can be bad with it. -- Learn Windows Azure Live! Tuesday, Dec 13, 2011 Microsoft is holding a special Learn Windows Azure training event for developers. It will provide a great way to learn Windows Azure and what it provides. You can attend the event by watching it streamed LIVE online. Learn more at http://p.sf.net/sfu/ms-windowsazure Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] New API? What about protocol enhancements?
On 12/16/11 14:39, Carlos H. Cantu wrote: > AP> With 14 nodes between client and server that's known that we have > AP> problems. We perform too many roundtrips between client and server > AP> compared with MySQL. Possible solutions are: > AP> - modify API to have big calls (like attach database, start transaction, > AP> prepare statement and return first row - all in one call) > AP> - make client delay more packets (i.e. make it collect everything needed > AP> for a single packet representing mentioned big call from a lot of small > AP> calls) > > Whatever the solution is, if any of you have interest on implementing > it, I'm willing to try to collect money to sponsor it. If possible, > still for FB 3.0. Hmm... Did we have it in FB3 roadmap? -- Learn Windows Azure Live! Tuesday, Dec 13, 2011 Microsoft is holding a special Learn Windows Azure training event for developers. It will provide a great way to learn Windows Azure and what it provides. You can attend the event by watching it streamed LIVE online. Learn more at http://p.sf.net/sfu/ms-windowsazure Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] New API? What about protocol enhancements?
AP> Hmm... AP> Did we have it in FB3 roadmap? I doubt that. But afaik, FB 3 is not feature freeze yet ;) []s Carlos http://www.firebirdnews.org FireBase - http://www.FireBase.com.br AP> On 12/16/11 14:39, Carlos H. Cantu wrote: >> AP> With 14 nodes between client and server that's known that we have >> AP> problems. We perform too many roundtrips between client and server >> AP> compared with MySQL. Possible solutions are: >> AP> - modify API to have big calls (like attach database, start transaction, >> AP> prepare statement and return first row - all in one call) >> AP> - make client delay more packets (i.e. make it collect everything needed >> AP> for a single packet representing mentioned big call from a lot of small >> AP> calls) >> >> Whatever the solution is, if any of you have interest on implementing >> it, I'm willing to try to collect money to sponsor it. If possible, >> still for FB 3.0. -- Learn Windows Azure Live! Tuesday, Dec 13, 2011 Microsoft is holding a special Learn Windows Azure training event for developers. It will provide a great way to learn Windows Azure and what it provides. You can attend the event by watching it streamed LIVE online. Learn more at http://p.sf.net/sfu/ms-windowsazure Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] New API? What about protocol enhancements?
On 12/16/11 15:58, Carlos H. Cantu wrote: > AP> Hmm... > AP> Did we have it in FB3 roadmap? > > I doubt that. But afaik, FB 3 is not feature freeze yet ;) Certainly not. But there is Q1-2012 as alpha release date. If we do not plan to touch API, there are no big problems to change protocol before beta1. But if we are going to have serious API change, it's better to do it before alpha release. -- Learn Windows Azure Live! Tuesday, Dec 13, 2011 Microsoft is holding a special Learn Windows Azure training event for developers. It will provide a great way to learn Windows Azure and what it provides. You can attend the event by watching it streamed LIVE online. Learn more at http://p.sf.net/sfu/ms-windowsazure Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] New API? What about protocol enhancements?
16.12.2011 13:09, Alex Peshkoff wrote: > But if > we are going to have serious API change, it's better to do it before > alpha release. C'mon. New API needs a couple of version to stabilize and make usable. You can't expect it to become rock solid in 3.0. -- SY, SD. -- Learn Windows Azure Live! Tuesday, Dec 13, 2011 Microsoft is holding a special Learn Windows Azure training event for developers. It will provide a great way to learn Windows Azure and what it provides. You can attend the event by watching it streamed LIVE online. Learn more at http://p.sf.net/sfu/ms-windowsazure Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] New API? What about protocol enhancements?
DS>C'mon. New API needs a couple of version to stabilize and make usable. You can't expect DS> it to become rock solid in 3.0. Afaik, old API will be still there untouched, so, I dont see so much problem. We are more than 1 year away of the final release of FB 3, so, there is plenty of time for testing. []s Carlos http://www.firebirdnews.org FireBase - http://www.FireBase.com.br -- Learn Windows Azure Live! Tuesday, Dec 13, 2011 Microsoft is holding a special Learn Windows Azure training event for developers. It will provide a great way to learn Windows Azure and what it provides. You can attend the event by watching it streamed LIVE online. Learn more at http://p.sf.net/sfu/ms-windowsazure Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] New API? What about protocol enhancements?
16.12.2011 13:40, Carlos H. Cantu wrote: > there is plenty of time for testing. It is not actually about testing, but rather practical usability. API can work without any glitch, but don't provide some functions that are required for "real" usage. As an example - API for trace plugins which is enough for single existing plugin but missed access to BLOBs/arrays makes it useless for wider audience. -- SY, SD. -- Learn Windows Azure Live! Tuesday, Dec 13, 2011 Microsoft is holding a special Learn Windows Azure training event for developers. It will provide a great way to learn Windows Azure and what it provides. You can attend the event by watching it streamed LIVE online. Learn more at http://p.sf.net/sfu/ms-windowsazure Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] New API? What about protocol enhancements?
I see, but we will have new OO API in FB 3 anyway so, I do not see a reason to not have new functions with the features Alex described too. Also, traceapi was a totally new thing, while developers are much more used to the "standard" API, so I guess the "places" to be enhanced are already known ;-) []s Carlos http://www.firebirdnews.org FireBase - http://www.FireBase.com.br DS> 16.12.2011 13:40, Carlos H. Cantu wrote: >> there is plenty of time for testing. DS>It is not actually about testing, but rather practical usability. API can work without DS> any glitch, but don't provide some functions that are required for "real" usage. As an DS> example - API for trace plugins which is enough for single existing plugin but missed DS> access to BLOBs/arrays makes it useless for wider audience. -- Learn Windows Azure Live! Tuesday, Dec 13, 2011 Microsoft is holding a special Learn Windows Azure training event for developers. It will provide a great way to learn Windows Azure and what it provides. You can attend the event by watching it streamed LIVE online. Learn more at http://p.sf.net/sfu/ms-windowsazure Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] New API? What about protocol enhancements?
> It is not actually about testing, but rather practical usability. API can > work without > any glitch, but don't provide some functions that are required for "real" > usage. As an > example - API for trace plugins which is enough for single existing plugin > but missed > access to BLOBs/arrays makes it useless for wider audience. a) Trace API was never considered as complete and therefore it was not stated as public API b) Trace API is not a replacement for missed built-in replication feature c) Trace API exists more than two years, where you was at 2.5 beta stage ? d) request feature you really need, don't try to match another feature into your requirements Regards, Vlad -- Learn Windows Azure Live! Tuesday, Dec 13, 2011 Microsoft is holding a special Learn Windows Azure training event for developers. It will provide a great way to learn Windows Azure and what it provides. You can attend the event by watching it streamed LIVE online. Learn more at http://p.sf.net/sfu/ms-windowsazure Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] New API? What about protocol enhancements?
> 16.12.2011 13:40, Carlos H. Cantu wrote: >> there is plenty of time for testing. > > It is not actually about testing, but rather practical usability. API can > work without > any glitch, but don't provide some functions that are required for "real" > usage. As an > example - API for trace plugins which is enough for single existing plugin > but missed > access to BLOBs/arrays makes it useless for wider audience. Define "wider". ;-) In the mean time I know people who would have gone over death bodies if tracing had been available already a few years ago. Regards, Thomas -- Learn Windows Azure Live! Tuesday, Dec 13, 2011 Microsoft is holding a special Learn Windows Azure training event for developers. It will provide a great way to learn Windows Azure and what it provides. You can attend the event by watching it streamed LIVE online. Learn more at http://p.sf.net/sfu/ms-windowsazure Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] New API? What about protocol enhancements?
16.12.2011 14:17, Thomas Steinmaurer wrote: > Define "wider".;-) Anybody outside of core development team. -- SY, SD. -- Learn Windows Azure Live! Tuesday, Dec 13, 2011 Microsoft is holding a special Learn Windows Azure training event for developers. It will provide a great way to learn Windows Azure and what it provides. You can attend the event by watching it streamed LIVE online. Learn more at http://p.sf.net/sfu/ms-windowsazure Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] New API? What about protocol enhancements?
On 12/16/11 16:45, Dimitry Sibiryakov wrote: > 16.12.2011 13:40, Carlos H. Cantu wrote: >> there is plenty of time for testing. >It is not actually about testing, but rather practical usability. API can > work without > any glitch, but don't provide some functions that are required for "real" > usage. What do you mean by "real" here? Why in "" ? > As an > example - API for trace plugins which is enough for single existing plugin > but missed > access to BLOBs/arrays makes it useless for wider audience. > It's definitely better to provide access to this type of data too, but taking into an account that nobody requested that for years of 2.5 existence this is not very critical feature :) I hope we will add it in 3.0 without big problems. -- Learn Windows Azure Live! Tuesday, Dec 13, 2011 Microsoft is holding a special Learn Windows Azure training event for developers. It will provide a great way to learn Windows Azure and what it provides. You can attend the event by watching it streamed LIVE online. Learn more at http://p.sf.net/sfu/ms-windowsazure Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] New API? What about protocol enhancements?
On 16/12/2011 11:25, Alex Peshkoff wrote: > On 12/16/11 16:45, Dimitry Sibiryakov wrote: >> 16.12.2011 13:40, Carlos H. Cantu wrote: >>> there is plenty of time for testing. >> It is not actually about testing, but rather practical usability. API >> can work without >> any glitch, but don't provide some functions that are required for "real" >> usage. > What do you mean by "real" here? Why in "" ? > Until nobody writes real application for these APIs, they're not really real. I'd say is a must to convert ISQL to the new API at least. In the same time, would be better to remove all crap ESQL code duplication with there is. Adriano -- Learn Windows Azure Live! Tuesday, Dec 13, 2011 Microsoft is holding a special Learn Windows Azure training event for developers. It will provide a great way to learn Windows Azure and what it provides. You can attend the event by watching it streamed LIVE online. Learn more at http://p.sf.net/sfu/ms-windowsazure Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] New API? What about protocol enhancements?
On 12/16/11 17:30, Adriano dos Santos Fernandes wrote: > On 16/12/2011 11:25, Alex Peshkoff wrote: >> On 12/16/11 16:45, Dimitry Sibiryakov wrote: >>> 16.12.2011 13:40, Carlos H. Cantu wrote: there is plenty of time for testing. >>> It is not actually about testing, but rather practical usability. API >>> can work without >>> any glitch, but don't provide some functions that are required for "real" >>> usage. >> What do you mean by "real" here? Why in "" ? >> > Until nobody writes real application for these APIs, they're not really > real. > > I'd say is a must to convert ISQL to the new API at least. Network server is rewritten. > In the same time, would be better to remove all crap ESQL code > duplication with there is. Good boost training, yes? :) -- Learn Windows Azure Live! Tuesday, Dec 13, 2011 Microsoft is holding a special Learn Windows Azure training event for developers. It will provide a great way to learn Windows Azure and what it provides. You can attend the event by watching it streamed LIVE online. Learn more at http://p.sf.net/sfu/ms-windowsazure Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] UUIDs
On 16/12/2011 06:08, Mark Rotteveel wrote: > On Thu, 15 Dec 2011 15:14:20 -0200, Adriano dos Santos Fernandes > wrote: >> There is no UUID "binary representation" in the RFC. There it's just a >> formated string. > Yes there is a binary representation defined in > http://www.ietf.org/rfc/rfc4122.txt in section 4.1.2. It also explicitly > says that bytes should be in network byte order (aka big-endian). Thanks! So indeed we're generating invalid binary representation currently, due to the endian issue. Adriano -- Learn Windows Azure Live! Tuesday, Dec 13, 2011 Microsoft is holding a special Learn Windows Azure training event for developers. It will provide a great way to learn Windows Azure and what it provides. You can attend the event by watching it streamed LIVE online. Learn more at http://p.sf.net/sfu/ms-windowsazure Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] fbrmclib.dll
All: fbrmclib.dll in the v.2.5.n \bin\ folder: what is it? Thanks, Helen -- Learn Windows Azure Live! Tuesday, Dec 13, 2011 Microsoft is holding a special Learn Windows Azure training event for developers. It will provide a great way to learn Windows Azure and what it provides. You can attend the event by watching it streamed LIVE online. Learn more at http://p.sf.net/sfu/ms-windowsazure Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] fbrmclib.dll
17.12.2011 8:34, Helen Borrie wrote: > > fbrmclib.dll in the v.2.5.n \bin\ folder: what is it? Some utility library related to the GPRE / RM Cobol support contributed by Steve Boyd a while ago. Dmitry -- Learn Windows Azure Live! Tuesday, Dec 13, 2011 Microsoft is holding a special Learn Windows Azure training event for developers. It will provide a great way to learn Windows Azure and what it provides. You can attend the event by watching it streamed LIVE online. Learn more at http://p.sf.net/sfu/ms-windowsazure Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] fbrmclib.dll
At 07:20 PM 17/12/2011, Dmitry Yemanov wrote: >17.12.2011 8:34, Helen Borrie wrote: >> >> fbrmclib.dll in the v.2.5.n \bin\ folder: what is it? > >Some utility library related to the GPRE / RM Cobol support contributed >by Steve Boyd a while ago. Oh. Ok. :-\ Helen -- Learn Windows Azure Live! Tuesday, Dec 13, 2011 Microsoft is holding a special Learn Windows Azure training event for developers. It will provide a great way to learn Windows Azure and what it provides. You can attend the event by watching it streamed LIVE online. Learn more at http://p.sf.net/sfu/ms-windowsazure Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
