sqlite VS go

Compare sqlite vs go and see what are their differences.

InfluxDB - Power Real-Time Data Analytics at Scale
Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
www.influxdata.com
featured
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com
featured
sqlite go
73 2,073
- 119,564
- 1.2%
- 10.0
- 7 days ago
Go
- BSD 3-clause "New" or "Revised" License
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.

sqlite

Posts with mentions or reviews of sqlite. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2024-04-30.
  • Show HN: Roast my SQLite encryption at-rest
    8 projects | news.ycombinator.com | 30 Apr 2024
  • Show HN: My Go SQLite driver did poorly on a benchmark, so I fixed it
    11 projects | news.ycombinator.com | 14 Dec 2023
    > I would've probably picked the modernc variation

    Heads up about the modernc library, it has been stuck on an old version of sqlite for several months [1]. It seems like maintainer time is the limiting factor [2]. There has been a call to arms on that issue page, the maintainer is looking for help, but it looks like not much has arrived. It seems like it might trace back to blockers in the C-to-Go compiler.

    It's a major undertaking and a very impressive piece of work, but I'm not surprised it's a struggle when big roadblocks get hit. I hope they find a way to progress, but I'm very relieved to be seeing some CGo-free alternatives like ncruces/go-sqlite3 emerging. I'm going to give it a try for sure and see if I can live with the compromises.

    Squinn-go looks very compelling too, but I don't like that it requires the squinn binary to already be installed on a user's machine, I think that gives with one hand and takes with the other: sure, I get to avoid CGo, but I also lose the turnkey, single-command install, static build benefits Go brings out of the box.

    Seconding the point about nitty gritty, I'd read it for sure too!

      [1]: https://gitlab.com/cznic/sqlite/-/issues/154
  • Show HN: Sqinn-Go is a Golang library for accessing SQLite databases in pure Go
    14 projects | news.ycombinator.com | 4 Oct 2023
    No, but that has the disadvantage of being C compiled into Go, then being compiled into native executable.

    I'm actually surprised by how readable this came out; props to the Go->C compiler author. But you can guess that pushing this sort of thing through the Go compiler is going to cause some slowdowns due to sheer paradigm mismatch: https://gitlab.com/cznic/sqlite/-/blob/master/lib/sqlite_lin...

  • Show HN: MongoDB Protocol for SQLite
    5 projects | news.ycombinator.com | 4 Jul 2023
    FWIW, we use a version of SQLite transpiled into Go to avoid CGI problems: https://gitlab.com/cznic/sqlite
  • Go port of SQLite without CGo
    7 projects | /r/golang | 8 Apr 2023
    It could be clearer in the readme, but note that this is a machine translation from C to Go, repeated for every OS-Arch pair. Example of the one you're most likely to use in production: https://gitlab.com/cznic/sqlite/-/blob/master/lib/sqlite_linux_amd64.go
    1 project | /r/patient_hackernews | 7 Apr 2023
    1 project | /r/learngo | 7 Apr 2023
    1 project | /r/hackernews | 7 Apr 2023
    1 project | /r/hypeurls | 7 Apr 2023
    12 projects | news.ycombinator.com | 7 Apr 2023

go

Posts with mentions or reviews of go. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2024-04-30.
  • Microsoft Maintains Go Fork for FIPS 140-2 Support
    5 projects | news.ycombinator.com | 30 Apr 2024
    There used to be the GO FIPS branch :

    https://github.com/golang/go/tree/dev.boringcrypto/misc/bori...

    But it looks dead.

    And it looks like https://github.com/golang-fips/go as well.

  • Borgo is a statically typed language that compiles to Go
    20 projects | news.ycombinator.com | 30 Apr 2024
    Perhaps, but there have been several proposals along those lines and nobody seems capable of figuring out a sensible implementation.

    A funny drawback of the current Go design that a Result type would solve is the need to return zero values of all the declared function return types along with the error: https://github.com/golang/go/issues/21182.

  • AWS Serverless Diversity: Multi-Language Strategies for Optimal Solutions
    4 projects | dev.to | 28 Apr 2024
    Now, I’m not going to use C++ again; I left that chapter years ago, and it’s not going to happen. C++ isn’t memory safe and easy to use and would require extended time for developers to adapt. Rust is the new kid on the block, but I’ve heard mixed opinions about its developer experience, and there aren’t many libraries around it yet. LLRD is too new for my taste, but **Go** caught my attention.
  • How to use Retrieval Augmented Generation (RAG) for Go applications
    3 projects | dev.to | 28 Apr 2024
    Generative AI development has been democratised, thanks to powerful Machine Learning models (specifically Large Language Models such as Claude, Meta's LLama 2, etc.) being exposed by managed platforms/services as API calls. This frees developers from the infrastructure concerns and lets them focus on the core business problems. This also means that developers are free to use the programming language best suited for their solution. Python has typically been the go-to language when it comes to AI/ML solutions, but there is more flexibility in this area. In this post you will see how to leverage the Go programming language to use Vector Databases and techniques such as Retrieval Augmented Generation (RAG) with langchaingo. If you are a Go developer who wants to how to build learn generative AI applications, you are in the right place!
  • From Homemade HTTP Router to New ServeMux
    4 projects | dev.to | 26 Apr 2024
    net/http: add methods and path variables to ServeMux patterns Discussion about ServeMux enhancements
  • Building a Playful File Locker with GoFr
    4 projects | dev.to | 19 Apr 2024
    Make sure you have Go installed https://go.dev/.
  • Fastest way to get IPv4 address from string
    1 project | news.ycombinator.com | 14 Apr 2024
  • We now have crypto/rand back ends that ~never fail
    1 project | news.ycombinator.com | 14 Apr 2024
  • Why Go is great choice for Software engineering.
    2 projects | dev.to | 7 Apr 2024
    The Go Programming Language
  • OpenBSD 7.5 Released
    5 projects | news.ycombinator.com | 5 Apr 2024
    When Go first shipped, it was already well-documented that the only stable ABI on some platforms was via dynamic libraries (such as libc) provided by said platforms. Go knowingly and deliberately ignored this on the assumption that they can get away with it. And then this happened:

    https://github.com/golang/go/issues/16606

    If that's not "getting burned", I don't know what is. "Trying to provide a nice feature" is an excuse, and it can be argued that it is a valid one, but nevertheless they knew that they were using an unstable ABI that could be pulled out from under them at any moment, and decided that it's worth the risk. I don't see what that has to do with "not being as broadly compatible as they had hoped", since it was all known well in advance.

What are some alternatives?

When comparing sqlite and go you can also consider the following projects:

chai - Modern embedded SQL database

v - Simple, fast, safe, compiled language for developing maintainable software. Compiles itself in <1s with zero library dependencies. Supports automatic C => V translation. https://vlang.io

ffi-overhead - comparing the c ffi (foreign function interface) overhead on various programming languages

TinyGo - Go compiler for small places. Microcontrollers, WebAssembly (WASM/WASI), and command-line tools. Based on LLVM.

sqlite - Go SQLite3 driver

zig - General-purpose programming language and toolchain for maintaining robust, optimal, and reusable software.

go-sqlite3 - sqlite3 driver for go using database/sql

Nim - Nim is a statically typed compiled systems programming language. It combines successful concepts from mature languages like Python, Ada and Modula. Its design focuses on efficiency, expressiveness, and elegance (in that order of priority).

sqlparser-rs - Extensible SQL Lexer and Parser for Rust

Angular - Deliver web apps with confidence 🚀

proteus - A simple tool for generating an application's data access layer.

golang-developer-roadmap - Roadmap to becoming a Go developer in 2020