Blogs

BROWSE: Most Recent | Popular Tags |

Tags > sql

5 ways developers win with PaaS

By Katie Miller
April 21, 2014

As a software developer, you are no doubt familiar with the process of abstracting away unnecessary detail in code — imagine if that same principle were applied to application hosting. Say hello to Platform as a Service (PaaS), which enables …

Just Enough Arel

By Samuel Mullen
March 27, 2014

If you were a web developer prior to ActiveRecord, you probably remember rolling your own SQL and being specific about which fields you retrieved, writing multiple queries to handle “upserts” (update or insert), and getting frustrated with how difficult it was to generate …

Four short links: 27 September 2013

By Nat Torkington
September 24, 2013

The Amen Break (YouTube) — fascinating 20m history of the amen break, a handful of bars of drum solo from a forgotten 1969 song which became the origin of a huge amount of popular music from rap to jungle and …

Four short links: 20 September 2013

By Nat Torkington
September 19, 2013

Researchers Can Slip an Undetectable Trojan into Intel’s Ivy Bridge CPUs (Ars Technica) — The exploit works by severely reducing the amount of entropy the RNG normally uses, from 128 bits to 32 bits. The hack is similar to stacking …

Four short links: 18 September 2013

By Nat Torkington
September 18, 2013

No Managers — If we could find a way to replace the function of the managers and focus everyone on actually producing for our Students (customers) then it would actually be possible to be a #NoManager company. In my future …

Four short links: 10 September 2013

By Nat Torkington
September 8, 2013

Sparkey — Spotify’s open-sourced simple constant key/value storage library, for read-heavy systems with infrequent large bulk inserts. The Truth of Fact, The Truth of Feeling (Ted Chiang) — story about what happens when lifelogs become searchable. Now with Remem, finding …

Four short links: 30 August 2013

By Nat Torkington
August 29, 2013

intention.js — manipulates the DOM via HTML attributes. The methods for manipulation are placed with the elements themselves, so flexible layouts don’t seem so abstract and messy. Introducing Brick: Minimal-markup Web Components for Faster App Development (Mozilla) — a cross-browser …

Interactive Big Data analysis using approximate answers

By Ben Lorica
August 17, 2013

Interactive query analysis for (Hadoop scale data) has recently attracted the attention of many companies and open source developers – some examples include Cloudera’s Impala, Shark, Pivotal’s HAWQ, Hadapt, CitusDB, Phoenix, Sqrrl, Redshift, and BigQuery. These solutions use distributed computing, …

NoSQL Choices: To Misfit or Cargo Cult?

By Eric Redmond
July 29, 2013

Retreading old topics can be a powerful source of epiphany, sometimes more so than simple extra-box thinking. I was a computer science student, of course I knew statistics. But my recent years as a NoSQL (or better stated: distributed systems) …

Why Choose a Graph Database

By Michael Hunger
July 23, 2013

By this time, chances are very likely that you’ve heard of NoSQL, and of graph databases like Neo4j. NoSQL databases address important challenges that we face today, in terms of data size and data complexity. They offer a valuable solution …

A Hands-on Introduction to R

By Ray DiGiacomo, Jr.
July 23, 2013

R is an open-source statistical computing environment similar to SAS and SPSS that allows for the analysis of data using various techniques like sub-setting, manipulation, visualization and modeling. There are versions that run on Windows, Mac OS X, Linux, and …

Augmenting Unstructured Data

By Jesse Anderson
July 17, 2013

Our world is filled with unstructured data. By some estimates, it’s as high as 80% of all data. Unstructured data is data that isn’t in a specific format. It isn’t separated by a delimiter that you could split on and …

Scaling People, Process, and Technology with Python

By Dave Himrod
July 15, 2013

NOTE: If you are interested in attending OSCON to check out Dave’s talk or the many other cool sessions, click over to the OSCON website where you can use the discount code OS13PROG to get 20% off your registration fee. …

High Availability with MySQL and Moving to MongoDB

By Rachel Roumeliotis
July 4, 2013

Henrik Ingo (@h_ingo) is a MySQL architect, author, and OSCON 2013 Speaker. In this interview we talk about high availability in MySQL and why he switched to MongoDB. NOTE: If you are interested in attending OSCON to check out Henrik’s …

Analytic engines that factor in security labels

By Ben Lorica
June 23, 2013

Originated by the NSA, Apache Accumulo is a BigTable inspired data store known for being highly scalable and for its interesting security model. Federal agencies and Defense contractors have deployed Accumulo on clusters of a thousand or more servers. It …

The Power of a Private HTTP Archive Instance: Finding a Representative Performance Baseline

By Barbara Bermes
June 13, 2013

Be honest, have you ever wanted to play Steve Souders for a day and pull some revealing stats or trends about some web sites of your choice? Or maybe dig around the HTTP archive? You can do that and more …

Ins and Outs of Running MySQL on AWS

By Jenn Webb
June 12, 2013

In the following interview, PalominoDB owner and CEO Laine Campbell discusses advantages and disadvantages of using Amazon Web Services (AWS) as a platform for running MySQL. The solution provides a functional environment for young startups who can’t afford a database …

