Ascend Minds’ Post

New post, on using relative paths in your Liquibase changeSets for Oracle in SQLcl for delivering database updates in your CI/CD pipelines.

I am excited to share that my latest Liquibase 2024 tutorial was published! https://lnkd.in/dWBbs2bg Also, don't forget to check my other Liquibase & SQLcl Liquibase blog posts series. #liquibase #databases #devops #oracle

HI Everyone Please have a look at my consultants profile and let me know if you have any roles for her . Contact : (469) 262-5835 Ext: 145 Email:  nissar@astekitsolutions.com  #javadeveloper #dotnetdeveloper #awsdevops #azuredevops #OBIEE ##Ios #python #azure #cloud #aws #cloudcomputing #guideware #sap #BI #powerbi #sfdcba #ba #sql #microsoft #qa #qaautomation #sdet #oracle #hcm #oraclehcm #python #sql #productowner #Web #ba #qa #Selenium #Webdriver #Cucumber #Jira #Agile #Waterfall #Jenkins #GITHUB #TSQL #PLSQL #ssis #ssrs #sqlserverdba #sapariba #saipoint #Active #Hudson #SDLC #OBIEEE #BI #networkenginner #javafrontend #QAlead #hadoop #bigdata #javadeveloper #QAtester#ScrumMaster #cloudengineer #guidewireba #sqldba #uideveloper #php #businessanalyst #qa #testing #sdet #viplovteam #pega #DataAnalysis #dataengineer #dataarchitect #api #soap #rest #restservices #mvc #mvp #asp #linq #mvvm #wcf #asmx #C #framework #ajax #sqlserver #testng #junit #webdriver #appium #postman #mobiletesting #uat #qc #ASP #mvc #wpf #wcf 

SQL LRS has been granted a Certification to Field on Platform One. This will greatly reduce the friction for federal government customers who seek to implement secure xAPI software resources. It's been in the works for a long time (and is part of the reason we've been quiet for a bit here). There are myriad people to thank for their hard work. They know who they are, and they should know that I appreciate the work they have done. https://lnkd.in/gjxjn5Q7 #xAPI #PlatformOne #DevSecOps #LearningTechnology #Data #OpenSource

The amazing Oracle SQLcl team added the overwrite-files flag to the liquibase generate-schema command. This can be very handy at times, here’s additional detail: https://lnkd.in/e9DyUubD

Liquibase helps you to manage your database objects without writing and without depending on SQL queries. This brings the concept of one query over multiple tables, query being written using database neutral language like XML, JSON, and YAML. Liquibase is a data base change management tool. In an application if you modify any tables for any requirements and if you want to revert to the old versions, liquibase can be used safely. Also, liquibase provides database neutral way to perform create, update, and delete operations. We can write the changes in xml files and can be applied to any database. Suppose if five instances of same application are running in five different data bases then to apply data base changes writing different SQL statements for different database is time consuming. Liquibase provides xml tags and attributes to apply data base changes. Rather than writing SQL directly against the database to create, update or drop database objects, we can define database changes in XML/JSON/YAML files. Such files are called as databaseChangeLog files.

There are many useful SQLcl tags that allow developers to get much more out of Liquibase. #️⃣ Unfortunately, the existing documentation leaves something to be desired. 📝 What possibilities do these tags offer? How can IT teams use them to full effect? If you want to know the answers to these questions, read Jakub Dobruchowski’s first article on the Pretius blog. 👇 #sqlcl #database #liquibase

Are you tired 😣 of manually deploying database schema changes and dealing with errors? Say hello to Liquibase, 😃 an open-source champion for database change management! 𝐖𝐡𝐚𝐭 𝐢𝐬 𝐋𝐢𝐪𝐮𝐢𝐛𝐚𝐬𝐞? Liquibase is a free, database-independent tool that helps developers track, manage, and apply changes to their database schemas. This means: - Version control for your database schema ️ - Smoother deployments and fewer errors - Collaboration made easy across teams 𝐏𝐫𝐨𝐬 𝐨𝐟 𝐔𝐬𝐢𝐧𝐠 𝐋𝐢𝐪𝐮𝐢𝐛𝐚𝐬𝐞: - Database Agnostic: Works with various databases like MySQL, Oracle, PostgreSQL, and more! - Version Control: Track schema changes over time, just like your application code. - Rollback Capabilities: Oops, made a mistake? No worries, easily revert changes. ⏮ - Automation: Integrate Liquibase into your CI/CD pipeline for seamless deployments. 𝐂𝐨𝐧𝐬 𝐭𝐨 𝐂𝐨𝐧𝐬𝐢𝐝𝐞𝐫: ✋ Learning Curve: There's a learning curve involved in understanding Liquibase and writing changelogs. ✋ Complexity for Simple Projects: For small projects, Liquibase might be overkill. Overall, Liquibase is a powerful tool for managing database schema changes in development environments, especially for larger projects with frequent updates. Has your team used Liquibase? Share your experiences in the comments!  #liquibase #devops #database #sql #mysql #postgresql #oracle #developer #softwareengineer #versioncontrol #developer

Exporting Audit logs for last 24 hours into a .zip file is quite easy with the combination of Groovy and REST API. https://lnkd.in/eN8gizgK #ThinkGroovy #Groovy #RestAPI #EPM #PBCS #EPBCS #Oracle

How Liquibase brings automation, CI/CD, security, and compliance to Database change management? Agility, observability, and governance for SQL and NoSQL databases - Version, track, and deploy database changes. https://lnkd.in/gzghdUxi #Database #Liquibase #devsecops