# 🚀 Relica v0.4.1-beta Released - Shorter, Cleaner API!

[kolkov]

Hey everyone! 👋

We're excited to announce Relica v0.4.1-beta with a focus on developer ergonomics - your daily code just got shorter and cleaner!

---

🎯 What Changed?

We listened to feedback comparing Relica to ozzo-dbx and realized: "Why type db.Builder().Select() when db.Select() is clearer?"

So we fixed it! ✨

Before (v0.4.0):

db.Builder().Select("*").From("users").All(&users)
db.Builder().Insert("users", data).Execute()
db.Builder().Update("users").Set(data).Where("id = ?", 1).Execute()

Now (v0.4.1):

db.Select("*").From("users").All(&users)  // 10 chars shorter!
db.Insert("users", data).Execute()
db.Update("users").Set(data).Where("id = ?", 1).Execute()

But don't worry! For advanced features (CTEs, UNION, subqueries), Builder() is still there:

db.Builder().With("stats", cte).Select("*").From("stats").All(&results)

---

✨ New Convenience Methods

We added 8 shortcut methods (4 on DB, 4 on Tx):

• Select(cols...) - Create SELECT query
• Insert(table, data) - Create INSERT query
• Update(table) - Create UPDATE query
• Delete(table) - Create DELETE query

100% backward compatible - all your v0.4.0 code continues to work! 🎉

---

📊 By The Numbers

• 326 tests (up from 310)
• 93.3% coverage (up from 92.9%)
• 0 linting issues
• 0 breaking changes
• Zero performance overhead (compiler inlines everything)

---

🎓 When To Use What?

Use the short syntax (db.Select()) for:

• Simple CRUD operations
• Daily queries you write 100 times
• Quick prototyping

Use Builder() for:

• Common Table Expressions (WITH)
• Set operations (UNION, INTERSECT)
• Complex subqueries
• Multiple JOINs with CTEs

---

📦 Get Started

go get -u github.com/coregx/relica@v0.4.1-beta

Quick example:

package main

import "github.com/coregx/relica"

func main() {
    db, _ := relica.Open("postgres", dsn)
    defer db.Close()

    // New shorter syntax! 🎉
    var users []User
    err := db.Select("id", "name", "email").
        From("users").
        Where("active = ?", true).
        OrderBy("name").
        All(&users)
}

---

🔗 Links

• Release Notes: https://github.com/coregx/relica/releases/tag/v0.4.1-beta
• Full Changelog: v0.4.0-beta...v0.4.1-beta
• Documentation: https://pkg.go.dev/github.com/coregx/relica@v0.4.1-beta

---

💬 We Want Your Feedback!

This release was inspired by community discussions about API ergonomics. Keep the feedback coming!

Questions? Issues? Ideas? Drop them here or open a GitHub Issue.

---

🔮 What's Next?

We're planning v0.5.0-beta with production hardening features:

• Query optimizer (auto-index hints)
• EXPLAIN integration
• OpenTelemetry tracing
• Advanced connection pooling

Want to influence the roadmap? Stay tuned for the v0.5.0 feature prioritization poll coming soon!

---

Happy coding! 🚀

P.S. Special thanks to the ozzo-dbx project for API inspiration!