Databases

Stunnel Security for Oracle

Oracle has integrated modern Transport Layer Security (TLS) network encryption into its eponymous database product, and TLS usage no longer requires the Advanced Security option beginning with the 10.2 database release. more>>

EnterpriseDB's EDB Postgres Advanced Server and EDB Postgres Enterprise Manager

The elegance of open source is on full display with new product releases like EnterpriseDB's (EDB's) new PostreSQL-based database solutions. On the heels of the significant more>>

Tune Up Your Databases!

My last full-time job was manager of a university's database department. Ironically, I know very, very little about databases themselves. I'm no longer in charge of college databases, but I still do have a handful of MySQL servers that run my various Web applications. Apart from apt-get install, I have no idea how to make databases work. Thankfully, help is available. more>>

Use Your Database!

I love high-level, dynamically typed languages, such as Python, Ruby and JavaScript. They're easy—and even fun—to use. They let me express myself richly, and they lend themselves to code that easily can be reused and maintained. It's no surprise that interest in such languages is on the rise, especially when creating Web applications. more>>

Django Models

In my last article, I continued looking at the Django Web framework, showing how you can create and modify models. As you saw, Django expects you to describe your models using Python code. The model description is then transformed into SQL and compared with any previous version of the model that might have existed. more>>

Django Models and Migrations

In my last two articles, I looked at the Django Web application framework, written in Python. Django's documentation describes it as an MTV framework, in which the acronym stands for model, template and views. more>>

PostgreSQL, the NoSQL Database

One of the most interesting trends in the computer world during the past few years has been the rapid growth of NoSQL databases. The term may be accurate, in that NoSQL databases don't use SQL in order to store and retrieve data, but that's about where the commonalities end. NoSQL databases range from key-value stores to columnar databases to document databases to graph databases. more>>

Adminer—Better Than Awesome!

I've always loved PHPMyAdmin for managing MySQL databases. It's Web-based, fairly robust and as powerful as I've ever needed. Basically, it's awesome. Today, however, I discovered something better than awesome: Adminer. Although it is conceptually identical to PHPMyAdmin, it is far simpler and far more powerful. How can it be both? more>>

Rails and PostgreSQL

Regular readers of this column won't be surprised to hear that I love both Ruby on Rails and PostgreSQL. Rails has been my primary server-side Web development framework for about eight years, and it has managed to provide solutions for a large number of consulting and personal projects. more>>

SQLAlchemy

Although it sometimes might seem as if relational databases have gone the way of the dinosaur, making way for non-relational (NoSQL) databases, such as MongoDB and Cassandra, a very large number of systems still depend on a relational database. more>>

Database Integrity and Web Applications

Want to improve the integrity of your data? Place constraints in the database, as well as in your application. more>>

The Past, Present and Future of GIS: PostGIS 2.0 Is Here!

Extend PostgreSQL's capabilities with PostGIS 2.0 and discover all the magic of spatial databases. more>>

Database

Moving Databases

I recently moved my personal website from GoDaddy to my home server. I have a business connection at my house, and my site gets little enough traffic that hosting at home on my static IP makes sense. Moving the files wasn't really difficult, I FTP'd them down from the old server, and SFTP'd them up to the new server. Moving the database was a bit more challenging, however. more>>

<h3> Processing </h3>

REDCap: A Tool for Collecting Clinical Trials Data

In the course of my day job I tend to get drawn into interesting niche projects because of my Linux expertise. Recall that the Mothership (that corporate entity located somewhere on the East coat which pays me fairly well to work for them) is *shudder* a Windows shop, primarily. more>>

PostgreSQL 9.0 Released

PostgreSQL version 9.0 was released yesterday (Sept 20th). The 9.0 version of PostgreSQL includes a number of important new features, more new features in fact than any previous release. more>>

Syndicate content