Prisma

Today, we are issuing the seventh [Preview release](https://github.com/prisma/prisma2/blob/master/docs/releases.md#preview): `2.0.0-preview-7` (short: `preview-7`).

Major changes

With this release, we've put major efforts into making Lift's migration engine more performant. Especially remote migrations benefit from significant performance improvements in this release.

Fixes and improvements per Prisma 2 repository

`prisma2`

- [Prisma on linux](https://github.com/prisma/prisma2/issues/2)
- [Drop support for recognizing `project.prisma` files](https://github.com/prisma/prisma2/issues/126)
- [Photon QueryError because WrongType(Type(Text)) for default(uuid()) on Postgres](https://github.com/prisma/prisma2/issues/197)
- [Error when using Photon to create new item with 2 relation connections](https://github.com/prisma/prisma2/issues/317)
- [Query engine fails for querying implicit back relation](https://github.com/prisma/prisma2/issues/323)

`lift`

- [Create model with enum array throws: no such table](https://github.com/prisma/lift/issues/62)
- [Remote migrations are very slow](https://github.com/prisma/lift/issues/49)

`photonjs`

- [notIn throws type error with empty array](https://github.com/prisma/photonjs/issues/180)
- [__internal is ignored](https://github.com/prisma/photonjs/issues/181)


2.0.0-preview-6.1
Fixes
There was a problem in packaging the cli in the `2.0.0-preview-6` release, which broke most commands.

Today, we are issuing the sixth [Preview release](https://github.com/prisma/prisma2/blob/master/docs/releases.md#preview): `2.0.0-preview-6` (short: `preview-6`).

Major changes

Next to a lot of bug fixes, this release ships with a completely overhauled core of the Prisma query engine which makes the resolution of Photon queries a lot more stable.

Unfortunately, due to the overhaul there is one **known regression** to be aware of: Required relations are not enforced as `NOT NULL` on the database level. They are enforced by the _query engine_ though. This is intermediate until we have fixed a limitation in the query engine. You can track the progress of this issue [here](https://github.com/prisma/lift/issues/98).

Fixes and improvements in the Prisma 2 repository

`prisma2`


- [[Preview3]Error when prisma2 generate](https://github.com/prisma/prisma2/issues/274)
- [`prisma2 generate` generates files into wrong directory](https://github.com/prisma/prisma2/issues/306)
- [Init flow creates projects inside a "prisma" folder, if it exists](https://github.com/prisma/prisma2/issues/41)


`photonjs`

- [Now dev causes: Cannot find module "node_modules/generated/photon/index.d.ts"](https://github.com/prisma/photonjs/issues/176)
- [photon.dmmf.schema.outputTypes has duplicated Query & Mutation](https://github.com/prisma/photonjs/issues/166)
- [Photon is not throwing a full Rust backtrace for panics](https://github.com/prisma/photonjs/issues/177)
- [`updateMany` should return count of updated records](https://github.com/prisma/photonjs/issues/82)
- [Inconsistent type generation](https://github.com/prisma/photonjs/issues/78)
- [Support empty `where` statement for `findMany`](https://github.com/prisma/photonjs/issues/165)
- ["set" throwing error](https://github.com/prisma/photonjs/issues/158)
- [Correct the description](https://github.com/prisma/photonjs/issues/174)
- [sqlite `id default(cuid())` marks field as required](https://github.com/prisma/prisma2/issues/214)
- [ID not incremented on MySQL](https://github.com/prisma/prisma2/issues/135)
- [SQLite: Queries in large tables result in error: "too many SQL variables"](https://github.com/prisma/prisma2/issues/302)
- [RelationFieldNotFound on nested create/connect](https://github.com/prisma/prisma2/issues/218)
- [Self-referential Data Modeling Leads to Unexpected Behavior](https://github.com/prisma/prisma2/issues/291)
- [NullConstraintViolation related to DateTime type](https://github.com/prisma/prisma2/issues/315)
- [Postgres + map causes a crash](https://github.com/prisma/prisma2/issues/309)
- [Error for Float type (postgresql)](https://github.com/prisma/prisma2/issues/147)
- [Simple nested update mutation fails](https://github.com/prisma/prisma2/issues/111)
- [Bring your own ID fails](https://github.com/prisma/prisma2/issues/62)

`lift`

- [Lift engine only supports new versions of MySQL ( >= 5.7 ).](https://github.com/prisma/lift/issues/38)
- [Lift "duplicate column name:"](https://github.com/prisma/lift/issues/28)
- [[Preview3.2]MySQL Lift Bug](https://github.com/prisma/lift/issues/93)
- [Error in lift engine](https://github.com/prisma/prisma2/issues/325)
- [The schema snapshot file is still called `datamodel.prisma`](https://github.com/prisma/prisma2/issues/277)

Today, we are issuing the fifth [Preview release](https://github.com/prisma/prisma2/blob/master/docs/releases.md#preview): `2.0.0-preview-5` (short: `preview-5`).

In case you wonder where `preview-4` is - there was a mistake in our build pipeline which skipped `preview-4`.

Major changes

In this release, we've focused a lot on making Photon and Lift more stable and ironed out a number of critical and annoying bugs.

For example, you can finally [use environment variables in your Prisma schema](https://github.com/prisma/prisma2/issues/70), [apply `default(now())` to `DateTime` fields](https://github.com/prisma/photonjs/issues/103) or [connect to database with credentials that contain special characters](https://github.com/prisma/prisma2/issues/292).

Fixes and improvements in the Prisma 2 repository

`prisma2`

- [Structured JSON logging](https://github.com/prisma/prisma2/issues/293)
- [prisma2 commands do not recognize environment variables.](https://github.com/prisma/prisma2/issues/70)
- [Fix Netlify examples](https://github.com/prisma/prisma2/issues/279)
- [CLI is not writing SSL option to the URL](https://github.com/prisma/prisma2/issues/109)
- [[Preview 2] Error on saving migration](https://github.com/prisma/prisma2/issues/195)
- [Relations Foreign Key Reference](https://github.com/prisma/prisma2/issues/82)
- [[Preview3]Error when prisma2 generate](https://github.com/prisma/prisma2/issues/274)
- [Passwords with special characters don't work](https://github.com/prisma/prisma2/issues/292)
- [Typescript export ModelClient](https://github.com/prisma/prisma2/issues/257)
- [Can't deleteMany when using UUID](https://github.com/prisma/prisma2/issues/260)
- [Error in Photon when where object is empty](https://github.com/prisma/prisma2/issues/136)
- [when prisma2 init newProject](https://github.com/prisma/prisma2/issues/192)
- [Error running lift up for the first time with sqlite](https://github.com/prisma/prisma2/issues/256)
- [Inconsistent type generation](https://github.com/prisma/prisma2/issues/78)
- [Remove `seed` from prisma2 help](https://github.com/prisma/prisma2/issues/264)
- [Init flow creates projects inside a "prisma" folder, if it exists](https://github.com/prisma/prisma2/issues/41)

`photonjs`

- [Missing documentation property in DMMF.Enum](https://github.com/prisma/photonjs/issues/155)
- [Fails slow with incorrect Postgres credentials](https://github.com/prisma/photonjs/issues/156)

`lift`

- [Remote migrations are very slow](https://github.com/prisma/lift/issues/49)


2.0.0-preview-3.2
Fixes

- Fixes the binary fetching logic to get the latest binary. Necessary to make https://github.com/prisma/prisma2/releases/tag/2.0.0-preview-3.1 available.

2.0.0-preview-3.1
Fixes

- Fixes a regression in the migration engine, which couldn't read migrations properly from the database https://github.com/prisma/lift/issues/74

Today, we are issuing the third [Preview release](https://github.com/prisma/prisma2/blob/master/docs/releases.md#preview): `2.0.0-preview-3` (short: `preview-3`).

A special shoutout to [Errorname](https://github.com/Errorname) for helping us fix a small but significant issue in Photon JS 🙏

Major changes

In this release, we've focused on making Photon deployment easier. You can now precisely determine which version of the query engine binary Photon should be using with the new `platforms` and `pinnedPlatform` options on the `photonjs` generator. Read more about this change in the [docs](https://github.com/prisma/prisma2/blob/master/docs/core/generators/photonjs.md#specifying-the-right-platform-for-photon-js).

Breaking change

We've removed the `autoConnect` property from the `Photon` constructor to make the connection behavior more explicit and improve error handling. Photon will continue to lazily connect if you do a query.

Fixes and improvements in the Prisma 2 repository

`prisma2`

- [prisma2 convert](https://github.com/prisma/prisma2/issues/190)

`photonjs`

- [Generate relative to Prisma schema file](https://github.com/prisma/photonjs/issues/125)
- [Cannot update with null or undefined](https://github.com/prisma/photonjs/issues/148)
- [**Breaking** Remove `autoConnect` option from Photon ](https://github.com/prisma/prisma2/issues/246)

`lift`

- [`prisma2 lift docs` does not work](https://github.com/prisma/lift/issues/37)
- [Lift is freezing with Postgres when non-standard port is used](https://github.com/prisma/lift/issues/10)

Today, we are issuing the second [Preview release](https://github.com/prisma/prisma2/blob/master/docs/releases.md#preview): `2.0.0-preview-2` (short: `preview-2`).

Major changes

- [Split up `select` into `select` and `include`](https://github.com/prisma/photonjs/issues/15) **Important**: If the new `include` syntax doesn't show up in your editor, please delete your `node_modules` directory and run `npm install` again.
- [Google Cloud Functions Support](https://github.com/prisma/prisma2/issues/87)

Fixes and improvements per Prisma 2 repository

`prisma2`

- [CLI generated `undefined` when you enter and delete a field in database credentials flow](https://github.com/prisma/prisma2/issues/26)
- [`prisma introspect` should require Prisma file](https://github.com/prisma/prisma2/issues/11)
- [Postgres port gets added by default to Connection String when you edit MySQL form](https://github.com/prisma/prisma2/issues/39)
- [Photon should allow UUID for string input fields](https://github.com/prisma/photonjs/issues/132)
- [Fetch the correct binary for zeit](https://github.com/prisma/photonjs/issues/96)
- [Google Cloud Functions Support](https://github.com/prisma/prisma2/issues/87)

`photonjs`

- [Split up `select` into `select` and `include`](https://github.com/prisma/photonjs/issues/15)
- [Print the absolute path of generation](https://github.com/prisma/photonjs/issues/116)
- [Generated code has an absolute path](https://github.com/prisma/photonjs/issues/95)

`lift`

- [unique is not enforced with SQLite](https://github.com/prisma/photonjs/issues/47)

Since the initial [Prisma 2 announcement](https://www.prisma.io/blog/announcing-prisma-2-zq1s745db8i5/), we've ironed out a number of bugs and added lots of improvements to Photon and Lift.

Today, we are issuing the first official [Preview release](https://github.com/prisma/prisma2/blob/master/docs/releases.md#preview): `2.0.0-preview-1` (short: `preview-1`).

Major changes

- Renamed `project.prisma` to `schema.prisma` ([learn more](https://github.com/prisma/prisma2/issues/36))
- Renamed `postgres` data source provider to `postgresql` ([learn more](https://github.com/prisma/prisma2/issues/1))
- Support for [ZEIT Now](https://zeit.co/now) deployments for Photon JS ([learn more](https://github.com/prisma/prisma2/blob/master/docs/photon/deployment.md))

Fixes and improvements per Prisma 2 repository

`prisma2`

- [Rename `postgres` provider to `postgresql` 1](https://github.com/prisma/prisma2/issues/1)
- [`prisma dev` errors for postgres 12](https://github.com/prisma/prisma2/issues/12)
- [`prisma dev` can't recover from certain rust errors 20](https://github.com/prisma/prisma2/issues/20)
- [PhotonJS Generator: Rename to `photonjs` and other improvements 27](https://github.com/prisma/prisma2/issues/27)
- [Rename `project.prisma` to `schema.prisma` 36](https://github.com/prisma/prisma2/issues/36)
- [Back from SQLite in init workflow does not work 44](https://github.com/prisma/prisma2/issues/44)
- [working type definition example 52](https://github.com/prisma/prisma2/issues/52)
- [Having a case in model name breaks query engine 61](https://github.com/prisma/prisma2/issues/61)
- [Issue with "now dev" command 65](https://github.com/prisma/prisma2/issues/65)

`photonjs`

- [Generated code has an absolute path 95](https://github.com/prisma/photonjs/issues/95)
- [Dynamic dependency encoding 115](https://github.com/prisma/photonjs/issues/115)
- [Adjust filter operands API 9](https://github.com/prisma/photonjs/issues/9)
- [TypeError: cb.apply is not a function 20](https://github.com/prisma/photonjs/issues/20)
- [createdAt with default doesn't work 29](https://github.com/prisma/photonjs/issues/29)
- [Enum from MySQL are undefined 63](https://github.com/prisma/photonjs/issues/63)
- [Support for selecting relations of relations (and more sophisticated queries in general) 70](https://github.com/prisma/photonjs/issues/70)
- [Where to put generated code 77](https://github.com/prisma/photonjs/issues/77)
- [Update model args are always required for required fields 80](https://github.com/prisma/photonjs/issues/80)

`lift`

- [Create README.md in migration folders 1](https://github.com/prisma/lift/issues/1)
- [prisma2 init error in lift engine 14](https://github.com/prisma/lift/issues/14)