genSQL Alternatives

Similar projects and alternatives to genSQL

hyperfine

74 19,952 8.1 Rust genSQL VS hyperfine

A command-line benchmarking tool
xsv

64 10,089 0.0 Rust genSQL VS xsv

A fast CSV command line toolkit written in Rust.
InfluxDB

www.influxdata.com featured

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.
citus

61 9,840 9.4 C genSQL VS citus

Distributed PostgreSQL as an extension
the_silver_searcher

59 25,720 0.0 C genSQL VS the_silver_searcher

A code-searching tool similar to ack, but faster.
readyset

24 3,882 9.8 Rust genSQL VS readyset

Readyset is a MySQL and Postgres wire-compatible caching layer that sits in front of existing databases to speed up queries and horizontally scale read throughput. Under the hood, ReadySet caches the results of cached select statements and incrementally updates these results over time as the underlying data changes.
ack3

21 673 4.3 Perl genSQL VS ack3

ack is a grep-like search tool optimized for source code.
pygrep

2 0 8.3 Python genSQL VS pygrep

python string and regex search
SaaSHub

www.saashub.com featured

SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a better genSQL alternative or higher similarity.

Suggest an alternative to genSQL

genSQL reviews and mentions

Posts with mentions or reviews of genSQL. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2023-08-11.

Squeeze the hell out of the system you have
4 projects | news.ycombinator.com | 11 Aug 2023

If you’re limited in RAM and can’t upsize, then yes, this does appear to be a good trade off. You can always refactor later and normalize if necessary.
BTW, although it wouldn’t have helped for your specific benchmark schema creation of TYPES, I’ll plug my genSQL tool [0] for generating random data. It’s primarily designed around MySQL, but it can produce CSVs easily, which every DB can load.
Turns out a lot of random() calls in most languages is slow af, so mine avoids that by (mostly) batching them in a C library. Should be able to create a million somethings in under 10 seconds on modern hardware in Python 3.11.
[0]: https://github.com/stephanGarland/genSQL
Any Linux admins willing to try Pygrep?
6 projects | /r/linuxadmin | 18 Mar 2023

Oh yes, absolutely. I ran into a similar problem with a project I'm working on, and I had a conditional that would only import numpy if it already existed. Then again, mine wasn't something you'd call all the time, so the slowdown was worth it. Ultimately, I wound up using a C library to allocate the array (and to shuffle the ints), but it's worth noting that this is an array of uint32_t, and I'm not performing any regexes on them.