Awesome
Finagle Postgres
This library provides PostgreSQL database support for Finagle.
Documentation
See the GitHub Pages
Using the Postgres client
Installation
Finagle Postgres is published on Maven Central. Use the following sbt snippet to bring it as a dependency.
libraryDependencies ++= Seq(
"io.github.finagle" %% "finagle-postgres" % "0.12.0"
)
Connecting to the DB
val client = Postgres.Client()
.withCredentials("user", Some("password"))
.database("dbname")
.withSessionPool.maxSize(1) //optional; default is unbounded
.withBinaryResults(true)
.withBinaryParams(true)
.withTransport.tls("host")
.newRichClient("host:port")
Selecting with simple query
val f = client.select("select * from users") {row =>
User(row.getString("email"), row.getString("name"))
}
logger.debug("Responded " + Await.result(f))
Integration Tests
sbt test
won't run integration tests by default. In order to make it easier for development, a database environment is provided via Docker.
After installing Docker and docker compose, run:
docker-compose up -d
A few environment variables need to be provided as well:
export PG_HOST_PORT=localhost:5432 PG_DBNAME=finagle_postgres_test PG_USER=postgres
With the database and variables in place, all tests will be executed. More details in IntegrationSpec
Changelog
See CHANGELOG.md
Contributors
- Mairbek Khadikov (project creator)
- The Factory
- Vladimir Kostyukov
- Jeremy Smith
- Leon Maia (current maintainer)
License
Licensed under the Apache License, Version 2.0 (the "License"); you may not use this software except in compliance with the License.
Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License.