Tags: sql

Four Tips for a More Secure Website

Security is a hot topic in web development with great reason. Every few months a major website is cracked and millions of user records are leaked. Many times the cause of a breach is from a simple vulnerability that has been overlooked. Here are a few tips to give you a quick overview of standard...
Read 0 Comments

redis.png

redis
Key:value NoSQLs include Redis, Riak, and Berkeley DB, which has been around forever.

What Is NoSQL?

NoSQL databases are one of those fun topics where people get all excited because it's cool and new. But, they're really not new, they're different from SQL databases, and they have different use cases. NoSQL is not going to make world peace or give you your own private holodeck but, aside from...
Read 1 Comments

Web Developer Security Checklist

Developing secure, robust web applications in the cloud is hard, very hard. If you think it is easy, you are either a higher form of life or you have a painful awakening ahead of you. If you have drunk the MVP Kool-aid and believe that you can create a product in one month that is both valuable and...
Read 0 Comments

Bringing Interactive BI to Big Data

SQL on Hadoop is continuously improving, but it's still common to wait minutes to hours for a query to return. In this post, we will discuss the open source distributed analytics engine Apache Kylin and examine, specifically, how it speeds up big data query orders, and what some of the features in...
Read 0 Comments

With Version 2.0, Crate.io’s Database Tools Put an Emphasis on IoT

Crate.io, the winner of our Disrupt Europe 2014 Battlefield, is launching version 2.0 of its CrateDB database today. The tool, which is available in both an open source and enterprise version, started out as a general-purpose but highly scalable SQL database. Over time, though, the team found that...
Read 0 Comments

Shasta: Interactive Reporting at Scale

Shasta: Interactive Reporting At Scale Manoharan et al., SIGMOD 2016 You have vast database schemas with hundreds of tables, applications that need to combine OLTP and OLAP functionality, queries that may join 50 or more tables across disparate data sources, oh, and the user is waiting, so you’d...
Read 0 Comments

A Beginners Guide to SQL

If you’re anything like me, SQL is one of those things that may look easy at first (it reads just like regular english!), but for some reason you can’t help but google the correct syntax for every silly query. Is it “SELECT * WHERE a=b FROM c” or “SELECT WHERE a=b FROM c ON *” ?Then, you get to...
Read 0 Comments
Click Here!