1 min read

How SQLIte Can Make Drupal 7 Code Technology Agnostic

With the advent on Drupal 7, using SQLite as a database backend became a new option. While this ushered in a period of code updates for modules written specifically against MySQL, the Database API provided a clear way to make your code be database agnostic.

Drupal 7 SQLite Database Configuration

 

At CommonPlaces, we use Drupal fairly often on a number of sites. In the past, you could only migrate data from a MySQL database. However, now in Drupal 7, things have changed to include a new alternative in SQLite. But with all these technical changes, I think a lot of the advantages and use cases for SQLite were glossed over. Perhaps the reason is that for the most part... it just keeps working with little outward change.

For those not familiar with SQLite, it is a library that implements a self-contained, serverless, database engine. Its usage is so wide spread, it is hard to name an industry or technology where it is not utilized.

SQLite screenshot

In terms of Drupal, it means that your data is stored in a single file and that your installation just got that much easier. There is no messing around with having an additional database service running and consuming resources.

As a developer, it means I can get up and running quickly, but also keep portability in terms of hosting offerings. During development I can move the entire site from a server to a laptop, without needing to duplicate the MySQL setup at every point or change settings. This is especially true if you want to do offline development and do not have MySQL installed. Likewise, backups of a single site are also just as simple as backing up your web site directory. You know the code and the data from that moment are in sync.

So why would anyone use anything else then? Well... Performance, familiarity, a different level of control, requirements of integration with outside systems. While SQLite holds a lot of promise, it is not meant to be a replacement for MySQL, it is a different offering.

Small and medium sites with reasonable levels of traffic could host from SQLite without any issue. Often the decision is made to move to MySQL prior to public launch, as more hosts are familiar with that type of segmentation and the related support workflows.

Still, it remains a viable choice for many circumstances. Down the road, it will be exciting to see which other database backends become viable candidates for Drupal sites.

Have any questions about SQLite? Contact us!


Related Posts

1 min read

Drupal Multi-Site Technology Presentation at CMS Expo

"Ben Bassi, President and CEO of CommonPlaces e-Solutions, LLC, has been asked to speak at CMS Expo on the subject of Drupal Multi-Site solutions. CMS Expo is a three-day conference based on content...
3 min read

5 Helpful Drupal Modules You May Not Be Using

One of the real strengths of the Drupal community is the wide variety of superb contributed modules that make development tasks easier -- or just make life easier for your client. Here, we'll talk...
3 min read

Are You Technology Agnostic?

How to stay "out of the box” when it comes to choosing a Content Management System (CMS)
2 min read

End of Life Date for Drupal 6 Announced: February 24, 2016

  Last month, the widely used open source website development platform, Drupal, dropped some good news and some bad news. The amazingly good news was the release of Drupal 8, on November 19th, 2015....