Re: [Firebird-devel] RFC: Tablespaces

[Dmitry Yemanov]

03.03.2016 09:48, Dmitry Yemanov wrote:
>
>> Blobs could be moved into separate tablespace. It could make backup of
>> "data" tablespace faster and smaller. We can even think about "offline"
>> tablespace.
>
> Really good idea. Maybe more important for an average FB user than the
> other usage cases.

BTW, if blob is declared as belonging to some tablespace, should level-0 
blobs be also moved to its own tablespace or stored in the table tablespace?

And another question: does RDB$PAGES need to include the pagespace ID or 
we never allow tablespaces for TIP, generator pages and system tables? 
Pagespace ID for PP/IRP can be retrieved from RDB$ tables based on 
relation_id, so I don't see a problem to store just the "local" page number.


Dmitry


--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] RFC: Tablespaces

[Atri Sharma]

Can we start fleshing subtasks which need to be started to progress this
please? The discussion is going really well!
On 3 Mar 2016 12:20 pm, "Dmitry Yemanov"  wrote:

> 03.03.2016 00:51, Vlad Khorsun wrote:
> >
> > Blobs could be moved into separate tablespace. It could make backup of
> > "data" tablespace faster and smaller. We can even think about "offline"
> > tablespace.
>
> Really good idea. Maybe more important for an average FB user than the
> other usage cases.
>
> > There is implicit assumption that all table's pointer, data, index and
> blob
> > pages allocated at the same tablespace.
>
> Supposedly, it should be possible to fix/improve.
>
> > pag.h contains following:
> >
> > // page spaces below TEMP_PAGE_SPACE is regular database pages
> > // TEMP_PAGE_SPACE and page spaces above TEMP_PAGE_SPACE is temporary
> pages
> > const USHORT DB_PAGE_SPACE= 1;
> > const USHORT TEMP_PAGE_SPACE  = 256;
>
> So we have room for 255 pagespaces now. It should be OK for tablespaces,
> although may be not enough for partitions...
>
> > Shadows. It is not clear (for me at least) should a shadow be defined for
> > a whole database or per-tablespace level ?
>
> At the first glance, I think the whole database. But it should be
> carefully thought out.
>
> > Also, PIP and Header page. Should every tablespace contains its own PIP ?
> > Currently, every page space have own PIP, but only DP_PAGE_SPACE contains
> > own Header page..
>
> Again at the first glance: PIPs are per tablespace. As for headers, I'm
> not that sure. It looks logical if we allow to override some database
> settings at the tablespace level: e.g. no-reserve, FW. But the same
> effect could be achieved by storing the custom setting in
> RDB$TABLESPACES (which is to be accessed anyway before any tablespace is
> being opened).
>
>
> Dmitry
>
>
>
> --
> Site24x7 APM Insight: Get Deep Visibility into Application Performance
> APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
> Monitor end-to-end web transactions and take corrective actions now
> Troubleshoot faster and improve end-user experience. Signup Now!
> http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
> Firebird-Devel mailing list, web interface at
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>
--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] RFC: Tablespaces

[Dmitry Yemanov]

03.03.2016 00:51, Vlad Khorsun wrote:
>
> Blobs could be moved into separate tablespace. It could make backup of
> "data" tablespace faster and smaller. We can even think about "offline"
> tablespace.

Really good idea. Maybe more important for an average FB user than the 
other usage cases.

> There is implicit assumption that all table's pointer, data, index and blob
> pages allocated at the same tablespace.

Supposedly, it should be possible to fix/improve.

> pag.h contains following:
>
> // page spaces below TEMP_PAGE_SPACE is regular database pages
> // TEMP_PAGE_SPACE and page spaces above TEMP_PAGE_SPACE is temporary pages
> const USHORT DB_PAGE_SPACE= 1;
> const USHORT TEMP_PAGE_SPACE  = 256;

So we have room for 255 pagespaces now. It should be OK for tablespaces, 
although may be not enough for partitions...

> Shadows. It is not clear (for me at least) should a shadow be defined for
> a whole database or per-tablespace level ?

At the first glance, I think the whole database. But it should be 
carefully thought out.

> Also, PIP and Header page. Should every tablespace contains its own PIP ?
> Currently, every page space have own PIP, but only DP_PAGE_SPACE contains
> own Header page..

Again at the first glance: PIPs are per tablespace. As for headers, I'm 
not that sure. It looks logical if we allow to override some database 
settings at the tablespace level: e.g. no-reserve, FW. But the same 
effect could be achieved by storing the custom setting in 
RDB$TABLESPACES (which is to be accessed anyway before any tablespace is 
being opened).


Dmitry


--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] RFC: Tablespaces

[Dmitry Yemanov]

03.03.2016 02:12, Leyne, Sean wrote:
>
> While I can see possible use cases, I am concerned that implementing 
> tablespaces would only make database management more complicated.

True, but only for those using it.

> Based on your outline/proposal, however, aren't Tablespaces just enabling 
> multi-file databases -- just under a different name?

I've meant removing the "legacy" approach, i.e. ability for a single 
page space to span multiple files.


Dmitry


--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] RFC: Tablespaces

[Dmitry Yemanov]

03.03.2016 00:23, Dmitry Yemanov wrote:
>
> Someone may think about per-tablespace physical backups and other
> possible usage cases.

Personally, I don't care much about tablespaces per se. But I foresee 
that table partitioning could be stacked over the tablespace 
implementation and I like this idea.

> Now back to the code. During the Firebird development, we have
> introduced a concept of "page spaces", represented with a PageSpace
> class.

I've meant PageNumber here, sorry. It combined pagespace ID + local page 
number.


Dmitry



--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Improve compilation on OS X El Capitan

[Quentin Pradet]

Thank you Paul!

I know nothing about LibreOffice and FirebirdSQL, I was just trying to
compile LibreOffice on my system, and I'm now trying to compile Firebird
itself but this file does not appear to be included in LibreOffice so I'm
probably wasting our time.

Anyway, for LibreOffice, it looks like System Integrity Protection is
getting in the way. I stumbled upon a hack from a LibreOffice contributor
who went to great lengths to try to compile Firebird as part of LibreOffice
by compiling bash just for Firebird:
https://cgit.freedesktop.org/libreoffice/core/commit/?id=ce170cf1f264c69e91cde268ee490584c8fbcd04

If and when I have more informations, I'll share to see if I can help to
make things better.

On Wed, Mar 2, 2016 at 7:24 PM, Paul Beach  wrote:

> <
> I'm trying to compile Firebird on OS X El Capitan to understand why it
> does not compile in LibreOffice [0]. But I can't compile it directly
> either. I had issues with ICU configuration, but at least this issue
> can be fixed directly in the code: CTest.c from cloop includes
>  but this is deprecated and not needed in this file.
>
> [0]
> https://lists.freedesktop.org/archives/libreoffice/2016-February/073399.html
>
> Here's the patch:
>
> Index: extern/cloop/src/tests/test1/CTest.c
> ===
> --- extern/cloop/src/tests/test1/CTest.c(revision 63007)
> +++ extern/cloop/src/tests/test1/CTest.c(working copy)
> @@ -20,7 +20,6 @@
>   */
>
>  #include "CalcCApi.h"
> -#include 
>  #include 
>
>  #ifdef WIN32>>
>
> Committed into trunk and B3_0_Release.
>
> Paul
>
--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] [Firebird-checkins] SF.net SVN: firebird:[63072] firebird/trunk/src

[Dmitry Yemanov]

03.03.2016 00:41, Dimitry Sibiryakov wrote:

> I did. Look into ICQ logs. 
> http://www.ibphoenix.com/ibpr_devel/Avalerion.63058.7z
> contain every changed source file in obedience to IDPL.

I've asked for a particular change patch, you've provided 220KB of the 
total tree diff to scan for the needed changes. If you want your patches 
reviewed sooner, better start to respect other's time.


Dmitry


--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Record level compression for V4

[Slavomir Skopalik]

Hi,
this is about record encoding .
My private test with RLE + LZ4 shows, that from combination RLE, LZ4, 
RLE + LZ4 the last is the best.
I believe, that better record encoding will help wire transfer in any case.

 From other side, record encoding can be used in all situation (in 
average speed can be around 10-30% of memory move)
but zlib over local network can be limitation.

