Re: [Firebird-devel] Feature request & discussion for V4 (same as for V3)

2016-04-11 Thread Atri Sharma
> > > > > > > This optimization can only be done if constant conditions are in the > > SQL, so +0 like tricks would not be affected. > > I already considered that, it seems easy enough to implement. > > > > Worth having? -- Regards, Atri *l'apprenant* -

Re: [Firebird-devel] Feature request & discussion for V4 (same as for V3)

2016-04-11 Thread Atri Sharma
On Mon, Apr 11, 2016 at 6:15 PM, Dmitry Yemanov wrote: > 11.04.2016 14:40, Dimitry Sibiryakov wrote: > > > > While bug with orphan index nodes is living in the engine - index only > scan is > > impossible completely. > > Pure index-only scan - maybe. It's impossible without transaction > numbers

Re: [Firebird-devel] Atomics

2016-03-23 Thread Atri Sharma
+1 for a cross platform library On Wed, Mar 23, 2016 at 2:34 PM, Vlad Khorsun wrote: >All, > > in new codebase (v4) we going to use atomic operations more intensively > than > before. The question is: could we use standard features of C++11 or should > choose some 3rd party library (such as

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-5158) Extend ALTER EXTERNAL FUNCTION to adjust arguments

2016-03-20 Thread Atri Sharma
Does this sound like an easy place to start? On 20 Mar 2016 2:11 am, "Dmitry Yemanov (JIRA)" wrote: > Extend ALTER EXTERNAL FUNCTION to adjust arguments > -- > > Key: CORE-5158 > URL: http://tracker.firebirdsql.org/

Re: [Firebird-devel] RFC: Tablespaces

2016-03-03 Thread Atri Sharma
> > > I feel that tablespaces allow managing multiple independent identities > inside a database > > conveniently, and making stuff like backups pretty fast and granular. > >How are you going to solve problem with inconsistency between > tablespaces? > > > Which specific inconsistency can you

Re: [Firebird-devel] RFC: Tablespaces

2016-03-03 Thread Atri Sharma
> > > 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 > numbe

Re: [Firebird-devel] RFC: Tablespaces

2016-03-03 Thread Atri Sharma
On Thu, Mar 3, 2016 at 11:01 AM, Dmitry Yemanov wrote: > 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

Re: [Firebird-devel] RFC: Tablespaces

2016-03-02 Thread 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" t

Re: [Firebird-devel] Core-1686

2016-03-02 Thread 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 th

Re: [Firebird-devel] Core-1686

2016-03-02 Thread 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 wo

Re: [Firebird-devel] Core-1686

2016-03-02 Thread 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

Re: [Firebird-devel] Core-1686

2016-03-02 Thread 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! ---

Re: [Firebird-devel] Core-1686

2016-03-02 Thread 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 i

Re: [Firebird-devel] Core-1686

2016-03-02 Thread 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, "Dmi

Re: [Firebird-devel] Core-1686

2016-03-02 Thread 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 do

Re: [Firebird-devel] Core-1686

2016-03-02 Thread 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 > > > >

Re: [Firebird-devel] Core-1686

2016-03-02 Thread 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.

Re: [Firebird-devel] Core-1686

2016-03-02 Thread 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 wr

Re: [Firebird-devel] Core-1686

2016-03-02 Thread 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, Dmitr

Re: [Firebird-devel] Core-1686

2016-03-02 Thread 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 > >

Re: [Firebird-devel] Core-1686

2016-03-02 Thread Atri Sharma
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

Re: [Firebird-devel] Core-1686

2016-03-02 Thread 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-

Re: [Firebird-devel] Core-1686

2016-03-02 Thread 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 wr

Re: [Firebird-devel] Core-1686

2016-03-02 Thread 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 > > M

Re: [Firebird-devel] Core-1686

2016-03-02 Thread 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: > >&

Re: [Firebird-devel] Core-1686

2016-03-01 Thread Atri Sharma
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 interes

[Firebird-devel] Core-1686

2016-03-01 Thread Atri Sharma
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, At