Viewing profile — etirk

Did not try that kind of index on postgres. Thx. Will keep that on the list for benchmarking.

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 partic…

"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 …

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 ar…

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 …

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 …

Exactly what you are getting! But without having to code, optimize and maintain your own EAV structure and API.

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 withou…

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

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, SF…

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 acro…

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 f…

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…

Hello, I'm Eric, developer and co-founder of Xornet, Inc. the company behind our new service, SchemafreeDB. This is a 2nd submission... we removed some obscurity from the original …

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 De…