etirk

5 ms·

1.
by etirk 5y ago
Did not try that kind of index on postgres. Thx. Will keep that on the list for benchmarking.
2.
by etirk 5y ago
Not at all. However, clickhouse is one of the underlying DBs on our list of test ports. We have been VERY curious how it would perform on clickhouse. In fact, there are some particular features of SFSQL such as 2 stage deletes and the gener
3.
by etirk 5y ago
"terrifying" is understood. However, the system is NOT indexing every single permutation of attributes possible. That would be impossible of course. Please see the FAQ on indexing for more info: https://schemafreesql.co
4.
by etirk 5y ago
That's a problem that standard SQL tables encounter - chasing new columns with new/modified indexes. (more info at our FAQ). SFSQL never runs into that problem since the indexes are static in structure. No new indexes are made, ev
5.
by etirk 5y ago
I agree with getting some benchmarks up there. Until that's done, I can share what some preliminary tests revealed. Just to give you more of feel for where this tool might fit. We imported the complete Clinical Trials dataset (380k doc
6.
by etirk 5y ago
So right. It is VERY difficult to query a hand-rolled EAV structure. Kinda like editing a binary image with a text editor, lol. Please check out some of the demo queries. Hope you think it's as slick as we do.
7.
by etirk 5y ago
Exactly what you are getting! But without having to code, optimize and maintain your own EAV structure and API.
8.
by etirk 5y ago
Yes, an EAV pattern is being used. The end result in query speed with the particular table designs and indexes is essentially just like what index intersection gives you but without the setup. And of course EAV is not a pattern that you can
9.
by etirk 5y ago
That WOULD be horrible. But we arent doing that. In essence we found that JOINS using optimized indexes are less costly than full table scans (on unindexed attributes).
10.
by etirk 5y ago
And just to be clear. This is NOT a mutually exclusive solution. Just as people use a combination of different databases for different projects and even within the same project, SFSQL can be used alongside other solutions. It is especially
11.
by etirk 5y ago
Glad you asked about the JSON datatype. The Postgres JSON type is a great addition and certainly works well. Especially for situations where you have some common traits shared across something like 'products' (e.g. price), store t
12.
by etirk 5y ago
Thanks! - How is data stored internally? During our beta we will be hosting the databases and the underlying table structures are not viewable. However, on release, you will have full access to inspect the tables and indexes as they will be
13.
Show HN: A Schemaless Data Store Within Your SQL Database(schemafreesql.com)
2 points by etirk 5y ago|0 comments
14.
by etirk 14y ago
Several document-based database systems claim to be schamaless, yet when your data demands cross-document relations (esp. many-to-many), something ugly rears its head which usually ends with you performing multiple queries and relating (or
15.
Show HN: schemafreedb.com - new, dream database service for web developers?
6 points by etirk 14y ago|3 comments
16.
by etirk 14y ago
Hello, I'm Eric, developer and co-founder of Xornet, Inc. the company behind our new service, SchemafreeDB. SchemafreeDB was designed from the ground-up to enable Rapid Database Development. SchemafreeDB's unique combination of features inc