Posts

Best Way to Write SQL in Java

Image
Many of us struggle writing SQL in Java. ORM tools such as Hibernate often generate SQL statements that result in poor application performance. Surely, there must be a better way to write SQL in Java. Attend the free webinar by Java Champion Lukas Eder to learn the best way to write SQL in Java. Find out how you can use SQL as a type safe domain specific language in Java. Sign up for the free webinar.

How to Upgrade an Oracle-based Application without Downtime

Image
One of most common reasons IT departments avoid database development is the belief that an application upgrade in the database causes downtime. However, nothing can be further from the truth. On the contrary, Oracle Database provides one of the most bullet proof ways to upgrade an application without any downtime: Edition Based Redefinition (EBR) EBR is a powerful and fascinating feature of Oracle (added in version 11.2), that enables application upgrades with zero downtime , while the application is actively used and operational. Attend the free webinar by Oren Nakdimon on February 16th to learn how to use EBR , see many live examples, and get tips from real-life experience in a production site using EBR extensively. The webinar is free but space is limited. Sign up for the free webinar.

Version Control for PL/SQL

Image
Let's get this straight: It is possible to put PL/SQL in proper version control.  It is possible to have developers work on the same logical code unit (package, procedure, function etc...) at the same time without co-ordinating first.  It is possible to merge these changes at a later time automatically.  It is possible to eliminate all the errors resulting from manual preparation of deployment scripts.  It is possible to build an automated continuous delivery pipeline for PL/SQL. If you'd like to know how please visit www.gitora.com

Demo: Version Control for PL/SQL in 30 Minutes

Hi Everyone! We prepared a 30 minute demo video to show you how Gitora can help you manage your PL/SQL code base. Check it out below:

PostgreSQL for Oracle Developers and DBA's

Image
PostgreSQL is not very well known among Oracle developers and DBA’s. Yet, the skill set of an Oracle developer or a DBA is easily portable to PostgreSQL. There is no one better than Joshua D. Drake to teach you PostgreSQL and show you how you can migrate from Oracle to PostgreSQL. Attend Joshua's free webinar and earn how you can benefit from PostgreSQL, the leading free and open source alternative to the Oracle Database. Sign up for the webinar About The Presenter: Joshua D. Drake is an Open Source Consultant specializing in Linux and PostgreSQL. He has been consulting on PostgreSQL since 1996. Throughout his PostgreSQL career he has performed a variety of functions within the community including submitting a patch or two, releasing an O'Reilly book on PostgreSQL as well as being part of the sysadmins and advocacy teams. Further he ran a biannual conference series dedicated to PostgreSQL between the years of 2007 - 2011. He is former Director (2008-2016) f...

Success Story: Version Control for PL/SQL

Image
It’s been a little over three months since we released Gitora 2.0 and the first success stories have started to emerge. Here is one of them: Rhenus Logistics, the leading logistics company from Germany uses Gitora to manage their Oracle Database. Problem Rhenus IT uses both Java and PL/SQL to serve their users and customers. They have a team of about 10 PL/SQL developers.  The team manages more than 20,000 database packages, views, functions, procedures, object types and triggers spread over 30+ database schemas. Rhenus IT wanted to move to a continuous delivery environment in which they can be more agile and deliver solutions to the business faster.  Managing the PL/SQL code was the hardest piece of the puzzle. Solution After experimenting with other solutions in the market, Rhenus decided to move forward with Gitora. Gitora enabled Rhenus Developers to: Use Git, the prominent open source version control system used by millions of d...

Markus Winand on Database Optimizers

Image
If you are a DBA or a developer and would like to learn more about database optimizers, there is no one better in the world than Markus Winand to learn from! Markus is hosting a free webinar on December 15th. Attend his webinar and learn how you can build better performing applications. Register at this link.