Popularity

8.4

Stable

Activity

3.2

Stars 40

Watchers 14

Forks 2

Last Commit 9 months ago

Monthly Downloads: 24

Programming language: Haskell

License: Mozilla Public License 2.0

Tags: Database PostgreSQL

Latest version: v0.0.2.0

postgresql-simple-named alternatives and similar packages

Based on the "postgresql" category.
Alternatively, view postgresql-simple-named alternatives based on common mentions on social networks and blogs.

postgresql-simple

9.7 0.0 postgresql-simple-named VS postgresql-simple

Mid-level client library for accessing PostgreSQL from Haskell
postgresql-simple-migration

9.2 0.0 postgresql-simple-named VS postgresql-simple-migration

DISCONTINUED. PostgreSQL Schema Migrations for Haskell

AppSignal knows why the f*#k it crashed.

Stop vibe-debugging. Every exception, every backtrace, grouped so you see patterns, not noise.

Promo www.appsignal.com

postgresql-typed

8.9 4.9 postgresql-simple-named VS postgresql-typed

Haskell PostgreSQL library with compile-time type inference
postgresql-tx

8.9 6.1 postgresql-simple-named VS postgresql-tx

DISCONTINUED. [Moved to: https://github.com/Simspace/postgresql-tx]
postgresql-orm

8.8 0.0 postgresql-simple-named VS postgresql-orm

An Haskell ORM (Object Relational Mapping) and migrations DSL for PostgreSQL.
postgresql-transactional

8.4 0.0 postgresql-simple-named VS postgresql-transactional

Transactional monadic actions on top of PostgreSQL.
postgresql-libpq

8.0 0.0 postgresql-simple-named VS postgresql-libpq

Low-level Haskell bindings for libpq
postgresql-pure

7.7 0.0 postgresql-simple-named VS postgresql-pure

DISCONTINUED. a PostgreSQL client library implemented with pure Haskell [GET https://api.github.com/repos/iijlab/postgresql-pure: 404 - Not Found // See: https://docs.github.com/rest/repos/repos#get-a-repository]
postgresql-syntax

7.4 9.3 L3 postgresql-simple-named VS postgresql-syntax

PostgreSQL SQL syntax utilities
postgresql-schema

5.6 0.0 postgresql-simple-named VS postgresql-schema

PostgreSQL Schema is a database migration tool.
postgresql-simple-interpolate

5.5 4.4 postgresql-simple-named VS postgresql-simple-interpolate

Safe interpolated SQL queries in Haskell
postgresql-simple-typed

3.5 0.0 postgresql-simple-named VS postgresql-simple-typed

TypedQuery flavour for postgresql-simple
postgresql-error-codes

2.9 0.0 postgresql-simple-named VS postgresql-error-codes

PostgreSQL error codes
postgresql-simple-opts

2.6 0.0 postgresql-simple-named VS postgresql-simple-opts

An optparse-applicative parser for postgresql-simple's connection options
postgresql-libpq-notify

1.6 0.0 postgresql-simple-named VS postgresql-libpq-notify

A postgresql notifications library for libpq
postgresql-placeholder-converter

1.0 0.0 postgresql-simple-named VS postgresql-placeholder-converter

Converter for question mark style and dollar sign style of PostgreSQL SQL.
postgresql-tx-simple

- - postgresql-simple-named VS postgresql-tx-simple

DISCONTINUED. postgresql-tx interfacing for use with postgresql-simple.
postgresql-lo-stream

- - postgresql-simple-named VS postgresql-lo-stream

DISCONTINUED. Utilities for streaming PostgreSQL LargeObjects
postgresql-tx-squeal

- - postgresql-simple-named VS postgresql-tx-squeal

DISCONTINUED. postgresql-tx interfacing for use with squeal-postgresql.
postgresql-tx-monad-logger

- - postgresql-simple-named VS postgresql-tx-monad-logger

DISCONTINUED. postgresql-tx interfacing for use with monad-logger.
postgresql-tx-query

- - postgresql-simple-named VS postgresql-tx-query

DISCONTINUED. postgresql-tx interfacing for use with postgresql-query.

* Code Quality Rankings and insights are calculated and provided by Lumnify.
They vary from L1 to L5 with "L5" being the highest.

Do you think we are missing an alternative of postgresql-simple-named or a related project?

Add another 'postgresql' Package

Popular Comparisons

README

postgresql-simple-named

Logo

[](LICENSE)

This library introduces the implementation of named parameters for the postgresql-simple library. postgresql-simple-named is considered to be used along with the postgresql-simple library, so you could refer there for the original documentation of primary functions. This package solves exclusively one particular problem — gives the ability to use named parameters instead of ? in quasi-quoter queries and offers essential functions for substituting variables in queries (queryNamed, executeNamed).

Example

Operator =? binds named parameters with the corresponding values. Named parameters inside SQL query start with the '?' character and can contain lowercase and uppercase letters, digits and underscore. Below you can find a basic example of how query with named parameters could look like:

queryNamed dbConnection [sql|
    SELECT
        id, name, city
    FROM users
    WHERE name = ?nameParam
      AND age  = ?ageParam

|] [ "nameParam" =? "John"
   , "ageParam"  =? 42
   ]

This feature can be extremely helpful when the query uses some parameters more than once:

query dbConnection [sql|
    SELECT
        col1, col2
    FROM my_table
    WHERE id = ?
      AND (? IS NULL OR id > ? )
      AND (? IS NULL OR id < ? )

|] (someId, minId, minId, maxId, maxId)

This is how the query looks like with the postgresql-simple library. You can rewrite it the following way using the postgresql-simple-named library:

queryNamed dbConnection [sql|
    SELECT
        col1, col2
    FROM my_table
    WHERE id = ?someId
      AND (?minId IS NULL OR id > ?minId )
      AND (?maxId IS NULL OR id < ?maxId )

|] [ "someId" =? 42
   , "minId"  =? 1
   , "maxId"  =? 100
   ]

How to build

Build the library with either cabal new-build or stack build.

How to test locally

Run DB in a Docker in a separate terminal window using command: docker run -p 5432\:5432 -e POSTGRES_USER=postgres -e POSTGRES_DB=pg_named postgres\:10.5-alpine
Run tests using cabal new-test or stack test

*Note that all licence references and agreements mentioned in the postgresql-simple-named README section above are relevant to that project's source code only.