Database

Showing 19-27 of 27 results
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 ChevronBack-end

MySQL Master-Slave Replication on the Same Machine

by Ivan Bojovic

Developers often work on only one machine, and have their whole development environment on that machine. Testing database replication before deploying changes in this kind of a development environment can be a challenging task. In this article, Toptal engineer Ivan Bojovic guides us through a step-by-step tutorial on how to implement MySQL master-slave replication on one machine.

8 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 ChevronBack-end

After All These Years, the World is Still Powered by C Programming

by Daniel Munoz

Despite the prevalence of higher-level languages, the C programming language continues to empower the world. There are plenty of reasons to believe that C programming will remain active for a long time. Here are some reasons that C is unbeatable, and almost mandatory, for certain applications.

12 minute readContinue Reading
EngineeringIcon ChevronData Science and Databases

How to Tune Microsoft SQL Server for Performance

by Sripal Reddy Vindyala

To retain its users, any application or website must run fast. For mission critical environments, a couple of milliseconds delay in getting information might create big problems. As database sizes grow day by day, we need to fetch data as fast as possible, and write the data back into the database as fast as possible. To make sure all operations are executing smoothly, we have to tune Microsoft SQL Server for performance.

10 minute readContinue Reading
EngineeringIcon ChevronData Science and Databases

Meet Bond, Microsoft Bond - A New Data Serialization Framework

by Andrei Smirnov

Microsoft Bond is a modern data serialization framework. It provides powerful DSL and flexible protocols, code generators for C++ and C#, efficient protocol implementations for Windows, Linux, and Mac OS X. This article is a quick guide of the features and use of this framework.

6 minute readContinue Reading
EngineeringIcon ChevronData Science and Databases

Business Intelligence Platform: Tutorial Using MongoDB Aggregation Pipeline

by Avinash Kaza

In today’s data-driven world, researchers are busy answering interesting questions by churning through huge volumes of data. Some obvious challenges they face are due to the sheer size of the dataset they have to deal with. In this article, we take a peek at a simple business intelligence platform implemented on top of the MongoDB Aggregation Pipeline.

7 minute readContinue Reading
EngineeringIcon ChevronBack-end

Full Text Search of Dialogues with Apache Lucene: A Tutorial

by Doug Sparling

Apache Lucene is a powerful Java library used for implementing full-text search on a corpus of text. With its wide array of configuration options and customizability, it is possible to tune Apache Lucene specifically to the corpus at hand - improving both search quality and query capability. This article gives us a glimpse of the simplicity and ease of customization of the Apache Lucene analysis pipeline.

15 minute readContinue Reading
EngineeringIcon ChevronData Science and Databases

Blockchain Technology Explained: Powering Bitcoin

by Nermin Hajdarbegovic

Bitcoin blockchain is the backbone of the network and provides a tamper-proof data structure, providing a shared public ledger open to all. This article provides insight in blockchain technology, current status and its potential.

6 minute readContinue Reading

Join the Toptal® community.