Slavek

> With the zlib support in the v13 wire protocol, I am not sure another
> layer of compression in the protocol is a good idea. If it happens
> though, I would really appreciate clear specifications outside the code.
>
> Mark



--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] RFC: Tablespaces

[Adriano dos Santos Fernandes]

Em 02/03/2016 20:12, Leyne, Sean escreveu:

> 
> While I can see possible use cases, I am concerned that implementing 
> tablespaces would only make database management more complicated.
> 

Only for who wants adavanced settings.

> The filename/path would become integral to the database and thus cause 
> problems if a device which part of the database was stored was not 
> accessible...
> 

Relative filenames should be resolved in relation to the main database file.


Adriano

--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] GitHub

[Adriano dos Santos Fernandes]

Em 02/03/2016 11:14, Michal Kubecek escreveu:
> On Wed, Mar 02, 2016 at 10:45:35AM -0300, Adriano dos Santos Fernandes wrote:
>> Em 02/03/2016 09:31, Michal Kubecek escreveu:
>>> On Wed, Mar 02, 2016 at 02:18:27PM +0300, Dmitry Yemanov wrote:

 Firebird Project will be moving its repositories to GitHub soon.
>>>
>>> Is the fact that the git repository hasn't been updated since Sunday
>>> (and therefore has no B3_0_Release branch) related to this migration
>>> or is it a different problem?
>>>
>>
>> The fact is more this: :D
>>
>> http://stackoverflow.com/questions/35726537/track-a-branch-in-a-bare-git-svn
> 
> That was my first hypothesis. :-)
> 

Now it's syncing again.


Adriano

--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] RFC: Tablespaces

[Leyne, Sean]

Dmitry,

> When we speak about tablespaces, it usually means that the database
> consists of multiple files and different database object are stored in 
> different
> files. Each such file is named within a database and called a tablespace. And
> each tablespace has its own page set and page numbering.

While I can see possible use cases, I am concerned that implementing 
tablespaces would only make database management more complicated.

The filename/path would become integral to the database and thus cause problems 
if a device which part of the database was stored was not accessible...

With the continuing evolution of disk/storage technology with automatic 
storage/block tiering (hot block on flash, cold blocks on HDDs) being built 
into OS/storage devices, I do not think that the database should be concerned 
about table/storage location management.


> A typical usage pattern is that tablespaces are used to separate table data
> from indices (and logs from the rest of the database) and thus allow better
> concurrent performance due to parallel I/O. Often it's argued that RAIDs now
> handle the same job and maybe even better. For many usage cases - maybe.
> But I'm pretty sure that the opposite cases are also possible, when a 
> carefully
> designed partitioning could outperform automatic RAID data management.

Rather than focus on physical page location management, perhaps Tablespace can 
be thought of as:

- mechanism to set page cache size/rules -- X pages cache for index pages, Y 
page cache for high activity tables...
- mechanism to set garbage collection policy for tables
- way to reduce header page/lock contention


> Another usage case could be extending the database size beyond the
> current limits. The limit is 64TB, the biggest FB database I known is 7TB. Not
> that far, I'd say. The limit may be shifted with even larger page sizes, but 
> it
> has its drawbacks as well.

I might be alone in thinking this way, but if you have more than 4 to 10 TB of 
data to store/query, in this day/age, you should be looking to use distributed 
database/Hadoop type engines.  

Heck, I have been looking at these technologies for quite some time and my 
largest database is only 250GB.


> (*) My personal opinion is that legacy multi-file databases must die,
> preferrably in FB4. They make zero sense in modern filesystems.

Completely agree, including database shadows!!

Based on your outline/proposal, however, aren't Tablespaces just enabling 
multi-file databases -- just under a different name?


Sean


--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Creating collations with extra ICU version

[Adriano dos Santos Fernandes]

Em 02/03/2016 19:23, Mark Rotteveel escreveu:
> I will tomorrow evening, but everything suggests that using 5.6 is the
> right thing,

Internally source compiled with ICU 55 treats this version as 55. They
changed how they .so filename convention at some point.

> otherwise I'd expect create collation would have failed,
> like it does when I don't include attribute ICU-VERSION=5.6.
> 
> And as I mailed previously, the FAQ on the site indicates 56 would mean
> 5.6 (as does our own documentation of create collation).
>

Our documentation is probably outdated, as wrote for ICU 3.X.

> However all this distracts from the questions in my initial email:
> 
> 1. Why is the ICU-VERSION attribute not stored, causing the collation to
> be unusable (and editing it in in the system table or editing the
> fbintl.conf to only 5.6 makes it work)?
> 

If you use wrong version, things would certainly go wrong, it's why I'm
asking for the correct version in the test.

This attribute is removed and the collation version number is written
instead.

> 2. How can I create a unicode collation with the German phonebook sort
> order?
> 

Let's see after everything else start working. Isn't this collation
present in the same (but downloaded from ICU site) version deployed with
our binaries?


Adriano

--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Creating collations with extra ICU version

[Mark Rotteveel]

I will tomorrow evening, but everything suggests that using 5.6 is the right 
thing, otherwise I'd expect create collation would have failed, like it does 
when I don't include attribute ICU-VERSION=5.6.
And as I mailed previously, the FAQ on the site indicates 56 would mean 5.6 (as 
does our own documentation of create collation).

However all this distracts from the questions in my initial email:

1. Why is the ICU-VERSION attribute not stored, causing the collation to be 
unusable (and editing it in in the system table or editing the fbintl.conf to 
only 5.6 makes it work)?

2. How can I create a unicode collation with the German phonebook sort order?

Mark

- Bericht beantwoorden -
Van: "Adriano dos Santos Fernandes" 
Aan: "For discussion among Firebird Developers" 

Onderwerp: [Firebird-devel] Creating collations with extra ICU version
Datum: wo, mrt. 2, 2016 22:57

Em 02/03/2016 17:55, Mark Rotteveel escreveu:
> On 2-3-2016 20:56, Adriano dos Santos Fernandes wrote:
>> There is no ICU 5.6. Did you downloaded the 56.1 version?
> 
> Yes, sorry. I downloaded 56.1.
> 

Can you then test setting the version 56.1 instead of 5.6 then?


Adriano

--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] RFC: Tablespaces

[Dimitry Sibiryakov]

02.03.2016 22:51, Vlad Khorsun wrote:
> Blobs could be moved into separate tablespace. It could make backup of
> "data" tablespace faster and smaller. We can even think about "offline"
> tablespace.

>Also, PIP and Header page. Should every tablespace contains its own PIP ?
> Currently, every page space have own PIP, but only DP_PAGE_SPACE contains
> own Header page..

   How about TIP?
   How will be enforced consistency between tablespaces? How to detect and 
handle cases if 
tablespace file is lost or is older/newer that main file?

-- 
   WBR, SD.

--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Creating collations with extra ICU version

[Adriano dos Santos Fernandes]

Em 02/03/2016 17:55, Mark Rotteveel escreveu:
> On 2-3-2016 20:56, Adriano dos Santos Fernandes wrote:
>> There is no ICU 5.6. Did you downloaded the 56.1 version?
> 
> Yes, sorry. I downloaded 56.1.
> 

Can you then test setting the version 56.1 instead of 5.6 then?


Adriano

--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] RFC: Tablespaces

[Vlad Khorsun]

02.03.2016 23:23, Dmitry Yemanov wrote:
>
> Historically, Firebird databases consist of a sequential set of pages of
> the fixed size (4-16KB currently). This page set is distributed across
> one (usually) or multiple files (*) The page number initially was SLONG,
> now it's ULONG. So the theoretically possible maximum database size is
> currently limited to 2^32 * 16KB.
>
> When we speak about tablespaces, it usually means that the database
> consists of multiple files and different database object are stored in
> different files. Each such file is named within a database and called a
> tablespace. And each tablespace has its own page set and page numbering.
>
> A typical usage pattern is that tablespaces are used to separate table
> data from indices (and logs from the rest of the database) and thus
> allow better concurrent performance due to parallel I/O. Often it's
> argued that RAIDs now handle the same job and maybe even better. For
> many usage cases - maybe. But I'm pretty sure that the opposite cases
> are also possible, when a carefully designed partitioning could
> outperform automatic RAID data management.

   Blobs could be moved into separate tablespace. It could make backup of
