All Projects → nafg → Slick Migration Api

nafg / Slick Migration Api

Licence: apache-2.0
Schema manipulation dialects and DSL for Slick (mirrored from gitlab)

Programming Languages

scala
5932 projects
dsl
153 projects

Projects that are alternatives of or similar to Slick Migration Api

Yuniql
Free and open source schema versioning and database migration made natively with .NET Core.
Stars: ✭ 156 (+34.48%)
Mutual labels:  sql, database-migrations
Scala Forklift
Type-safe data migration tool for Slick, Git and beyond.
Stars: ✭ 180 (+55.17%)
Mutual labels:  database-migrations, slick
Goose
A database migration tool. Supports SQL migrations and Go functions.
Stars: ✭ 2,112 (+1720.69%)
Mutual labels:  sql, database-migrations
Liquibase
Main Liquibase Source
Stars: ✭ 2,910 (+2408.62%)
Mutual labels:  sql, database-migrations
Shmig
Database migration tool written in BASH.
Stars: ✭ 408 (+251.72%)
Mutual labels:  sql, database-migrations
Lol dba
lol_dba is a small package of rake tasks that scan your application models and displays a list of columns that probably should be indexed. Also, it can generate .sql migration scripts.
Stars: ✭ 1,363 (+1075%)
Mutual labels:  sql, database-migrations
Express Knex Objection
A simple API system on a pg database, using knex and objection to simplify connection and management
Stars: ✭ 20 (-82.76%)
Mutual labels:  sql, database-migrations
Flyway Sbt
Flyway SBT plugin
Stars: ✭ 101 (-12.93%)
Mutual labels:  sql, database-migrations
Athena Express
athena-express makes it easier to execute SQL queries on Amazon Athena by chaining together a bunch of methods in the AWS SDK. This allows you to execute SQL queries AND fetch JSON results in the same synchronous call - well suited for web applications.
Stars: ✭ 111 (-4.31%)
Mutual labels:  sql
Mocodo
Modélisation Conceptuelle de Données. Nickel. Ni souris.
Stars: ✭ 113 (-2.59%)
Mutual labels:  sql
Impatient
Ain't nobody got time for data
Stars: ✭ 110 (-5.17%)
Mutual labels:  sql
Blockapi
A general framework for blockchain analytics
Stars: ✭ 111 (-4.31%)
Mutual labels:  sql
Npdynamodb
A Node.js Simple Query Builder and ORM for AWS DynamoDB
Stars: ✭ 113 (-2.59%)
Mutual labels:  sql
Spring Webmvc Pac4j
Security library for Spring Web MVC: OAuth, CAS, SAML, OpenID Connect, LDAP, JWT...
Stars: ✭ 110 (-5.17%)
Mutual labels:  sql
Migrations
CakePHP database migrations plugin
Stars: ✭ 114 (-1.72%)
Mutual labels:  database-migrations
Postgres Checkup
Postgres Health Check and SQL Performance Analysis. 👉 THIS IS A MIRROR OF https://gitlab.com/postgres-ai/postgres-checkup
Stars: ✭ 110 (-5.17%)
Mutual labels:  sql
Constexpr Sql
A light weight single header alternative to DBMS
Stars: ✭ 108 (-6.9%)
Mutual labels:  sql
Slack Sql
🎉 Bring SQL console to Slack
Stars: ✭ 115 (-0.86%)
Mutual labels:  sql
Dba
Oracle Scripts
Stars: ✭ 114 (-1.72%)
Mutual labels:  sql
Sqhell.vim
An SQL wrapper for vim
Stars: ✭ 113 (-2.59%)
Mutual labels:  sql

Write typesafe and typo-safe database migrations, using your existing Slick table definitions.

Pipeline Status

Coverage Status

Maven Central

Dependency

Slick version SBT dependency Supported scala versions
3.3.3 "io.github.nafg.slick-migration-api" %% "slick-migration-api" % "0.8.2" 2.12, 2.13
3.3.2 "io.github.nafg" %% "slick-migration-api" % "0.8.0" 2.12, 2.13
3.3.0 "io.github.nafg" %% "slick-migration-api" % "0.6.1" 2.11, 2.12
3.2.3 "io.github.nafg" %% "slick-migration-api" % "0.4.4" 2.11, 2.12
3.2.1 "io.github.nafg" %% "slick-migration-api" % "0.4.2" 2.11, 2.12
3.2.0 "io.github.nafg" %% "slick-migration-api" % "0.4.0" 2.11, 2.12
3.1.1 "io.github.nafg" %% "slick-migration-api" % "0.3.0" 2.11
3.0.3 "io.github.nafg" %% "slick-migration-api_slick30" % "0.3.0" 2.10, 2.11
2.1.0 "io.github.nafg" %% "slick-migration-api" % "0.1.1" 2.10

Artifacts are deployed to Maven Central.

Example

import slick.jdbc.H2Profile.api._
import slick.migration.api._

val db = Database.forConfig("example-config")

implicit val dialect: H2Dialect = new H2Dialect

class MyTable(tag: Tag) extends Table[(Int, String)](tag, "my_table") {
  val col1 = column[Int]("col1")
  val col2 = column[String]("col2")
  val index1 = index("idx1", col1)
  def * = (col1, col2)
}
val MyTable = TableQuery[MyTable]
val init =
  TableMigration(MyTable)
    .create
    .addColumns(_.col1, _.col2)
    .addIndexes(_.index1)
    .renameColumn(_.col1, "col3")
val seed =
  SqlMigration("insert into myTable (col1, col2) values (10, 20)")
  
val migration = init & seed

db.run(migration())
Note that the project description data, including the texts, logos, images, and/or trademarks, for each open source project belongs to its rightful owner. If you wish to add or remove any projects, please contact us at [email protected].