The Future Is Graph Databases

By Rachel Roumeliotis
June 5, 2013

Emil Eifrem @emileifrem is the Founder of Neo4j and CEO of Neo Technology. He is also one of the authors of Graph Databases. Recently, I had the opportunity to sit down with Emil and we talked about the current and …

Beyond Puppet and Chef: Managing PostgreSQL with Ansible

By Courtney Nash
May 28, 2013

Think configuration management is simply a decision between Chef or Puppet? PalaminoDB CTO (and Lead DB Engineer for Obama’s 2012 campaign) Jay Edwards (@meangrape) discusses his upcoming Velocity talk about Ansible, an alternative configuration management offering that is quick and easy …

Four short links: 30 April 2013

By Nat Torkington
April 24, 2013

China = 41% of World’s Internet Attack Traffic (Bloomberg) — numbers are from Akamai’s research. Verizon Communications said in a separate report that China accounted for 96 percent of all global espionage cases it investigated. One interpretation is that China …

Four short links: 23 April 2013

By Nat Torkington
April 23, 2013

Drawscript — Processing for Illustrator. (via BERG London) Archive Team Warrior — a virtual archiving appliance. You can run it to help with the ArchiveTeam archiving efforts. It will download sites and upload them to our archive. (via Ed Vielmetti) …

Returning transactions to distributed data stores

By O'Reilly Strata
March 26, 2013

By David Rosenthal and Stephen Pimentel Rise of NoSQL Database technologies are undergoing rapid evolution, with new approaches being actively explored after decades of relative stability. As late as 2008, the term “NoSQL”  barely existed and relational databases were both …

Four short links: 1 March 2013

By Nat Torkington
March 1, 2013

Drone Journalism — two universities in the US have already incorporated drone use in their journalism programs. The Drone Journalism Lab at the University of Nebraska and the Missouri Drone Journalism Program at the University of Missouri both teach journalism …

Geolocation in MongoDB at the Silicon Valley MongoDB User Group

By Shashank Tiwari
January 19, 2013

Thanks to all of you, who were able to join me at the session on January 15, 2013. Thanks much for the kind remarks some of you left behind on the meetup message board, post the session.  Its very rewarding...

Four data themes to watch from Strata + Hadoop World 2012

By Roger Magoulas
November 8, 2012

At our successful Strata + Hadoop World conference (including successfully avoiding Sandy), a few themes emerged that resonated with my interests and experience as a hands-on data analyst and as a researcher who tracks technology adoption trends. Keep in mind …

Four short links: 26 July 2012

By Nat Torkington
July 26, 2012

Drones Over Somalia are Hazard to Air Traffic (Washington Post) — In a recently completed report, U.N. officials describe several narrowly averted disasters in which drones crashed into a refu­gee camp, flew dangerously close to a fuel dump and almost …

The key web technologies that work together for dynamic web sites

The key web technologies that work together for dynamic web sites
By Andy Oram
July 12, 2012

The technologies that led to an explosion of interactive web sites — PHP, MySQL, JavaScript, and CSS — are still as popular today, and a non-programmer can master them quickly.

Four short links: 15 June 2012

By Nat Torkington
June 15, 2012

In Flawed, Epic Anonymous Book, the Abyss Gazes Back (Wired) -- Quinn Norton's review of a book about Anonymous is an excellent introduction to Anonymous. Anonymous made us, its mediafags, masters of hedging language. The bombastic claims and hyperbolic declarations must be reported from their mouths, not from our publications. And yet still we make mistakes and publish lies...

Four short links: 8 June 2012

By Nat Torkington
June 8, 2012

HAproxy -- high availability proxy, cf Varnish. Opera Reviews SPDY -- thoughts on the high-performance HTTP++ from a team with experience implementing their own protocols. Section 2 makes a good intro to the features of SPDY if you've not been keeping up. Jetpants -- Tumblr's automation toolkit for handling monstrously large MySQL database topologies. (via Hacker News) LeakedIn --...

Object/NoSQL Mapping for Riak with Dasein Persist

By George Reese
May 29, 2012

One of the more snarky things you will hear said about NoSQL databases is that they are "write-only" databases or "no query" databases. It is fair to say that NoSQL databases are often challenging to pull data from when you are doing more than fetching values by their keys. The Open Source Dasein Persist object/relational mapping tool helps solve that problem for Java programmers using Riak.

MySQL in 2012: Report from Percona Live

By Andy Oram
April 14, 2012

Contrasting deployments at craigslit and Pinterest, trends, commercial offerings, and more

Data's next steps

By Timothy M. O'Brien
April 3, 2012

Redmonk analyst Steve O'Grady discusses the demand for data scientists, the problem of using data to asking the right questions, and why you shouldn't rush into a NoSQL investment.

Data's next steps

By Timothy M. O'Brien
April 3, 2012

Redmonk analyst Steve O'Grady discusses the demand for data scientists, the problem of using data to asking the right questions, and why you shouldn't rush into a NoSQL investment.

