genSQL Alternatives
Similar projects and alternatives to genSQL
-
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
-
-
-
-
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.
-
-
genSQL discussion
genSQL reviews and mentions
-
Squeeze the hell out of the system you have
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?
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.
Stats
stephanGarland/genSQL is an open source project licensed under Mozilla Public License 2.0 which is an OSI approved license.
The primary programming language of genSQL is Python.
Popular Comparisons
Sponsored