Re: [Firebird-devel] RFC: Tablespaces

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

Re: [Firebird-devel] RFC: Tablespaces

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

Re: [Firebird-devel] RFC: Tablespaces

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. >

Re: [Firebird-devel] RFC: Tablespaces

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 >

Re: [Firebird-devel] RFC: Tablespaces

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

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

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

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

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

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

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

Re: [Firebird-devel] RFC: Tablespaces

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

Re: [Firebird-devel] GitHub

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

Re: [Firebird-devel] RFC: Tablespaces

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

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

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

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

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

Re: [Firebird-devel] RFC: Tablespaces

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,

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

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

Re: [Firebird-devel] RFC: Tablespaces

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

Re: [Firebird-devel] gpre and boolean fields

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? >

Re: [Firebird-devel] RFC: Tablespaces

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,

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

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

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

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

Re: [Firebird-devel] GitHub

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

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

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

Re: [Firebird-devel] Core-1686

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

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

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.

Re: [Firebird-devel] GitHub

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

Re: [Firebird-devel] GitHub

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

Re: [Firebird-devel] Core-1686

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

Re: [Firebird-devel] GitHub

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

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

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

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

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

Re: [Firebird-devel] GitHub

> 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

Re: [Firebird-devel] GitHub

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,

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

> 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

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

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

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

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

Re: [Firebird-devel] GitHub

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

Re: [Firebird-devel] Core-1686

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

Re: [Firebird-devel] Core-1686

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.

Re: [Firebird-devel] Core-1686

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 +

Re: [Firebird-devel] Core-1686

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!

Re: [Firebird-devel] Core-1686

> > > > 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!

Re: [Firebird-devel] Core-1686

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

Re: [Firebird-devel] Core-1686

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

Re: [Firebird-devel] GitHub

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

Re: [Firebird-devel] Core-1686

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

Re: [Firebird-devel] GitHub

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:

Re: [Firebird-devel] Core-1686

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,

Re: [Firebird-devel] GitHub

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 +

Re: [Firebird-devel] GitHub

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

Re: [Firebird-devel] GitHub

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

Re: [Firebird-devel] Core-1686

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

Re: [Firebird-devel] GitHub

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

Re: [Firebird-devel] Core-1686

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. > > >

Re: [Firebird-devel] Core-1686

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:

Re: [Firebird-devel] Core-1686

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 > > > >

Re: [Firebird-devel] Core-1686

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

Re: [Firebird-devel] GitHub

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

Re: [Firebird-devel] Core-1686

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,

Re: [Firebird-devel] Core-1686

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

Re: [Firebird-devel] Core-1686

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

Re: [Firebird-devel] Core-1686

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

Re: [Firebird-devel] Core-1686

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

Re: [Firebird-devel] Core-1686

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

Re: [Firebird-devel] Core-1686

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: > >

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

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

[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

Re: [Firebird-devel] Core-1686

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

Re: [Firebird-devel] Core-1686

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

Re: [Firebird-devel] Core-1686

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

Re: [Firebird-devel] Core-1686

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

Re: [Firebird-devel] Core-1686

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

Re: [Firebird-devel] Core-1686

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

Re: [Firebird-devel] Core-1686

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. --

Re: [Firebird-devel] Core-1686

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,

Re: [Firebird-devel] Core-1686

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

Re: [Firebird-devel] Core-1686

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

[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.

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:

Re: [Firebird-devel] Core-1686

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"