{"repo":"alifiroozi80/duckdb","free":true,"listed":false,"github":"https://github.com/alifiroozi80/duckdb","clone":"git clone https://github.com/alifiroozi80/duckdb.git","description":"GORM duckdb driver","language":"Go","stars":36,"topics":["duckdb","go","gorm"],"license":"MIT","category":"data-pipelines","readme_excerpt":"GORM DuckDB Driver Report Bug --- Quick Start Checkout https://gorm.io for details. Limitations deleted at field. DuckDB has two index types: - Min-Max (Zonemap) - Adaptive Radix Tree In DuckDB, ART indexes are automatically created for columns with a UNIQUE or PRIMARY KEY constraint and can be defined using CREATE INDEX . However, every technology has its pros and cons. Despite being helpful (read attached pdf), ART indexes have some limitations. ART indexes create a secondary copy of the data in a second location – this complicates processing, particularly when combined with transactions. Certain limitations apply when it comes to modifying data stored in secondary indexes. Due to the presence of transactions, data can only be removed from the index after the transaction that performed the delete is committed and no further transactions that refer to the old entry are still present in the index. As a result, transactions that perform deletions followed by insertions may trigger unexpected, unique constraint violations, as the deleted tuple has not yet been removed from the index. For example: GORM will update the deleted at column when you perform a db.Delete() . so your db.Delete() will be translate to: And it cause an error: That is why you should not use the default gorm.Model structure and manually use ID , CreatedAt and UpdatedAt . For more info, see DuckDB documentations. --- JSONB DuckDB doesn't support JSONB schema yet, so whenever you use gorm:\"type:jsonb\" , it wil","default_branch":null,"files":null,"tree":[],"storefront":"/r/alifiroozi80","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/alifiroozi80/duckdb/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}