Tag SQL

CockroachDB with Ben Darnell

http://traffic.libsyn.com/sedaily/cockroachdb_Edited.mp3Podcast: Play in new window | Download “Eventual consistency is really kind of a marketing term from some of these NoSQL systems – it’s not really consistent in any strong sense of the term.” Google has published papers on distributed systems such as BigTable, Chubby, and the Google File System. During this episode, we focus on a product that takes inspiration from Google’s Spanner project, a database that is built

Continue reading…

Stream Processing vs. Complex Event Processing

From Srinath Perera’s answer via Quora: I will try to give a description of current status (as of 2015) as opposed to a definition. If you are looking for a definition, the best would be What’s the Difference Between ESP and CEP? As the above picture shows, technically CEP is a subset of Event Stream Processing. However, Stream processing engines and CEP engines are pretty different and they come from different background. Use

Continue reading…

Apache Drill with Tomer Shiran

“It’s a great world to be a developer in. If you’re a developer today, you have so many tools and so many options.”

Continue reading…

SQLite with D. Richard Hipp

“Everybody that sees SQL thinks its ugly and dirty and they want to try and rewrite it to be better. There’s a bazillion attempts to do this – I’ve tried it several times myself. But somehow, everybody always comes back to SQL.”

Continue reading…

Streaming SQL with PipelineDB CEO Derek Nelson

http://traffic.libsyn.com/sedaily/pipelinedb_derek.mp3Podcast: Play in new window | DownloadPipelineDB is a streaming SQL database. Derek Nelson is the CEO of PipelineDB. Questions What are continuous views? Why is PipelineDB a good fit for the Kafka+Storm+HBase-type architecture? How does PipelineDB affect the application tier or the browser tier? What are the latency guarantees for how long it takes raw data streams to be converted into the refined queries provided by a continuous view?

Continue reading…

Two Common Questions About SQL

Nikita Shamgunov, CTO of MemSQL via Quora Why are we still writing SQL? There are several reasons: 1. SQL is a standard and standards are very hard to change. Especially when they work and data is incredibly “sticky”. 2. SQL is declarative: compare a SQL statement producing a report with a Java or even Python program. Then show it to a none-engineer. 3. SQL is very forgiving – something ppl usually

Continue reading…