Live data from Hacker News

Show HN: StrelkiJS - small library to index and SQL-join in-memory collections

github.com

1–10 of 12 posts

Re: Show HN: StrelkiJS - small library to index and SQL-join in-memory collections

#3

Does anyone know of data structures better suited to solve the same goal? (ie fast in memory joins with multiple dimensions, star schema OLAP queries, etc.) ?

Star schema... what is this, the year of our lord 1995?

Re: Show HN: StrelkiJS - small library to index and SQL-join in-memory collections

#4

Does anyone know of data structures better suited to solve the same goal? (ie fast in memory joins with multiple dimensions, star schema OLAP queries, etc.) ?

If you're interested in defining dimensions using tabular data in JS, check out crossfilter.js.

https://github.com/square/crossfilter

Re: Show HN: StrelkiJS - small library to index and SQL-join in-memory collections

#5

Does anyone know of data structures better suited to solve the same goal? (ie fast in memory joins with multiple dimensions, star schema OLAP queries, etc.) ?

Star schema... what is this, the year of our lord 1995?

The star schema is still very useful, even though it wasn't invented in the last six months.

Re: Show HN: StrelkiJS - small library to index and SQL-join in-memory collections

#7
post #4

Does anyone know of data structures better suited to solve the same goal? (ie fast in memory joins with multiple dimensions, star schema OLAP queries, etc.) ?

If you're interested in defining dimensions using tabular data in JS, check out crossfilter.js. https://github.com/square/crossfilter

Crossfilter is amazing, and demo they have with d3.js is really cool.

Re: Show HN: StrelkiJS - small library to index and SQL-join in-memory collections

#8
post #4

Does anyone know of data structures better suited to solve the same goal? (ie fast in memory joins with multiple dimensions, star schema OLAP queries, etc.) ?

If you're interested in defining dimensions using tabular data in JS, check out crossfilter.js. https://github.com/square/crossfilter

The updated link seems to be https://github.com/crossfilter/crossfilter. Crossfilter (the organization) is now actively maintaining and extending Square's original crossfilter implementation.

Re: Show HN: StrelkiJS - small library to index and SQL-join in-memory collections

#9

Does anyone know of data structures better suited to solve the same goal? (ie fast in memory joins with multiple dimensions, star schema OLAP queries, etc.) ?

Star schema... what is this, the year of our lord 1995?

Star schema still has its (very prominent) place with many applications. If my information has some natural structure, I'm not going to go out of my way to un-structure it, and star is sometimes the data structure that best suits the data itself.

Re: Show HN: StrelkiJS - small library to index and SQL-join in-memory collections

#10
This is pretty cool. If you don't mind me asking, did you have a specific application in mind when you decided to write this? Is the idea that your data would be transient (user session?) and that you need to manipulate it, do some things, and then toss it when the work's done?
Post reply on HN