gajus/
A PostgreSQL client with strict types, detailed logging and assertions.
USD raised
Recent activities
Cannot re-use pool connection after stream-related error
Drop ZodType constraints on sql.type, QeurySqlToken, type aliases, etc
TypeError: sql is not a function
Slonik not compiling because of Record key typing error
When is sql.identifier required? - sql function composition clarification
How to use WHERE id IN
PrimitiveValueExpression preventing valid return type for `jsonb_build_object`
Integrate TypeBox validator
Expose streaming query as (typed) AsyncIterable
make_interval function has incorrect parameters
Migration management with Slonik
The inferred type of 'sql' cannot be named without a reference to '.pnpm/zod@3.19.1/node_modules/zod'. This is likely not portable. A type annotation is necessary.
Do now allow to bind query methods if query is already typed
Should passing bad SQL to stream() throw an Error?
[discussion] Thoughts about adding sql.assign utility to Slonik?
Sql typing no longer works with interface types
Add sql.typeAlias('alias')
Warn if an attempt is made to acquire a new connection from pool within a transaction
Drop pg-native
Cannot extend parser
Cannot infer parser type
Zod local version must be equal to slonik zod version
error: syntax error at or near "$1" when trying to drop db
More info on how to type generic functions using queries for docs?
Allow more parameter types for `sql.date` and `sql.timestamp`
How can I set the schema?
Select query does not return dates as Date instances
Make columnTypes in sql.unnest optional
Using `bigint` in `sql.array` results in TypeScript compiler error
error TS7016: Could not find a declaration file for module 'pg'.
Plans for API stability or stable releases?
How to Insert Records with timestamp field using unnest
sql.Identifier on jsonb columns wraps in quotes
Identifier with Column Alias Support
sql.type zod parser not applied when using createMockQueryResult
Error When Connecting to Redshift
Consider replacing the dependency on hyperid with native crypto module
Using RLS with Slonik
The automated release is failing 🚨
Executing arbitrary SQL in a transaction
Backwards Compatibility to allow migrating to Runtime-Validation (Zod)
Making `sql` tag a standalone package
Use `bigint` within `sql` template string query
interceptor for `beforeClientError`
How to connect from App engine in a connection string?
`boolean` type acting odd with `unnest`
import issue for StreamHandler and PoolContext Types.
Export the "sql" tag as a separate package
Additional `#` in the sql string
SQL statements containing $1 cause errors
`sql.json(null)` should produce `'null'::jsonb` instead of `null`
Is their any way to Insert array value without `memberType`?
Make it easier to read / filter out logs
Add a helper function to construct connection URI
Function Calls That Require Single Quoted Parameters Doesn't Work
slonik-interceptor-query-normalisation no more usable?
Question: creating tables from variables
sql TTL buggy behavior
Question: How to build a query with a dynamic where clause?
`stream` documentation severely lacking
sql.unnest with custom type defined with schema
copyFromBinary isn't working because pg-copy-streams-binary API has changed
Add column name property for `NotNullIntegrityConstraintViolationError`
Function createPool does not honor the connection timeout setting during initialization
zod has been added as a dev dependency
sql.interval
Contribute to postgresql-client
Calling stream.destroy(error) kills node
integrate zod into Slonik
Documentation: Promise.all incompatible with transactions
Export PoolContext and StreamHandler types
Is it possible to use nested arrays in queries?
Calling end method in Mocking Slonik raises an exception
Migrate to postgres.js? [latest benchmarks]
CREATE TABLE variablename = syntax error at or near "$1"
Module '"slonik"' has no exported member 'createMockQueryResult'
Closing cursor after destroying stream
Cannot use variable as name to create a new database using sql template literals
Spread Syntax causes Maximum Call Stack Exceeded exception
bytea array error
Provide logger instance
Sopport socket:// URLs, needed for AppEngine+CloudSQL use
Prevent unsafe sql.fragment usage
Regression: cannot use @slonik/migrator anymore due to multiple queries prevented
Unsafe foreign connection false positive?
Failed connection attempts are not released from connection pool
anyFirst method returning error if we have multiple columns
How to use postgres npm package with the new Driver configuration
When using multiple row insert with `unnest`, `boolean` data type results in an error whereas `bool` works
Parameter connectionTimeout is not applied
Backend has been terminated unexpectedly
ts2305 Module slonik has no exported member SqlFragment
Can execute multiple statements in a single query
Getting "Expected `activeQueryPromise` to be set." error
Slonik Errors override with native errors
Move middlewares into /slonik codebase
Because many throws when there's no rows it would be nice to have maybeMany
Running multiple SQL commands at once throws an exception
Remove dependency on roarr and allow for custom logging solution integration
Cannot use $1 or $\d+ in nested SQL fragments
Cannot use $1 in nested TEXT
Add support for `options` parameter in connection URLs
libpq-dev required to install dev dependencies
ES Module problem with new p-limit dependency
Peer dependency mismatch: root package uses Zod v4, but sub-packages still require Zod v3
Stream result row is of type `any` after patch update
Minor distinction of wording in the Readme file
Add sql.boolean to query builder
Zod Peer Dependency Set To V3 Instead of V3 OR V4
Outdated runtime validation transform interceptor docs
AWS X-Ray instrumentation of pg client
Native ESM issue: unable to import pg
Export MaybePromise from package as its currently missing
createFieldNameTransformationInterceptor constructor no longer accept object with format prop
Using sql.timestamp with sql.array?
zod@4 is out
Implicit or Explicit query closes connection right after exec - do not return back to connection pool
Propagate `DataIntegrityError` to the `queryExecutionError` middleware
Integrate Standard Schema
Re-using value bindings for sql.array()?
Add sql.uuid()
Missing Error for exclusion constraints
Support for sqlcommenter: Option to Not Strip SQL Comments
"Argument is not assignable" error in the Result parser interceptor example
How to use `WHERE id IN` / `WHERE id = ANY` with v34+?
Include index in error when trying to bind undefined value
Type parser not applied in jsonb_agg fields
Improve Syntax Error Logging Output
What happened to TaggedTemplateLiteralInvocation?
CommonQueryMethod maybeMany returning []
Convert to ESM
v33.0.10 introduces breaking change
Bulk inserts using unnest won't allow jsonb columns
Improve documentation on when and why should we use `pool.connect(connection => { ... })`
No error is thrown even though unknown key is returned
PgClient may leak database connections if `createTypeOverrides` raises an error
connectionRetryLimit is off-by-one
Initial connection to setup the pool is missing retries
Pool is missing error handling
Add a helper to build where conditions
Allows you to work with stored procedure
Unix domain socket connection string throws: [ERR_INVALID_URL]: Invalid URL
The rows should be validated after the interceptors are executed
Document `originalError` rename to `cause`
Slonik fails with more than eight statements on one connection
Improving Runtime Validation Performance through Async Parsing
Partial<>'s Not Valid for SerializableValue
Breaking change (Node engine update) in patch version 37.0.3
Using values with `bigint`s in `sql.join` throws `Unexpected value expression.`
Backwards compatibility with old sql tag
How to insert embedding/vector using Slonik?
Transform example is not working
Bug Report: sql.jsonb over-escapes quotation marks
TIMESTAMP and TIMESTAMPTZ get parsed incorrectly after upgrading to v24
Make Slonik runtime validation non-Zod specific
BigInt break Jest (`JSON.stringify()`)
Support pgvector
rename afterPoolConnection to afterPoolConnectionConnect and afterPoolConnectionAcquire
Potential memory leak when using with the Jest's `--detectLeaks` flag
Produce the original stack trace
Any way I can do WHERE LIKE query?
Type aliases not validating with Zod?
Deno support?
Cannot create enum type
Typescript types are out of sync
configure default idle_in_transaction_session_timeout
[Discussion]: How does this sql tagged template differ to other solutions
Prepared statement fails on binding parameters
ts-sql-plugin idea
Is there a way to dynamically pass an operand?
sql.array , support for UUID's
Connection Error: connectionHandler is not a function
Guidance now that normalizeIdentifier was removed
[Documentation] `sql.identifier` documentation is unclear for arrays
Retry failing connections
source-map dependency causing errors
Treat undefined values as NULL
Instantiate slonik using an existing pg connection
Slonik unexpectedly tries to open a connection to localhost:5432
Using Slonik with an external connection pooler
False library comparisons in documentation
Ensure that each pool.connect() is getting a new connection
Hanging connections
Pass custom log function
Is it possible to import Slonik natively in Node?
Serializable transactions not working as intended
How do you dynamically create a where clause?
How to use copyFromBinary with a stream source?
Compile-time type constrains
No documentation for SSL
Wrong typings for createPool arguments
Query with dynamic WHERE clause members
Query Building Help: Insert
Values other than string | number in a createMockQueryResult?
README references `tupleList`
Question: SQL tag cannot be bound an undefined value
Thoughts on making it possible to add stuff to the executionContext of a query?
syntax error at or near "$1" when running `SET`
Question: use of transaction
Question : typing one/oneFirst
sql.json empty array?
Wrong type definition with empty/custom `typeParsers`
unrecognized configuration parameter "idle_in_transaction_session_timeout"
Retry transaction upon deadlock
Add an operator-whitelist configuration to sql.comparisonPredicate
[QUESTION] join replacement for booleanExpressionValues & comparisonPredicate doesn't work
sql.join separator is ignored
Inconsistency; Date Object; assignmentList vs valueList
Upgrade pg-copy-streams-binary to 1.2.0
NOTIFY/LISTEN
undefined values resulting in Unexpected value expression are very hard to debug
Better support for non-primitive types
Allow empty string in sql``
pg.Pool properties and events
Deprecate sql.rawList in favour of sql.expressionList
Documentation for anyFirst is either incorrect or counter-intuitive
API design question
Throw an error when raw binding includes unreferenced value
Empty sql template or condtional template implementation
Add a client-side timeout
How to use correctly in graphql resolvers (apollo-server)
Query without transaction nesting?
Dynamic INSERT + ON CONFLICT DO UPDATE
PostGIS functions in sql.unnest
Incorrect Datatype of QueryContextType.queryInputTime
sql.identifier should have an option not to quote the identifier
Question: How to insert an unwrapped array of values that contain an array?
Parse composite/row/record/tuple type values
Allow to configure transactions
Validate values added to SQL fragments
Develop a cache interceptor
Insert an array of SQL fragments
Pass a custom pg connection object
what's wrong with this sql query
Create interceptor for processing custom tagged template value expressions
Sql tag insert strings
Change default interval parser to seconds
Allow Date object as a parameter/ result
Can't find sql.join
List of Identifiers, how?
slonik and notice log from database
SqlTaggedTemplateType missing join
enhancement: support passing around connections and transactions
Handle sql comments inside the sql tagged template literal
use interceptors to provide results rows without a pg connection
Expose client configuration on pool instance
Connection closal after IMPLICIT TRANSACTION query
Allow to configure minimum number of active connections
sql`${sql.join(sql.binary(…))}` results in unexpected value expression.
Transaction binder does not allow streams
How to create dynamic enum types?
Connection error handling inside transaction
Clarification on explicit vs. implicit queries
'Result cursors do not work with the native driver. Use JavaScript driver.' error when using streams
Refactor of TaggedTemplateTypeLiteral was a breaking change
Automatically prepare queries that are executed more than X times
tuple to be locked was already moved to another partition due to concurrent update error handling
Allow replacing the underlying 'pg'
Timestamp type parser breaks if timezone is not GMT
SerializableValueType is not exported
Make `+` operator concatenate sql templates
Include message from originalError message in wrapped error
createMockQueryResult and transformRow incompatibility
OverridesType not exported
TypeScript: what connection type to use?
sql.json recursively mutates object with deepFreeze
Can't assert custom column type accurately
error: date/time field value out of range
Automatically handle "remaining connection slots are reserved for non-replication superuser connections" error
Create an interceptor that automatically debugs long running queries
How to handle invalid UUID error in slonik?
How to use slonik with express
pg-native is not found in a monorepo with pnpm or yarn pnpm
TypeError: connectionHandler is not a function
Support For "interval" Expressions
Disable/control roarr logs
How to better describe the file with queries
Basic example error - Unexpected SQL input. Query cannot be empty. Found only value binding
Getting non auto-releasing connection from pool
Accept non array on sql.identifier
Stop using Knex.js - Fragments sample no longer works
[TypeScript] Cannot use interface type because of ExternalQueryResultRowType constraints
idleTimeout (option for createPool) doesn't accept 'DISABLE_TIMEOUT'
Date typeParser not working any more
Slonik errors missing original error line numbers / stack traces
Build failing in new ts projects after slonik dependency added
Slonik fails to open an unencrypted connection
Proposal: `sql.ands`, `sql.commas`, `sql.ors` helpers for query building
Question: prepared statements?
ConnectionError: Connection terminated due to connection timeout
Should sql.array accept `bigint` as the value of `memberType`?
Running array_agg on date type results in value error
Node 8: process.hrtime.bigint is not a function
Support for arrays of custom types
pg 8.2.0 seems not works with pgpool(4.1.1)
Retry failing for implicit pool queries
Slonik QueryStream does not apply type parsers
Performance advice (and is pool.connect / pool.transaction expected to be much slower than pool.any/one/etc?
ConnectionError: Connection terminated due to connection timeout in Node 14.0.0
Nested JSON sql template throws InvalidInputError on valid JSON
Soft delete
Enable to use another logger than roarr
Slonik depends on array parser which is removed from pg-types 3.0.0
Possible EventEmitter memory leak detected with transaction
Accurate Performance Benchmarks Compared to Postgres
Case sensitive queries
`queryExecutionError` interceptor does not intercept assertion errors
Type issue: SerializableValueType is too restrictive when it comes to sql.json
Better connection mocking
How do I insert multiple records in my database using Slonik?
Question: Why are query results marked as `readonly`?
Fix types: export declare type CommonQueryMethodsType
Typescript changes didn't trigger a major release
Conditionally adding columns & values for insert operations
Connection and transactions handling
Alternative API proposal
missing comparison operators
Not possible to dynamically create `ON CONFLICT DO UPDATE SET` upsert queries
Type errors with sql.unnest
Create index named after a variable
Move `delay` package to development dependencies
Why does casting an array value as citext in the query returns the array as string?
transactionQueries is not iterable
Rewrite in TypeScript
How to combine ANY with bytea type for query for multiple rows?
How to select an array of tuples (multiple columns) `WHERE (column1, column2) = ANY` with Slonik?
© 2019 BoostIO, Inc.
IssueHunt
