Working with PostgreSQL arrays Working with PostgreSQL arrays pgdialect supports PostgreSQL one-dimensional arrays using array struct field tag: type Article struct { ...
Fixtures Creating fixtures Loading fixtures Retrieving fixture data Field names Source code Fixtures You can use fixtures to load initial data into a database for testing o...
Insert [PostgreSQL MySQL] API Example Bulk-insert Upsert Maps INSERT … SELECT Insert [PostgreSQL MySQL] API For the full list of supported methods, see InsertQueryopen in...
Copy data between tables and files COPY TO COPY FROM Copy data between tables and files PostgreSQL allows to efficiently copy data between tables and files using COPY TO and ...
Running Bun in production Monitoring performance and errors Transactions Soft deletes Hooks Custom types Cursor pagination Writing complex queries Migrating from go-pg
Common table expressions [PostgreSQL MySQL] With VALUES Common table expressions [PostgreSQL MySQL] With Most Bun queries support CTEs via With method: q1 := db . NewSele...
Efficient database pagination using cursors Introduction Cursor pagination Example Efficient database pagination using cursors Introduction Usually, you can paginate through...
Faceted search using PostgreSQL full text search Creating a table Creating facets from tags Constructing a facet Retrieving document stats Conclusion Faceted search using P...