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