"data" tablespace faster and smaller. We can even think about "offline"
tablespace.

> Another usage case could be extending the database size beyond the
> current limits. The limit is 64TB, the biggest FB database I known is
> 7TB. Not that far, I'd say. The limit may be shifted with even larger
> page sizes, but it has its drawbacks as well.
>
> Someone may think about per-tablespace physical backups and other
> possible usage cases. So I'm sure this feature is something to be at
> least considered. From another side, tablespaces complicate maintenance,
> so it's something more for enterprise users rather than for common FB users.
>
> Now back to the code. During the Firebird development, we have
> introduced a concept of "page spaces", represented with a PageSpace
> class. It implements a two-level numbering for database pages: pagespace
> ID + page number. The whole engine is aware of that.

   There is implicit assumption that all table's pointer, data, index and blob
pages allocated at the same tablespace.

> Default pagespace
> (ID == 0, IIRC) is reserved to the database file(s). Non-zero pagespace
> IDs are currently used for GTTs (global temporary tables) that have
> their data/indices stored in temporary files.

   pag.h contains following:

// page spaces below TEMP_PAGE_SPACE is regular database pages
// TEMP_PAGE_SPACE and page spaces above TEMP_PAGE_SPACE is temporary pages
const USHORT DB_PAGE_SPACE  = 1;
const USHORT TEMP_PAGE_SPACE= 256;


> Technically, nothing prevents us from declaring named tablespaces via
> DDL (CREATE/ALTER/DROP TABLESPACE?), storing their definitions inside
> the metadata (RDB$TABLESPACES table?), allocating some pagespace ID to
> the every tablespace, and allowing to specify a tablespace when creating
> database objects (tables, indices, what else?).
>
> Of course, there are more details hidden that must be addressed. Maybe
> I'm missing something in my review. But I think this thread could be a
> good starting point for discussion.

   Shadows. It is not clear (for me at least) should a shadow be defined for
a whole database or per-tablespace level ?

   Also, PIP and Header page. Should every tablespace contains its own PIP ?
Currently, every page space have own PIP, but only DP_PAGE_SPACE contains
own Header page..

> Others are welcome to contribute their thoughts.
>
> (*) My personal opinion is that legacy multi-file databases must die,
> preferrably in FB4. They make zero sense in modern filesystems. They're
> not supported by nbackup. They may complicate implementation of
> tablespaces. Anyone here still using multi-file databases?

   Agree, we should better remove legacy multi-file feature.

Regards,
Vlad

--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] gpre and boolean fields

[James Starkey]

I care about it.  It was my first C program.  But that doesn't mean I ever
want to use it again.

On Wednesday, March 2, 2016, Dmitry Yemanov  wrote:

> 03.03.2016 00:21, Dimitry Sibiryakov wrote:
> >
> > Do you agree that support for boolean fields in gpre is a good thing?
>
> Yes, I do. I know almost nobody cares about GPRE nowadays as it's not
> widely used. But if we can maintain and extend it, why not doing that. I
> just hope your patch will not touch /jrd and /dsql...
>
>
> Dmitry
>
>
>
> --
> Site24x7 APM Insight: Get Deep Visibility into Application Performance
> APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
> Monitor end-to-end web transactions and take corrective actions now
> Troubleshoot faster and improve end-user experience. Signup Now!
> http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
> Firebird-Devel mailing list, web interface at
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>


-- 
Jim Starkey
--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] RFC: Tablespaces

[James Starkey]

Multi-file databases were implemente to handle databases larger than the
disk or file systen size.  Disks have gotten a great deal larger, but so
have databases, so obviously something has to give to support your 7 TB
database.I sense an interesting design opportunity.


On Wednesday, March 2, 2016, Dmitry Yemanov  wrote:

>
> Historically, Firebird databases consist of a sequential set of pages of
> the fixed size (4-16KB currently). This page set is distributed across
> one (usually) or multiple files (*) The page number initially was SLONG,
> now it's ULONG. So the theoretically possible maximum database size is
> currently limited to 2^32 * 16KB.
>
> When we speak about tablespaces, it usually means that the database
> consists of multiple files and different database object are stored in
> different files. Each such file is named within a database and called a
> tablespace. And each tablespace has its own page set and page numbering.
>
> A typical usage pattern is that tablespaces are used to separate table
> data from indices (and logs from the rest of the database) and thus
> allow better concurrent performance due to parallel I/O. Often it's
> argued that RAIDs now handle the same job and maybe even better. For
> many usage cases - maybe. But I'm pretty sure that the opposite cases
> are also possible, when a carefully designed partitioning could
> outperform automatic RAID data management.
>
> Another usage case could be extending the database size beyond the
> current limits. The limit is 64TB, the biggest FB database I known is
> 7TB. Not that far, I'd say. The limit may be shifted with even larger
> page sizes, but it has its drawbacks as well.
>
> Someone may think about per-tablespace physical backups and other
> possible usage cases. So I'm sure this feature is something to be at
> least considered. From another side, tablespaces complicate maintenance,
> so it's something more for enterprise users rather than for common FB
> users.
>
> Now back to the code. During the Firebird development, we have
> introduced a concept of "page spaces", represented with a PageSpace
> class. It implements a two-level numbering for database pages: pagespace
> ID + page number. The whole engine is aware of that. Default pagespace
> (ID == 0, IIRC) is reserved to the database file(s). Non-zero pagespace
> IDs are currently used for GTTs (global temporary tables) that have
> their data/indices stored in temporary files.
>
> Technically, nothing prevents us from declaring named tablespaces via
> DDL (CREATE/ALTER/DROP TABLESPACE?), storing their definitions inside
> the metadata (RDB$TABLESPACES table?), allocating some pagespace ID to
> the every tablespace, and allowing to specify a tablespace when creating
> database objects (tables, indices, what else?).
>
> Of course, there are more details hidden that must be addressed. Maybe
> I'm missing something in my review. But I think this thread could be a
> good starting point for discussion.
>
> Others are welcome to contribute their thoughts.
>
> (*) My personal opinion is that legacy multi-file databases must die,
> preferrably in FB4. They make zero sense in modern filesystems. They're
> not supported by nbackup. They may complicate implementation of
> tablespaces. Anyone here still using multi-file databases?
>
>
> Dmitry
>
>
>
> --
> Site24x7 APM Insight: Get Deep Visibility into Application Performance
> APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
> Monitor end-to-end web transactions and take corrective actions now
> Troubleshoot faster and improve end-user experience. Signup Now!
> http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
> Firebird-Devel mailing list, web interface at
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>


-- 
Jim Starkey
--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Creating collations with extra ICU version

[Mark Rotteveel]

On 2-3-2016 20:56, Adriano dos Santos Fernandes wrote:
> There is no ICU 5.6. Did you downloaded the 56.1 version?

Yes, sorry. I downloaded 56.1.

Mark
-- 
Mark Rotteveel

--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Creating collations with extra ICU version

[Mark Rotteveel]

Could anyone look at this?

Mark

