release notes — March 28, 2024
      
      
     
    
      sqlc is a command line tool that generates type-safe code from SQL. Today we released sqlc v1.26.0, mainly a bug fix release.
What’s new
This release is mainly a bug fix release. It also includes an important security fix for users using output plugins.
Bug Fixes
  - (docker) Use distroless base image instead of scratch (#3111)
 
  - (generate) Ensure files are created inside output directory (#3195)
 
  - (mysql) BREAKING: Use 
int16 for MySQL SMALLINT and YEAR (#3106) 
  - (mysql) BREAKING: Use 
int8 for MySQL TINYINT (#3298) 
  - (mysql) Variables not resolving in ORDER BY statements (#3115)
 
  - (opts) Validate SQL package and driver options (#3241)
 
  - (postgres/batch) Ignore query_parameter_limit for batches
 
  - (scripts) Remove deprecated test output regeneration script (#3105)
 
  - (sqlite) Correctly skip unknown statements (#3239)
 
Documentation
  - (postgres) Add instructions for PostGIS/GEOS (#3182)
 
  - Improve details on TEXT (#3247)
 
Features
  - (generate) Avoid generating empty Go imports (#3135)
 
  - (mysql) Add NEXTVAL() to the MySQL catalog (#3147)
 
  - (mysql) Support json.RawMessage for LOAD DATA INFILE (#3099)
 
Build
  - (deps) Bump github.com/jackc/pgx/v5 to 5.5.5 (#3259)
 
  - (deps) Bump modernc.org/sqlite to 1.29.5 (#3200)
 
  - (deps) Bump github.com/go-sql-driver/mysql to 1.8.0 (#3257)
 
  - (deps) Bump github.com/tetratelabs/wazero to 1.7.0 (#3096)
 
  - (deps) Bump github.com/pganalyze/pg_query_go to v5 (#3096)
 
      < All posts