Posts

Showing posts from 2022

Using Git with PL/SQL in a Shared Development Database

  With Gitora 6 , developers can work on the same code base (i.e. a package, procedure etc…) in the same database without blocking each other. Many development teams use a single database for development. Many of them use the same database for testing, as well. They achieve this by using different schemas for different purposes. Gitora 6 enables these teams to create Git repos for these schemas and pull updates between them. With Gitora 6, you can even create a different schema for every developer and have them merge their code using Git. Gitora 6 enables you to implement any modern development workflow in a single database. How does Gitora 6 work? Gitora 6 introduces a new repo type called   Single Schema Repo (SSR) . As its name suggests an SSR manages database objects from a single schema. The DDL scripts in SSR’s don’t contain the schema prefixes so that Gitora can execute them in other schemas in the same database. This enables developers to work on the same package, procedure, fu

Are You Using Version Control for Your Database or Are You Ticking a Box?

  You use a version control system to solve certain problems, to accomplish certain tasks. These are: Keep track of who changes what, when and why. If necessary, use previous versions of the code base for testing, development etc… Move changes between environments faster, with fewer errors during deployment. Improve productivity of the team (i.e. less time coordinating manually and more time developing. For example different developers working on the same parts of the code base simultaneously and merging their changes at a later time, hopefully mostly automatically.). If you are using a version control system but not accomplishing any of the things above, are you really using a version control system? Here is a perfectly reasonable scenario that I’ve seen in the real world. I’ve seen this scenario with teams using Git with SQL Developer, SVN/Git with another Oracle PL/SQL IDE. Invariably, they all end up here: In the DEV database, you make changes to the package PKG_HIRING in the HR sc

Agile PL/SQL Development with Git

Gitora 6 , the latest version of the source control tool for the Oracle Database, enables PL/SQL developers implement agile development practices in a single database. With Gitora 6, developers can work on the same code base (packages, procedures etc...) at the same time, in the same database. Learn more at http://blog.gitora.com/introducing-gitora-6/