On 27-2-2016 14:00, Mark Rotteveel wrote:
> In an attempt to find an answer to a stackoverflow question
> (http://stackoverflow.com/questions/35581763/firebird-utf-8-german-phonebook-sorting),
> I installed an extra ICU library (ICU 5.6) in my Firebird 2.5.5 install.
>
> And I ran into a variety of problems.
>
> I added to /bin
>
> * icudt56.dll
> * icuin56.dll
> * icuuc56.dll
>
> And modified fbintl.conf to
>
> 
>   icu_versionsdefault 5.6
> 
>
> With this the statement:
>
> create collation unicode_de1 for utf8 from unicode
>  case insensitive 'LOCALE=de_DE';
>
> fails with
> SQL Message : -607
> This operation is not defined for system tables.
>
> Engine Code: 335544351
> Engine Message :
> unsuccessful metadata update
> Invalid collation attributes
>
> And adding the ICU version makes it work.
>
> create collation unicode_de1 for utf8 from unicode
>  case insensitive 'ICU-VERSION=5.6;LOCALE=de_DE';
>
> However using this collation does not work. For example:
>
> SELECT r.FIRSTNAME, r.LASTNAME
> FROM TABLE_NAME r order by r.LASTNAME collate unicode_de1, r.FIRSTNAME
>
> Results in error:
> SQL Message : -204
> Undefined name
>
> Engine Code: 335544855
> Engine Message :
> COLLATION UNICODE_DE1 for CHARACTER SET UTF8 is not installed
>
> Looking at RDB$COLLATIONS, the column RDB$SPECIFIC_ATTRIBUTES does not
> include the `ICU-VERSION=5.6` attribute. I can make it work by either
> changing fbintl.conf to
>
> 
> icu_versions 5.6
> 
>
> or by adding the version attribute to the collation by executing
>
> UPDATE RDB$COLLATIONS
> SET RDB$SPECIFIC_ATTRIBUTES='ICU-VERSION=5.6;LOCALE=de_DE'
> WHERE RDB$COLLATION_NAME = 'UNICODE_DE1'
>
> Is this a bug, or did I do something wrong?
>
> Now the second part of the problem: the stackoverflow question wants to
> define the German phonebook sort order. Looking at the CLDR data and the
> ICU documentation, this would mean that the locale is
> de@collation=phonebook or de__PHONEBOOK:
>
> create collation unicode_de1 for utf8 from unicode
> case insensitive 'ICU-VERSION=5.6;LOCALE=de@collation=phonebook';
>
> However this doesn't work nor with de__PHONEBOOK: I get a "Invalid
> collation attributes" error.
>
> Is this the wrong way to create this collation, or is Firebird parsing
> the attributes incorrectly?
>
> Mark
>


-- 
Mark Rotteveel

--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] GitHub

[Arno Brinkman]

Hi,

> Firebird Project will be moving its repositories to GitHub soon.

> I'm asking present contributors to create accounts there. If anyone 
> (including past contributors) wants your past commits to be 
> automatically linked to your GitHub account and be shown in the 
> statistics, please report your account name in this thread, or make sure 
> that your *.users.sourceforge.net email is added as a secondary one at 
> GitHub.

My accountname is ArnoBrinkman

Kind Regards,
Arno Brinkman


--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Record level compression for V4

[Mark Rotteveel]

On 2-3-2016 18:41, Slavomir Skopalik wrote:
> Hi Jim,
> I know, but in current situation is little problematic.
>
> Current compression is doing on record fragment, not on full record.
> I was hacked Elekt Labs RLE to be able work in this situation.
> My tests show big advantage compared to current V3 RLE.
>
> If we switch to real record level compression/encoding this will generate
> significant performance boost for encoding/decoding.
 >
> To do this I will need some help from community to find right place for
> compression/decompression.

Sounds like a good thing.

> When we have record compression ready, it can be used not only for
> remote, but also for temp spaces.

With the zlib support in the v13 wire protocol, I am not sure another 
layer of compression in the protocol is a good idea. If it happens 
though, I would really appreciate clear specifications outside the code.

Mark
-- 
Mark Rotteveel

--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Core-1686

[Atri Sharma]

Thanks a ton!

I am on it.

Can we also please start discussing the tablespaces, while I build Firebird
on Fedora?

Regards,

Atri

On Wed, Mar 2, 2016 at 1:32 PM, Dmitry Yemanov  wrote:

> 02.03.2016 15:59, Atri Sharma wrote:
>
> > BTW I tried navigating the codebase to find the parser and rewriter,
> > along with table commands, but somehow got lost in the structure.
> >
> > Can anyone please point me to it?
>
> /dsql/parse.y is the grammar. It generates execution nodes as class
> instances that are implemented inside the /dsql directory, grouped
> inside ExprNodes.*, StmtNodes.*, DdlNodes.*, etc.
>
> These classes encapsulate [almost] everything requires to compile,
> rewrite (if possible) and execute them. Optimization is performed
> separately, but just a few nodes need this step.
>
>
> Dmitry
>
>
>
> --
> Site24x7 APM Insight: Get Deep Visibility into Application Performance
> APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
> Monitor end-to-end web transactions and take corrective actions now
> Troubleshoot faster and improve end-user experience. Signup Now!
> http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
> Firebird-Devel mailing list, web interface at
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>



-- 
Regards,

Atri
*l'apprenant*
--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] [Firebird-checkins] SF.net SVN: firebird:[63072] firebird/trunk/src

[Dimitry Sibiryakov]

02.03.2016 19:22, Dmitry Yemanov wrote:
> When did the project politics change to allow not approved patches?

   When participation in development of the project had been limited to chosen 
ones only?..

-- 
   WBR, SD.

--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] GitHub

[Adriano dos Santos Fernandes]

Em 02/03/2016 15:37, Egor Pugin escreveu:
> One more reason is that you do not have 'core' word in svn address.
> You have 'firebird/trunk/...' and not 'core/trunk/...'.
> 

So, we fixed the previous mistake. ;)


Adriano

--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] GitHub

[Egor Pugin]

One more reason is that you do not have 'core' word in svn address.
You have 'firebird/trunk/...' and not 'core/trunk/...'.

On 2 March 2016 at 21:27, Dmitry Yemanov  wrote:
> 02.03.2016 16:16, Egor Pugin wrote:
>
>> What about just 'firebird'? 'core' is misleading.
>> It does not matter that the same word repeats in address. See:
>> https://github.com/git/git
>> https://github.com/FFmpeg/FFmpeg
>> https://github.com/openssl/openssl
>> and many others...
>
> Personally, I don't have any preference. "core" was chosen to
> distinguish from other repos: jaybird, python, docs, QA, etc.
>
>
> Dmitry
>
>
> --
> Site24x7 APM Insight: Get Deep Visibility into Application Performance
> APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
> Monitor end-to-end web transactions and take corrective actions now
> Troubleshoot faster and improve end-user experience. Signup Now!
> http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
> Firebird-Devel mailing list, web interface at 
> https://lists.sourceforge.net/lists/listinfo/firebird-devel



-- 
Egor Pugin

--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Core-1686

[Dmitry Yemanov]

02.03.2016 15:59, Atri Sharma wrote:

> BTW I tried navigating the codebase to find the parser and rewriter,
> along with table commands, but somehow got lost in the structure.
>
> Can anyone please point me to it?

/dsql/parse.y is the grammar. It generates execution nodes as class 
instances that are implemented inside the /dsql directory, grouped 
inside ExprNodes.*, StmtNodes.*, DdlNodes.*, etc.

These classes encapsulate [almost] everything requires to compile, 
rewrite (if possible) and execute them. Optimization is performed 
separately, but just a few nodes need this step.


Dmitry


--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] GitHub

[Dmitry Yemanov]

02.03.2016 16:16, Egor Pugin wrote:

> What about just 'firebird'? 'core' is misleading.
> It does not matter that the same word repeats in address. See:
> https://github.com/git/git
> https://github.com/FFmpeg/FFmpeg
> https://github.com/openssl/openssl
> and many others...

Personally, I don't have any preference. "core" was chosen to 
distinguish from other repos: jaybird, python, docs, QA, etc.


Dmitry


--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] [Firebird-checkins] SF.net SVN: firebird:[63072] firebird/trunk/src

[Dmitry Yemanov]

Dimitry,

> Revision: 63072
>http://sourceforge.net/p/firebird/code/63072
> Author:   aafemt
> Date: 2016-03-02 15:33:16 + (Wed, 02 Mar 2016)
> Log Message:
> ---
> Savepoints refactoring that fixes CORE-4701, CORE-4424 and CORE-4483

When did the project politics change to allow not approved patches? Be 
prepared to have it rolled back, maybe partially.


Dmitry


--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Record level compression for V4

[Slavomir Skopalik]

Hi Jim,
I know, but in current situation is little problematic.

Current compression is doing on record fragment, not on full record.
I was hacked Elekt Labs RLE to be able work in this situation.
My tests show big advantage compared to current V3 RLE.

