InfoQ

InfoQ

Topic/Tag specific view

SQL Content on InfoQ


Latest featured content about SQL

Rich Hickey on Datomic: Datalog, Databases, Persistent Data Structures

Topics
Clojure,
SQL,
NoSQL,
Relational Databases,
Concurrency,
JVM Languages,
Database Design,
Data Access,
LISP,
Languages,
Database,
Programming,
Transactions,
Java

Rich Hickey explains the ideas behind the Datomic database: why Datalog is used as the query language, the functional programming concepts at its core, the role of time in the DB and much more.

News about SQL

FluentData: A New, Lightweight ORM with a Fluent API

Topics
SQL,
.NET,
Relational Databases,
Programming,
ORM,
Micro-ORM,
Database

FluentData is a new introduction to the micro-ORM family that aims to be more straightforward to use than full ORMs like NHibernate and Entity Framework. It uses a fluent API and supports SQL Server, SQL Azure, Oracle, and MySQL.

Hybrid SQL-NoSQL Databases Are Gaining Ground

Topics
SQL,
NoSQL,
Data Access,
Relational Databases,
Scalability,
Database,
Performance & Scalability

Hybrid SQL-NoSQL database solutions combine the advantage of being compatible with many SQL applications and providing the scalability of NoSQL ones. Xeround offers such a solution as a service in the cloud, including a free edition. Other solutions: Database.com with ODBC/JDBC drivers, NuoDB, Clustrix, and VoltDB.

VMware Releases SQLFire 1.0

Topics
Java,
SQL,
Caching,
SpringSource,
Persistence,
Languages,
VMWare,
Relational Databases,
Clustering & Caching,
Data Access,
Data Partitioning,
Programming,
Database,
vFabric,
Database Replication,
Infrastructure,
GemFire,
Performance & Scalability,
Companies

VMware releases SQLFire 1.0 a distributed SQL database geared towards high availability and horizontal scalability which offers table replication, table partitioning and parallel execution of queries.

Heroku Launches Postgres as a Standalone Service.

Topics
Postgres,
SQL,
Relational Databases,
Platforms,
PaaS,
Performance & Scalability,
Programming,
Cloud Computing,
Database,
Database Replication

Until now, Postgres was only available to Heroku customers for use with Heroku platform apps. This new service can be used from anywhere and with any Postgres client. Apps can connect from Heroku, Google App Engine, Microsoft Azure, Cloud Foundry, EC2, or from your local computer while PostgreSQL is supported by most modern programming languages - including Perl, Python, Ruby, Scala ...

Interview: Richard Hipp on UnQL, a New Query Language for Document Databases

Topics
CouchDB,
Couchbase,
Distributed Document Oriented Database,
Companies,
SQL,
NoSQL,
Data Access,
Relational Databases,
UnQL,
Architecture,
Database,
Language,
Document DB

This interview with Richard Hipp, creator of SQLite, unveils the details of UnQL, a new query language for JSON document databases. Hipp mentions UnQLite, an embedded document database he plans to create.

Articles about SQL

Making Microsoft Sync Framework work with PostgreSql

Topics
.NET Framework,
SQL,
Microsoft,
.NET,
Relational Databases,
Frameworks,
Programming,
Database,
Companies,
Sync Framework

Microsoft Sync Framework is used for occasionally connected clients, for peer-peer applications, and other applications where data needs to be synchronized between multiple data stores. While it doesn’t include providers for non-Microsoft databases, the framework makes it easy to add that support. Roopesh Shenoy demonstrates using PostgreSql.

Presentations about SQL

How to get the most out of Spring and Google App Engine

Topics
SpringOne 2GX 2011,
SpringOne,
Spring,
Application Servers,
Conferences,
Google AppEngine,
Java,
Dependency Injection,
SpringSource,
SQL,
Languages,
Design Pattern,
VMWare,
Google,
PaaS,
Relational Databases,
Performance & Scalability,
Patterns,
Programming,
Object Oriented Design,
SQL Data Services,
Database,
Companies,
Design,
Cloud Computing

Chris Ramsdale will get you up and running building Spring apps on Google App Engine. He'll go step-by-step building a real Spring app and identify not only the basics of App Engine, but more advanced topics such as integrating with Google's SQL Service and using App Engine's "Always on" feature to ensure high performance.

Using MongoDB on Mono

Topics
MongoDB,
SQL Server,
Big Data,
Distributed Document Oriented Database,
Postgres,
SQL,
Mono,
Graph Database,
Relational Databases,
Database Management,
NoSQL,
Microsoft,
Database Design,
.NET,
Database,
Programming,
LINQ,
Companies

Justin Dearing presents a brief introduction to MongoDB, and focuses on interacting with it in Mono via the official 10gen driver. Techniques for handling business logic in application code, such as LINQ are discussed. This is a very code centric talk.

SQLFire: Scalable SQL instead of NoSQL

Topics
Big Data,
SQL,
Database Design,
NoSQL,
Relational Databases,
Architecture,
Database,
Performance & Scalability,
ACID,
What's Next

Jags Ramnaraya presents SQLFire and how SQL can be used for modern data stores backing online highly scalable applications by using a different consistency model and sharing nothing persistence.

Yes, SQL!

Topics
JPA,
Memcache,
JDBC,
Java,
Big Data,
QCon London 2011,
Caching,
SQL,
Java EE,
Clustering & Caching,
Languages,
Database Design,
NoSQL,
.NET,
Data Access,
Relational Databases,
QCon,
Conferences,
Infrastructure,
Programming,
Architecture,
Performance & Scalability,
Database,
GigaSpaces

Uri Cohen presents the key characteristics of SQL and NoSQL databases and how to create a layer on top of distributed data stores in order to use SQL to query for data. For further information please contact Gigaspaces.