It might take several more days, till the new ll_bitemporal_correction function will appear in pg_bitemporal GitHub repo, but it is ready. I finished development and basic testing, and it works.
It means nothing for those who do not care about “the state of bitemporality”, but I know that some people care. For those people, I am happy to report, that finally I delivered what you guys have asked for a long time. Now, you can make bitemporal correction not just to the last effective interval, but to any stretch of time. It may cover several historical intervals, it may start in the middle. It can’t end i the middle, because I didn’t come up with any business case for such situation, but if there will be a demand, I am sure I can provide :). Overall – I am very happy about this result :). Stay tunes – I will post when it will be officially available.
On a different note – we are almost P12 compatible, only bitemporal referential integrity still does not work, but it will be fixed shortly.
Huge thank you for everybody who show interest in this activity:)
For those who are considering attending PG Conf NYC 2020: the last Day of the EarlyBird discount is January 31! The program (or at least most of it:)) is up, so you can decided which day(s) you want to attend in can’t make it for the whole week. There will be tons of interesting talks, I am already upset I won’t be able to be it three different rooms at the same time 🙂
For those who is interested in my presentations, here is the most complete information so far:
Boris and I will be doing the same Ultimate Optimization Training as we presented in Chicago in December. The even was sold out than, but it is not sold out yet in NYC :). Our training will be on the last day of the conference, Friday March 27
I will be presenting the talk about building local communities (specifically, how to build a Postgers User Group) on the second day of the conference
I won’t be presenting neither bitemporal library, nor NORM, but I was invited to talk at another event during the same week, where I will present the NORM talk (extended from my Cyprus presentation). I will publish all the details as soon as it will be finalized
Once again – there will be an amazing number of interesting presentations, and many experienced people to talk to (I already have a list of twenty:)), so please consider attending!
Dear fellow Chicagoans! I just shared a LinkedIn post by 2ndQuadrant – the Early Bird registration for 2Q PG Conf ends on November 2!
It is going to be the third year of this conference coming to Chicago, and I can guarantee it will be even better than before. There are several reasons for that.
First, we are back to W hotel in the Loop, which is a very convenient location for those of you who work in Chicago and commute from the suburbs – very close to both Union Station and Ogilvie.
Second – there was a record number of submissions, and the best of the best were selected to be presented.
Third – guess who will be presenting the Ultimate Optimization Training?! Yes, your’s truly.
Now add to this list all of the advantages of a local conference. No airfare. No hotel charges. No travel time. Perhaps, if it would be up to you, you would not mind a getaway:). But I can guarantee that your manager would love an idea of sending you to the local conference, rather than to San Francisco!
And now, I have a world for Chicago PUG members. As a reminder, we are going to have a very special meetup on November 12: Magnus Hagander and Devrim Gündüz will be presenting! Those are two great reasons to attend in November, but there is one more: we are going to reveal a special discount code for Chicago PUG members.
Please register early for both of these exciting events!
Last week I had the first acceptance of my paper to the real Computer Science conference for a very long time (since 2015!). Many things make this acceptance very meaningful for me.
First, as I said, it’s the first one after four and a half years.
Second, this is my first acceptance for the scientific conference since I joined Braviant Holdings. When I spoke at ICDE 2016, I was already with Braviant Holding, but the work was done, and the paper was submitted during my Enova tenure.
Third, the topic of the paper is ORIM, which is very difficult to sell to both the academic community and industry alike, and we already had two rejections of the earlier version of this paper.
And the last – this is the paper Boris and I submitted together since I can’t remember how long (I want to say – since 1995 :)). OK, the first accepted paper together:)
We will be presenting at the SOFSEM 2020 conference in January. So yes, this is also my birthday present 🙂
Tonight was an award night – and I was announced a winner!!! There will be official pictures and videos, but one, for now, I want to share this video of me accepting the award.
For me, this award first and foremost goes to Postgres, the most advanced Object-Relational database. All the new technologies which we implemented at Braviant Holdings are based on Postgres, with no third-party products.
Also, I am immensely thankful for the support of Braviant Holdings leadership team. I won’t be able to accomplish all I’ve accomplished without that.
Hi everybody who was waiting for that moment! I am happy to report that I have a database position! It will be on LinkedIn, I promise, but meanwhile, check it out at our company website, the job description is here.
Since last time, my requirements did not change. I still want to see a strong DB background, the knowledge of the theory (and what’s wrong with it:)), and yes, I am still asking, what’s a primary key:).
If hired, you will have an opportunity to learn unique technologies, superb optimization techniques and will work with databases the way you never worked before 🙂
First of all, a big THANK YOU to everybody who reached out congratulating me for becoming a finalist in the “Technologist of the Year” nomination. This nomination is especially important for me, because I’ve always strived to apply the best CS theories for the success of the business. I do not believe in approaches, which can’t be used in practice. However, I think that applying the right theoretical principles in the industry can have a tremendous impact.
Another aspect important to me is that all my innovations are related to PostgreSQL. If I were asked to name the three most important things which I’ve introduced at Braviant Holdings, it would be
The wide usage of FDW both in OLAP and OLTP
The usage of pg_bitemporal in both OLAP and OLTP
Abandoning ORM and using JSON -based data exchange between applications and databases
There is more in my blog about all of the above, but what I want to point now – each of these Top 3 is about using PostgreSQL in an innovative way.
The award descriptions say:
Presented to the individual whose talent has championed true innovation, either through new applications of existing technology or the development of technology to achieve a truly unique product or service.
Isn’t it precisely what I just said :)? Do I want to win? Absolutely! Do I think I can win? Yes! Can you help me :)?…
Several people reach out to me, telling me that they have difficulties casting their votes. I agree that the voting process is at least contra-intuitive. So let me explain it step by step.
Then, click where it is said to CREATE LOGIN. It says that you can login with your Facebook account, but this does not work. So you will need to create a login. After that, you need to click on the large grey “Like” on the very top. Wait for a response to make sure your vote is counted.
Also, there are SHARE buttons, and unfortunately, the most important one – Share on LinkedIn – does not work. Others work fine, so you can help me by sharing with your network 🙂
And one more thing – this voting is only opened till August 16, so please don’t delay 🙂