If we switch to real record level compression/encoding this will generate
significant performance boost for encoding/decoding.
To do this I will need some help from community to find right place for 
compression/decompression.

When we have record compression ready, it can be used not only for 
remote, but also for temp spaces.

Slavek

Ing. Slavomir Skopalik
Executive Head
Elekt Labs s.r.o.
Collection and evaluation of data from machines and laboratories
by means of system MASA (http://www.elektlabs.cz/m2demo)
-
Address:
Elekt Labs s.r.o.
Chaloupky 158
783 72 Velky Tynec
Czech Republic
---
Mobile: +420 724 207 851
icq:199 118 333
skype:skopaliks
e-mail:skopa...@elektlabs.cz
http://www.elektlabs.cz

On 2.3.2016 17:52, Jim Starkey wrote:
> On 3/2/2016 10:08 AM, Slavomir Skopalik wrote:
>> Hi,
>> is it good time (V4) to commit new record level compression?
>>
>> http://elektlabs.cz/fbrle/
>>
>> If yes, will you need my help for this task?
>>
>> Slavek
>>
> There are other encoding/compression schemes that need to be considered,
> in particular, value based encoding, which would also work very well in
> the remote protocol.
>
> --
> Site24x7 APM Insight: Get Deep Visibility into Application Performance
> APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
> Monitor end-to-end web transactions and take corrective actions now
> Troubleshoot faster and improve end-user experience. Signup Now!
> http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
> Firebird-Devel mailing list, web interface at 
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>



--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] GitHub

[Egor Pugin]

>  It matches component name in tracker.

If tracker will be reconfigured for github, maybe 'core' can be renamed too?

On 2 March 2016 at 18:47, Arno Brinkman  wrote:
> I understand i need to create a GitHub account then.
> When will the transistion start?
>
>
> Kind Regards,
> Arno Brinkman
>
>
>
> -Oorspronkelijk bericht-
> From: Dmitry Yemanov
> Sent: Wednesday, March 2, 2016 12:18 PM
> To: For discussion among Firebird Developers
> Subject: [Firebird-devel] GitHub
>
> All,
>
> Firebird Project will be moving its repositories to GitHub soon.
>
> I'm asking present contributors to create accounts there. If anyone
> (including past contributors) wants your past commits to be
> automatically linked to your GitHub account and be shown in the
> statistics, please report your account name in this thread, or make sure
> that your *.users.sourceforge.net email is added as a secondary one at
> GitHub.
>
>
> Dmitry
>
> --
> Site24x7 APM Insight: Get Deep Visibility into Application Performance
> APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
> Monitor end-to-end web transactions and take corrective actions now
> Troubleshoot faster and improve end-user experience. Signup Now!
> http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
> Firebird-Devel mailing list, web interface at
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>
>
> --
> Site24x7 APM Insight: Get Deep Visibility into Application Performance
> APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
> Monitor end-to-end web transactions and take corrective actions now
> Troubleshoot faster and improve end-user experience. Signup Now!
> http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
> Firebird-Devel mailing list, web interface at 
> https://lists.sourceforge.net/lists/listinfo/firebird-devel



-- 
Egor Pugin

--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] GitHub

[Arno Brinkman]

I understand i need to create a GitHub account then.
When will the transistion start?


Kind Regards,
Arno Brinkman



-Oorspronkelijk bericht- 
From: Dmitry Yemanov
Sent: Wednesday, March 2, 2016 12:18 PM
To: For discussion among Firebird Developers
Subject: [Firebird-devel] GitHub

All,

Firebird Project will be moving its repositories to GitHub soon.

I'm asking present contributors to create accounts there. If anyone
(including past contributors) wants your past commits to be
automatically linked to your GitHub account and be shown in the
statistics, please report your account name in this thread, or make sure
that your *.users.sourceforge.net email is added as a secondary one at
GitHub.


Dmitry

--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel 


--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Improve compilation on OS X El Capitan

[Paul Beach]

> Is there anything wrong with my previous message?

No

> Should I do things differently?

No

> Is compiling Firebird on OS X El Capitan supported?

Yes - it worked (with some minor issues) the last time I looked 
at it. I intend to sort out the port of FB3 now that RC2 is about
to be released as soon as I can find some spare time.

Paul

--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Improve compilation on OS X El Capitan

[Mark Rotteveel]

On 2016-03-02 15:25, Quentin Pradet wrote:
> Hello,
>
> Is there anything wrong with my previous message?
> Should I do things differently?
> Is compiling Firebird on OS X El Capitan supported?

Could you include your previous message for context?

Mark

--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Improve compilation on OS X El Capitan

[Quentin Pradet]

Hello,

Is there anything wrong with my previous message?
Should I do things differently?
Is compiling Firebird on OS X El Capitan supported?

Thanks,
Quentin
--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] GitHub

[Michal Kubecek]

On Wed, Mar 02, 2016 at 10:45:35AM -0300, Adriano dos Santos Fernandes wrote:
> Em 02/03/2016 09:31, Michal Kubecek escreveu:
> > On Wed, Mar 02, 2016 at 02:18:27PM +0300, Dmitry Yemanov wrote:
> >>
> >> Firebird Project will be moving its repositories to GitHub soon.
> > 
> > Is the fact that the git repository hasn't been updated since Sunday
> > (and therefore has no B3_0_Release branch) related to this migration
> > or is it a different problem?
> > 
> 
> The fact is more this: :D
> 
> http://stackoverflow.com/questions/35726537/track-a-branch-in-a-bare-git-svn

That was my first hypothesis. :-)

> I didn't care too much because it's going to be replaced...

Makes sense.

Michal Kubecek

--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Core-1686

[Atri Sharma]

On Wed, Mar 2, 2016 at 7:40 PM, Dimitry Sibiryakov  wrote:

> 02.03.2016 15:07, Atri Sharma wrote:
> > > I assume thats the raw YAML parser,right?
> >
> > Not YAML, but yacc.
> >
> >
> > Meant Yacc, sorry!
>
>It is btyacc, which you would notice if you built Firebird at least
> once...
>


> I do not have access to my personal laptop right now, will be able to
> access it later today,when I can build Firebird...
>
--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Core-1686

[Dimitry Sibiryakov]

02.03.2016 15:07, Atri Sharma wrote:
> > I assume thats the raw YAML parser,right?
>
> Not YAML, but yacc.
>
>
> Meant Yacc, sorry!

   It is btyacc, which you would notice if you built Firebird at least once...

-- 
   WBR, SD.

--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Core-1686

[Mark Rotteveel]

On 2016-03-02 14:58, Atri Sharma wrote:
> Thanks a ton!
>
> I assume thats the raw YAML parser,right?

Not YAML, but yacc.

Mark

--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Core-1686

[Atri Sharma]

On Wed, Mar 2, 2016 at 7:34 PM, Mark Rotteveel  wrote:

> On 2016-03-02 14:58, Atri Sharma wrote:
> > Thanks a ton!
> >
> > I assume thats the raw YAML parser,right?
>
> Not YAML, but yacc.
>
>
Meant Yacc, sorry!
--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Core-1686

[Atri Sharma]

>
>
> > This is me : https://uk.linkedin.com/in/atrisharma
> >
>
> I see you implemented "Grouping Sets" for PostgreSQL... It's a good task
> to Firebird v4.
>
>
Thats a difficult project, will attempt it after a basic comfort in the
codebase!
--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Core-1686

[Atri Sharma]

Thanks a ton!

I assume thats the raw YAML parser,right?

On Wed, Mar 2, 2016 at 7:26 PM, Mark Rotteveel  wrote:

> On 2016-03-02 13:59, Atri Sharma wrote:
> > BTW I tried navigating the codebase to find the parser and rewriter,
> > along with table commands, but somehow got lost in the structure.
> >
> > Can anyone please point me to it?
>
> The statement grammar is used to generate the parser:
>
> src/dsql/parse.y
>
> For the other parts maybe someone more intimately familiar with
> Firebird core can answer that.
>
> Mark
>
>
>
> --
> Site24x7 APM Insight: Get Deep Visibility into Application Performance
> APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
> Monitor end-to-end web transactions and take corrective actions now
> Troubleshoot faster and improve end-user experience. Signup Now!
> http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
> Firebird-Devel mailing list, web interface at
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>