Top stories: February 6-10, 2012

Top stories: February 6-10, 2012
By Mac Slocum
February 10, 2012

This week on O'Reilly: Mike Loukides surveyed the NoSQL database landscape, the open web scored an important victory in court, and Joe Wikert said it's time to embrace a unified ebook format and abandon DRM.

The NoSQL movement

By Mike Loukides
February 8, 2012

A relational database is no longer the default choice. Mike Loukides charts the rise of the NoSQL movement and explains how to choose the right database for your application.

The NoSQL movement

The NoSQL movement
By Mike Loukides
February 8, 2012

A relational database is no longer the default choice. Mike Loukides charts the rise of the NoSQL movement and explains how to choose the right database for your application.

Developer Week in Review: Talking to your phone

Developer Week in Review: Talking to your phone
By James Turner
October 21, 2011

This week, we ask if Apple's Siri has more than novelty value, and decide it does. Open Office needs you (or at least your money) to stay afloat, and Google bends to developer pressure and finally adds SQL support to its cloud computing platform.

Four short links: 18 October 2011

By Nat Torkington
October 18, 2011

Web Search Education (Google) -- lesson plans and materials for teaching people how to use search, from operators to critically evaluating sites. This latter area is the weakest: when I teach innocents about the web, I show them organic vs paid results, discuss why people advertise, how people pay for their sites, noticing domain names and organizations, etc. I...

Four short links: 10 October 2011

By Nat Torkington
October 10, 2011

Why Education Startups Do Not Succeed --This fundamental investment vs. expenditure mindset changes everything. You think of education as fundamentally a quality problem. The average person thinks of education as fundamentally a cost problem. This and many other insights that repay the reading. (via Hacker News) Romo -- smartphone robotics platform Kickstarter project. Google Cloud SQL -- Google offers...

Top Stories: October 3-7, 2011

Top Stories: October 3-7, 2011
By Mac Slocum
October 7, 2011

This week on O'Reilly: Edd Dumbill explained why Oracle's Big Data Appliance is both a validation and a sign of battles to come, we dug into PhoneGap's cross-platform app capabilities, and we surveyed New York City's data and open government efforts.

Strata Week: Oracle's big data play

Strata Week: Oracle's big data play
By Audrey Watters
October 6, 2011

In this week's data news, Oracle unveils its big data strategy, and Cloudera looks at the contributions to the Hadoop core and community.

Oracle's NoSQL

By Mike Loukides
October 6, 2011

Oracle's announcement of a NoSQL product isn't just a validation of key-value stores, but of the entire discussion of database architecture.

Strata Week: Oracle's big data play

By Audrey Watters
October 6, 2011

In this week's data news, Oracle unveils its big data strategy, and Cloudera looks at the contributions to the Hadoop core and community.

Oracle's NoSQL

By Mike Loukides
October 6, 2011

Oracle's announcement of a NoSQL product isn't just a validation of key-value stores, but of the entire discussion of database architecture.

Four short links: 4 October 2011

By Nat Torkington
October 4, 2011

jfdi.asia -- Singaporean version of TechStars, with 100-day program ("the bootcamp") Jan-Apr 2012. Startups from anywhere in the world can apply, and will want to because Singapore is the gateway to Asia. They'll also have mentors from around the world. Oracle NoSQLdb -- Oracle want to sell you a distributed key-value store. It's called "Oracle NoSQL" (as opposed to...

Oracle's Big Data Appliance: what it means

By Edd Dumbill
October 3, 2011

Today, Oracle announced their Big Data Appliance. It couldn't be a plainer validation of what's important in big data right now, or where the battle for technology dominance lies.

Oracle's Big Data Appliance: what it means

By Edd Dumbill
October 3, 2011

Today, Oracle announced their Big Data Appliance. It couldn't be a plainer validation of what's important in big data right now, or where the battle for technology dominance lies.

Developer Week in Review: Lion drops pre-installed MySQL

Developer Week in Review: Lion drops pre-installed MySQL
By James Turner
August 3, 2011

A pre-installed version of MySQL is noticeably absent from Lion Server, South Korea penalizes Apple for the location brouhaha, and Java 7's compiler injects a bit of randomness into software development.

Four short links: 1 August 2011

By Nat Torkington
August 1, 2011

The Flashed Face Effect Video -- your brain is not perfect, and it reduces faces to key details. When they flash by in the periphery of your vision, you perceive them as gross and freakish. I like to start the week by reminding myself how fallible I am. Good preparation for the rest of the week... (via BERG London)...

Four short links: 29 July 2011

By Nat Torkington
July 29, 2011

SQL Injection Pocket Reference (Google Docs) -- just what it sounds like. (via ModSecurity SQL Injection Challenge: Lessons Learned) isostick: The Optical Drive in a Stick (KickStarter) -- clever! A USB memory stick with drivers that emulate optical drives so you can boot off .iso files you've put on the memory stick. (via Extreme Tech) CrowdDB: Answering Queries with...


1 to 50 of 137 Next
The Watering Hole