Hi guys, in this lesson we will talk about basic kinks of leaky bass. leaky bass is a scale migration library. It is work with relational databases like my SQL, MS SQL, Oracle, PostgreSQL, etc. In leaky bass, we can describe database change sets with different stats. So first of all, let's talk about format of the Cubase. leaky bass is written with XML format.
The main element of is database change look, database change log is constructed from change sets. Each change set has a unique ID, video and all to really change sets can be written with different styles. We can write change set with XML format, JSON format, pure SQL format, etc. Generally XML format or SQL is preferred. Because when we write it with XML, we can migrate it to different databases easily because XML format is generated for each databases, but to use it needs to learn leakiness language. The other one is writing gigabit to SQL.
It is easy, but it is depend on database. You know that some SQL syntaxes can be different in different databases. For example, there is number data type in Oracle. But when you migrate it to my scare, you should define it with int or begins or small eight because there is no number data type in my escape. The other advantage of liqui bass is rollback property when your SQL change says is not implemented correctly, leaky base rollback will be worked automatically. leaky base 10 sets will be implemented.
Then we run our application on initialization. Our each change sets will be called step by step in liqui Bass when leaky bait 10 sets are implemented leaky baits set a lock to database change log lock table. Then each change sets will be implemented and implemented change set record will be stored in database change log table in database. These records will be hash of change sets. So if we try to change our previous change set, we will get liquid based error. To solve it, we can write need to change sets.
For example, if we want to add a new field to our table, we can write, alter, Add Column query. That's all for beginning. Thank you.