-- 
Regards,

Atri
*l'apprenant*
--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Core-1686

[Mark Rotteveel]

On 2016-03-02 13:59, Atri Sharma wrote:
> BTW I tried navigating the codebase to find the parser and rewriter,
> along with table commands, but somehow got lost in the structure.
>
> Can anyone please point me to it?

The statement grammar is used to generate the parser:

src/dsql/parse.y

For the other parts maybe someone more intimately familiar with 
Firebird core can answer that.

Mark


--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] GitHub

[Adriano dos Santos Fernandes]

Em 02/03/2016 09:31, Michal Kubecek escreveu:
> On Wed, Mar 02, 2016 at 02:18:27PM +0300, Dmitry Yemanov wrote:
>>
>> Firebird Project will be moving its repositories to GitHub soon.
> 
> Is the fact that the git repository hasn't been updated since Sunday
> (and therefore has no B3_0_Release branch) related to this migration
> or is it a different problem?
> 

The fact is more this: :D

http://stackoverflow.com/questions/35726537/track-a-branch-in-a-bare-git-svn

I didn't care too much because it's going to be replaced...


Adriano

--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Core-1686

[Adriano dos Santos Fernandes]

Em 02/03/2016 08:15, Atri Sharma escreveu:
> Thanks for the heads up but I cant :)
> 
> This is me : https://uk.linkedin.com/in/atrisharma
> 

I see you implemented "Grouping Sets" for PostgreSQL... It's a good task
to Firebird v4.


Adriano

--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] GitHub

[Egor Pugin]

What about just 'firebird'? 'core' is misleading.
It does not matter that the same word repeats in address. See:
https://github.com/git/git
https://github.com/FFmpeg/FFmpeg
https://github.com/openssl/openssl
and many others...

On 2 March 2016 at 15:57, Dmitry Yemanov  wrote:
> 02.03.2016 15:53, Dimitry Sibiryakov wrote:
>
>> Am I alone who has no idea what the name is?..
>
> https://github.com/FirebirdSQL/core
>
>
> Dmitry
>
>
>
> --
> Site24x7 APM Insight: Get Deep Visibility into Application Performance
> APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
> Monitor end-to-end web transactions and take corrective actions now
> Troubleshoot faster and improve end-user experience. Signup Now!
> http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
> Firebird-Devel mailing list, web interface at 
> https://lists.sourceforge.net/lists/listinfo/firebird-devel



-- 
Egor Pugin

--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Core-1686

[Atri Sharma]

BTW I tried navigating the codebase to find the parser and rewriter, along
with table commands, but somehow got lost in the structure.

Can anyone please point me to it?

On Wed, Mar 2, 2016 at 5:49 PM, Atri Sharma  wrote:

> Super,  will wait for it
> On 2 Mar 2016 5:43 pm, "Dmitry Yemanov"  wrote:
>
>> 02.03.2016 15:03, Atri Sharma wrote:
>>
>> > Sounds something I can pick up...
>>
>> I will start a new thread on this subject later today, to discuss what
>> and how could be done in this regard.
>>
>>
>> Dmitry
>>
>>
>>
>> --
>> Site24x7 APM Insight: Get Deep Visibility into Application Performance
>> APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
>> Monitor end-to-end web transactions and take corrective actions now
>> Troubleshoot faster and improve end-user experience. Signup Now!
>> http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
>> Firebird-Devel mailing list, web interface at
>> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>>
>


-- 
Regards,

Atri
*l'apprenant*
--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] GitHub

[Dmitry Yemanov]

02.03.2016 15:53, Dimitry Sibiryakov wrote:

> Am I alone who has no idea what the name is?..

https://github.com/FirebirdSQL/core


Dmitry



--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] GitHub

[Dmitry Yemanov]

02.03.2016 15:44, Dimitry Sibiryakov wrote:

> 02.03.2016 12:18, Dmitry Yemanov wrote:
>> Firebird Project will be moving its repositories to GitHub soon.
>
> Will be a new repository created?

The current mirror repo will be replaced with a freshly imported one. 
The repo name is likely to remain the same.


Dmitry


--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] GitHub

[Dimitry Sibiryakov]

02.03.2016 12:18, Dmitry Yemanov wrote:
> Firebird Project will be moving its repositories to GitHub soon.

   Will be a new repository created?

-- 
   WBR, SD.

--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Core-1686

[Gabor Boros]

2016. 03. 02. 13:19 keltezéssel, Atri Sharma írta:
> Super,  will wait for it

Atri,

Nice to see somebody want to contribute to the project.
Please write your message below the quoted text and cut the not needed 
pieces from it as I do in this message. (I am just a user not developer 
or list admin.)

Gabor

--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] GitHub

[Michal Kubecek]

On Wed, Mar 02, 2016 at 02:18:27PM +0300, Dmitry Yemanov wrote:
> 
> Firebird Project will be moving its repositories to GitHub soon.

Is the fact that the git repository hasn't been updated since Sunday
(and therefore has no B3_0_Release branch) related to this migration
or is it a different problem?

  Michal Kubecek


--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Core-1686

[Atri Sharma]

Super,  will wait for it
On 2 Mar 2016 5:43 pm, "Dmitry Yemanov"  wrote:

> 02.03.2016 15:03, Atri Sharma wrote:
>
> > Sounds something I can pick up...
>
> I will start a new thread on this subject later today, to discuss what
> and how could be done in this regard.
>
>
> Dmitry
>
>
>
> --
> Site24x7 APM Insight: Get Deep Visibility into Application Performance
> APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
> Monitor end-to-end web transactions and take corrective actions now
> Troubleshoot faster and improve end-user experience. Signup Now!
> http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
> Firebird-Devel mailing list, web interface at
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>
--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Core-1686

[Dmitry Yemanov]

02.03.2016 15:03, Atri Sharma wrote:

> Sounds something I can pick up...

I will start a new thread on this subject later today, to discuss what 
and how could be done in this regard.


Dmitry


--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Core-1686

[Atri Sharma]

Sounds something I can pick up...
On 2 Mar 2016 5:15 pm, "Dmitry Yemanov"  wrote:

> 02.03.2016 14:42, Atri Sharma wrote:
>
> > Is the tablespaces question still relevant?
>
> Yes.
>
>
> Dmitry
>
>
>
> --
> Site24x7 APM Insight: Get Deep Visibility into Application Performance
> APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
> Monitor end-to-end web transactions and take corrective actions now
> Troubleshoot faster and improve end-user experience. Signup Now!
> http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
> Firebird-Devel mailing list, web interface at
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>
--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Core-1686

[Dmitry Yemanov]

02.03.2016 14:42, Atri Sharma wrote:

> Is the tablespaces question still relevant?

Yes.


Dmitry


--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] GitHub

[Lester Caine]

On 02/03/16 11:18, Dmitry Yemanov wrote:
> Firebird Project will be moving its repositories to GitHub soon.

As someone who has had to put up with the less than useful manor that
'github' handles code on-line can I pass on a useful approach that I've
found makes it a lot less painful ;)

Mercurial (hg) has had a much better support cross OS since day one, and
can handle git repositories transparently via hggit.
http://tortoisehg.bitbucket.org/ provides a clean way to view the
history of any file, and manage merging with local copies easily on both
windows and any linux system.

While most installs include hggit ( which may need simply to be enabled
) http://hg-git.github.io/ has the current version, but like everything
these days, keeping everything in sync when someone breaks one of the
python libraries can be a problem. Is there such a thing as a stable
development platform? Just which compiler, package handler and build
process should one be using :(

-- 
Lester Caine - G8HFL
-
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk

--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Core-1686

[Atri Sharma]

Is the tablespaces question still relevant?

On Wed, Mar 2, 2016 at 5:08 PM, Dmitry Yemanov  wrote:

> 02.03.2016 14:33, Atri Sharma wrote:
>
> > I meant I cannot participate in GSoC,assuming that is what you meant :)
>
> GSoC 2015 was running without our project, unfortunately. But these
> tasks are still relevant as an easy start.
>
>
> Dmitry
>
>
>
> --
> Site24x7 APM Insight: Get Deep Visibility into Application Performance
> APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
> Monitor end-to-end web transactions and take corrective actions now
> Troubleshoot faster and improve end-user experience. Signup Now!
> http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
> Firebird-Devel mailing list, web interface at
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>



