Database

Showing 1-9 of 9 results
EngineeringIcon ChevronData Science and Databases

Developing a Bioinformatics Database for Disulfide Bonds Research

by Viktor Bojović

The Protein Data Bank (PDB) bioinformatics database is the world's largest repository of experimentally-determined structures of proteins, nucleic acids, and complex assemblies. All data is gathered using experimental methods such as X-ray, spectroscopy, crystallography, NMR, etc. This article explains how to extract, filter, and clean data from the PDB to make it suitable for further analysis.

25 minute readContinue Reading
EngineeringIcon ChevronTechnology

Bad Practices in Database Design: Are You Making These Mistakes?

by Fernando Martinez

Flaws in your database design are like cracks in your application’s foundations. If left unchecked, trying to fix them down the line will be costly to say the least. In this article, Toptal Freelance Software Engineer Fernando Martinez discusses some of the most common database design bad practices and how to avoid them.

8 minute readContinue Reading
EngineeringIcon ChevronBack-end

Guide to Data Synchronization in Microsoft SQL Server

by Andrej Gajdos

Sharing related information among isolated systems has become increasingly important. There are many methods to choose from to perform that task for SQL Server, but it’s important to know which is better for each use case.

12 minute readContinue Reading
EngineeringIcon ChevronBack-end

PhalconPHP: A Solution for High-load RESTful APIs

by Andrew Belousoff

PhalconPHP will make your high-load application fast and easy, it's one of the fastest MVC frameworks for PHP available. It's written in C and supplied as a compiled PHP extension, so it doesn’t need to be interpreted at every request. Consider PhalconPHP for your next project, you won't regret it.

20 minute readContinue Reading
EngineeringIcon ChevronMobile

Realm Is the Best Android Database Solution

by Mateus Gondim Romão Batista

Since the inception of the platform, Android developers have had pretty much only one option for a database: SQLite. Although feature-rich and powerful, it wasn’t quite what Android app developers needed. Realm, a modern, efficient database solution for mobile platforms, turned out to be an amazing replacement for SQLite on Android. In this article, Toptal Software Engineer Mateus Gondim Romão Batista explains why you should use Realm for your next Android application.

11 minute readContinue Reading
EngineeringIcon ChevronBack-end

The Definitive Guide to NoSQL Databases

by Mohammad Altarade

Limited SQL scalability has prompted the industry to develop and deploy a number of NoSQL database management systems, with a focus on performance, reliability, and consistency. The trend was driven by proprietary NoSQL databases developed by Google and Amazon. Eventually, open-source systems like MongoDB, Cassandra, and Hypertable brought NoSQL within reach of everyone. In this post, Senior Software Engineer Mohamad Altarade dives into some of them and explains why NoSQL will probably be with us for years to come.

15 minute readContinue Reading
EngineeringIcon ChevronBack-end

Guide To Budget-friendly Data Mining

by Jeffrey Shumaker

Although database programming does not evolve at nearly the same pace as traditional application programming, recent advancements in several fields are bringing new techniques and technologies within the reach of small and independent developers. In this guide, Toptal Freelance Software Engineer Jeffrey Shumaker explains how developers can quickly and easily tap these methods to identify database issues they may not even be aware of, and how they can build excellent data mining tools without spending a lot on expensive software licenses.

9 minute readContinue Reading
EngineeringIcon ChevronMobile

Simplifying RESTful API Use and Data Persistence on iOS with Mantle and Realm

by Marcin Kmiec

A large number of modern mobile applications interact with web services in one way or another, and iOS applications are no different. Mantle (a model framework) and Realm (a mobile database) come with the promise of simplifying some of the hurdles in consuming web services through RESTful APIs and persisting data locally. In this article, Toptal engineer Marcin Kmiec shows how to build a simple iOS application using Mantle and Realm and demonstrates how this approach helps to eliminate a large amount of boilerplate code.

13 minute readContinue Reading
EngineeringIcon ChevronData Science and Databases

MetaDapper: Data Mapping and Conversion Made Easy With the Right Tools

by Richard Rozsa

Data conversion, translation, and mapping is by no means rocket science, but it is by all means tedious. This article introduces MetaDapper, a .NET library that strives to simplify, streamline, and automate the data conversion process to the greatest extent possible.

10 minute readContinue Reading

Join the Toptal® community.