-- 
Regards,

Atri
*l'apprenant*
--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Core-1686

[Dmitry Yemanov]

02.03.2016 14:33, Atri Sharma wrote:

> I meant I cannot participate in GSoC,assuming that is what you meant :)

GSoC 2015 was running without our project, unfortunately. But these 
tasks are still relevant as an easy start.


Dmitry


--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Core-1686

[Atri Sharma]

I am pretty sure they arent simple, and hence I want to make sure that
wherever I invest my time with Firebird proves useful both for me and the
project, hence nitpicking where to start of f:)

On Wed, Mar 2, 2016 at 5:04 PM, Dmitry Yemanov  wrote:

> 02.03.2016 14:15, Atri Sharma wrote:
>
> > Thanks for the heads up but I cant :)
> >
> > This is me : https://uk.linkedin.com/in/atrisharma
>
> Some of those tasks are not that simple ;-) But feel free to choose what
> you're really interested in, I don't mind. The tracker is full of open
> tickets :-) And CORE-1686 can surely be a good adventure.
>
>
> Dmitry
>
>
>
> --
> Site24x7 APM Insight: Get Deep Visibility into Application Performance
> APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
> Monitor end-to-end web transactions and take corrective actions now
> Troubleshoot faster and improve end-user experience. Signup Now!
> http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
> Firebird-Devel mailing list, web interface at
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>



-- 
Regards,

Atri
*l'apprenant*
--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Core-1686

[Dmitry Yemanov]

02.03.2016 14:15, Atri Sharma wrote:

> Thanks for the heads up but I cant :)
>
> This is me : https://uk.linkedin.com/in/atrisharma

Some of those tasks are not that simple ;-) But feel free to choose what 
you're really interested in, I don't mind. The tracker is full of open 
tickets :-) And CORE-1686 can surely be a good adventure.


Dmitry


--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Core-1686

[Atri Sharma]

I meant I cannot participate in GSoC,assuming that is what you meant :)

On Wed, Mar 2, 2016 at 4:45 PM, Atri Sharma  wrote:

> Thanks for the heads up but I cant :)
>
> This is me : https://uk.linkedin.com/in/atrisharma
>
>
> On Wed, Mar 2, 2016 at 4:37 PM, Dmitry Yemanov 
> wrote:
>
>> 02.03.2016 07:00, Atri Sharma wrote:
>>
>> > Also, let me know if there is anything else that needs hands, and I will
>> > be glad to help with that.
>>
>> As a newcomer, you may also look here for possible tasks:
>> http://www.firebirdsql.org/en/gsoc/
>>
>>
>> Dmitry
>>
>>
>>
>> --
>> Site24x7 APM Insight: Get Deep Visibility into Application Performance
>> APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
>> Monitor end-to-end web transactions and take corrective actions now
>> Troubleshoot faster and improve end-user experience. Signup Now!
>> http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
>> Firebird-Devel mailing list, web interface at
>> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>>
>
>
>
> --
> Regards,
>
> Atri
> *l'apprenant*
>



-- 
Regards,

Atri
*l'apprenant*
--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Core-1686

[Dmitry Yemanov]

02.03.2016 14:09, Atri Sharma wrote:

> That's fine, I am fine with anything in the planner,  or maybe
> transactions ...

Then the start would be not from the planner, but from the statistics 
collector ;-)

Take a look at the GSTAT utility, located under /src/utilities/gstat/, 
the code is mostly limited to dba.epp. It scans the database and reports 
various statistics. The first step could be extending this tool to 
collect and report (optionally?) value distribution histograms for table 
columns (all? indexed? explicitly specified?).

At the same time, you would need to create memory structures to describe 
histograms. How many buckets? How to store very-selective and 
non-selective distributions? Etc.


Dmitry


--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Core-1686

[Atri Sharma]

On Wed, Mar 2, 2016 at 4:48 PM, Lester Caine  wrote:

> On 02/03/16 11:05, Dmitry Yemanov wrote:
> >> Any place where I can start hacking, reading about the architecture,
> >> > code pointers, guidance please?
> > Worth looking here:
> > http://www.ibphoenix.com/resources/documents/development
> > http://www.ibphoenix.com/resources/documents/design
> >
> > But basically you will have to learn from the source code.
>
> Atri ... It is some years since I actually compiled the code myself, I
> just use the Linux installs these days, but one 'ticket' that is
> probably missing from the 'todo' list is a more up to date set of notes
> extracted from the current code base. Producing something along those
> lines is probably a useful starting point and will help others as well.
>
>
>
That sounds good,will keep a notebook handy!

Thanks
--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] [FB-Tracker] Created: (CORE-5124) Make it possible to change ownership of database objects

[Alexander Peshkov (JIRA)]

Make it possible to change ownership of database objects


 Key: CORE-5124
 URL: http://tracker.firebirdsql.org/browse/CORE-5124
 Project: Firebird Core
  Issue Type: New Feature
  Components: Engine
Reporter: Alexander Peshkov


Each object in the database is owned by the user which created it. That user as 
an owner of the object has full access to it. It will be great to be able to 
change object's ownership (kind of 'chown' command in *nixes).

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira



--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] GitHub

[Dmitry Yemanov]

All,

Firebird Project will be moving its repositories to GitHub soon.

I'm asking present contributors to create accounts there. If anyone 
(including past contributors) wants your past commits to be 
automatically linked to your GitHub account and be shown in the 
statistics, please report your account name in this thread, or make sure 
that your *.users.sourceforge.net email is added as a secondary one at 
GitHub.


Dmitry

--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Core-1686

[Lester Caine]

On 02/03/16 11:05, Dmitry Yemanov wrote:
>> Any place where I can start hacking, reading about the architecture,
>> > code pointers, guidance please?
> Worth looking here:
> http://www.ibphoenix.com/resources/documents/development
> http://www.ibphoenix.com/resources/documents/design
> 
> But basically you will have to learn from the source code.

Atri ... It is some years since I actually compiled the code myself, I
just use the Linux installs these days, but one 'ticket' that is
probably missing from the 'todo' list is a more up to date set of notes
extracted from the current code base. Producing something along those
lines is probably a useful starting point and will help others as well.

-- 
Lester Caine - G8HFL
-
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk

--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Core-1686

[Dimitry Sibiryakov]

02.03.2016 12:05, Dmitry Yemanov wrote:
> I think CORE-1686 may actually be more complicated than it appears at
> the first glance. BTW, it has chances to be implemented by the core team
> soon.

   I think that CORE-4427 is a good candidate for start. It is about 
single-line patch but 
require to find a very exact place to put.

-- 
   WBR, SD.

--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Core-1686

[Dmitry Yemanov]

02.03.2016 07:00, Atri Sharma wrote:

> Also, let me know if there is anything else that needs hands, and I will
> be glad to help with that.

As a newcomer, you may also look here for possible tasks:
http://www.firebirdsql.org/en/gsoc/


Dmitry


--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Core-1686

[Atri Sharma]

That's fine, I am fine with anything in the planner,  or maybe transactions
...
On 2 Mar 2016 4:38 pm, "Dmitry Yemanov"  wrote:

> 01.03.2016 21:02, Atri Sharma wrote:
> >
> > I was looking into the bug tracker to pick something to hack on, and
> > found Core-1686. This seemed pretty interesting to me, but I have never
> > had a look at Firebird core before.
>
> I think CORE-1686 may actually be more complicated than it appears at
> the first glance. BTW, it has chances to be implemented by the core team
> soon.
>
> But if you insist, we may try to split this ticket into smaller tasks,
> so that you could choose something easier to start with, and maybe later
> coordinate your work with other team members.
>
> > Any place where I can start hacking, reading about the architecture,
> > code pointers, guidance please?
>
> Worth looking here:
> http://www.ibphoenix.com/resources/documents/development
> http://www.ibphoenix.com/resources/documents/design
>
> But basically you will have to learn from the source code.
>
>
> Dmitry
>
>
>
> --
> Site24x7 APM Insight: Get Deep Visibility into Application Performance
> APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
> Monitor end-to-end web transactions and take corrective actions now
> Troubleshoot faster and improve end-user experience. Signup Now!
> http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
> Firebird-Devel mailing list, web interface at
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>
--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Core-1686

[Dmitry Yemanov]

01.03.2016 21:02, Atri Sharma wrote:
>
> I was looking into the bug tracker to pick something to hack on, and
> found Core-1686. This seemed pretty interesting to me, but I have never
> had a look at Firebird core before.

I think CORE-1686 may actually be more complicated than it appears at 
the first glance. BTW, it has chances to be implemented by the core team 
soon.

But if you insist, we may try to split this ticket into smaller tasks, 
so that you could choose something easier to start with, and maybe later 
coordinate your work with other team members.

> Any place where I can start hacking, reading about the architecture,
> code pointers, guidance please?

Worth looking here:
http://www.ibphoenix.com/resources/documents/development
http://www.ibphoenix.com/resources/documents/design

But basically you will have to learn from the source code.


Dmitry


--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Core-1686

[Atri Sharma]

Sure.

One thing I am not sure about, is the internal structure of the code base.
There seems to be little  documentation around that and how to start
reading the source code. Any pointers?


On Wed, Mar 2, 2016 at 3:51 PM, Alex Peshkoff  wrote:

> On 03/02/2016 01:12 PM, Atri Sharma wrote:
> > Thanks Alex.
> >
> > I am looking forward to hack Firebird. Is there anything I can start off
> > with for v4,please?
>
> Choose any item from the tracker and send us patch for it.
>
>
>
> --
> Site24x7 APM Insight: Get Deep Visibility into Application Performance
> APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
> Monitor end-to-end web transactions and take corrective actions now
> Troubleshoot faster and improve end-user experience. Signup Now!
> http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
> Firebird-Devel mailing list, web interface at
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>



-- 
Regards,

Atri
*l'apprenant*
--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Core-1686

[Alex Peshkoff]

On 03/02/2016 01:12 PM, Atri Sharma wrote:
> Thanks Alex.
>
> I am looking forward to hack Firebird. Is there anything I can start off
> with for v4,please?

Choose any item from the tracker and send us patch for it.


--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Core-1686

[Dimitry Sibiryakov]

02.03.2016 11:12, Atri Sharma wrote:
> I am looking forward to hack Firebird. Is there anything I can start off with 
> for v4,please?

   For the beginning you should just build it. This process itself is not so 
trivial and 
will give you some understanding of source organization.

-- 
   WBR, SD.

--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Core-1686

[Atri Sharma]

Thanks Alex.

I am looking forward to hack Firebird. Is there anything I can start off
with for v4,please?

On Wed, Mar 2, 2016 at 3:38 PM, Alex Peshkoff  wrote:

> On 03/02/2016 11:26 AM, Atri Sharma wrote:
> > Hoping this is the correct mailing list for these questions
>
> More or less yes.
>
> > On 2 Mar 2016 9:30 am, "Atri Sharma"  wrote:
> >
> >> Also, let me know if there is anything else that needs hands, and I will
> >> be glad to help with that.
> >> On 1 Mar 2016 11:32 pm, "Atri Sharma"  wrote:
> >>
> >>> Team,
> >>>
> >>> I was looking into the bug tracker to pick something to hack on, and
> >>> found Core-1686. This seemed pretty interesting to me, but I have
> never had
> >>> a look at Firebird core before.
> >>>
> >>> Any place where I can start hacking, reading about the architecture,
> code
> >>> pointers, guidance please?
>
> Only code itself.
> http://sourceforge.net/p/firebird/code/HEAD/tree/
> We do not have fresh useful docs for it's internal structure.
>
>
>
> --
> Site24x7 APM Insight: Get Deep Visibility into Application Performance
> APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
> Monitor end-to-end web transactions and take corrective actions now
> Troubleshoot faster and improve end-user experience. Signup Now!
> http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
> Firebird-Devel mailing list, web interface at
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>



-- 
Regards,

Atri
*l'apprenant*
--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Core-1686

[Alex Peshkoff]

On 03/02/2016 11:26 AM, Atri Sharma wrote:
> Hoping this is the correct mailing list for these questions

More or less yes.

> On 2 Mar 2016 9:30 am, "Atri Sharma"  wrote:
>
>> Also, let me know if there is anything else that needs hands, and I will
>> be glad to help with that.
>> On 1 Mar 2016 11:32 pm, "Atri Sharma"  wrote:
>>
>>> Team,
>>>
>>> I was looking into the bug tracker to pick something to hack on, and
>>> found Core-1686. This seemed pretty interesting to me, but I have never had
>>> a look at Firebird core before.
>>>
>>> Any place where I can start hacking, reading about the architecture, code
>>> pointers, guidance please?

Only code itself.
http://sourceforge.net/p/firebird/code/HEAD/tree/
We do not have fresh useful docs for it's internal structure.


--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] [FB-Tracker] Created: (CORE-5123) can't mix in one process remote connection using fbclient.dll from 2.* (or 3.0) with embedded connection using fbclient.dll from 3.0.

[Nick (JIRA)]

can't mix in one process remote connection using fbclient.dll from 2.* (or 3.0) 
with embedded connection using fbclient.dll from 3.0.
-

 Key: CORE-5123
 URL: http://tracker.firebirdsql.org/browse/CORE-5123
 Project: Firebird Core
  Issue Type: Bug
  Components: API / Client Library
Affects Versions: 3.0 RC2
Reporter: Nick


- have runned firebird 2.5
- have only fbclient.dll from 2.5 in D:\Firebird\FB25Client
- have only fbclient.dll from 3.0 RC2 in D:\Firebird\FB30Client
- have all files from 3.0 RC2 in D:\Firebird\FB30
- all connections uses charset WIN1251.

code:
begin
  AttachDatabase('D:\Firebird\FB25Client\fbclient.dll', 
'127.0.0.1:D:\Data\FB25.fdb', 'SYSDBA', 'masterkey'); // remote connect to 2.5
  AttachDatabase('D:\Firebird\FB30\fbclient.dll', 'D:\Data\FB30.fdb', 'SYSDBA', 
'masterkey'); // embedded connect to 3.0
end.
Error on second attach:

Error loading plugin Engine12
Module D:\Firebird\FB30\plugins/Engine12 exists but can not be loaded
Unsuccessful execution caused by system error that does not preclude successful
execution of subsequent statements
GDS Code: 335545004, SQL Code: -901, Error Code: 684


Example with only 3.0 libraries:
begin
  AttachDatabase('D:\Firebird\FB30Client\fbclient.dll', 
'127.0.0.1:D:\Data\FB25.fdb', 'SYSDBA', 'masterkey'); // remote connect to 2.5
  AttachDatabase('D:\Firebird\FB30\fbclient.dll', 'D:\Data\FB30.fdb', 'SYSDBA', 
'masterkey'); // embedded connect to 3.0
end.
Error on second attach:

bad parameters on attach or create database
CHARACTER SET WIN1251 is not defined
Connection error
GDS Code: 335544325, SQL Code: -924, Error Code: 5



-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira



--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Core-1686

[Atri Sharma]

Hoping this is the correct mailing list for these questions
On 2 Mar 2016 9:30 am, "Atri Sharma"  wrote:

> Also, let me know if there is anything else that needs hands, and I will
> be glad to help with that.
> On 1 Mar 2016 11:32 pm, "Atri Sharma"  wrote:
>
>> Team,
>>
>> I was looking into the bug tracker to pick something to hack on, and
>> found Core-1686. This seemed pretty interesting to me, but I have never had
>> a look at Firebird core before.
>>
>> Any place where I can start hacking, reading about the architecture, code
>> pointers, guidance please?
>>
>> Regards,
>>
>> Atri
>>
>> --
>> Regards,
>>
>> Atri
>> *l'apprenant*
>>
>
--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel