The eyes may be the window to the soul, but your face is the key for your phone. While facial recognition may have once been relegated to the world of science fiction, it is now our reality and plays such a common role in our everyday lives that few bother to think about the enormous technology and infrastructure behind it. For instance, Apple’s FaceID technology on their iPhone X utilizes their ‘TrueDepth’ camera system that projects over 30,000 dots onto a user in order to map the geography of the user’s face. But Apple isn’t the only company that employs facial recognition, Samsung and Facebook use it to unlock devices and tag people in photos. Our development team has always been fascinated with the concept of facial recognition and so they decided to tackle this once-mythical technology and put it to work for our customers.
Apple and Google are setting new ground rules for mobile applications on the App Store and Google Play. This year will see the releases of iOS 12 and Android 9.0. That’s why both mobile behemoths are streamlining their platforms to prepare for future devices. With these changes, companies and developers are going to have to update their mobile apps or face a ban from the two platforms. However, there’s no need to panic. This inevitable app upgrade brings an incredible opportunity to capture a wider audience and cement your position as leaders in your field.
As a technology company there is a stark truth that exists every day: not all tech is created equal. For us, there was no greater example of this than when we crafted a global mobile app that had to work in China. While China has continued its upwards trajectory over the past two decades, they have maintained an increasingly strong approach regarding internet access and technologies available to their citizenry. When our client approached us to build their global app, we knew that we would face a myriad of technological hurdles related to the Chinese government’s rules and regulations. Our goal was to deliver the same high standards that our clients expect from us regardless of limitations set by any government.
Have you ever missed a photo op because you were in a crowded place and random people wouldn’t get out of your way? Sometimes it can be almost impossible to take a clear photo in the real world. If you decide to try and wait for the people to clear out of busy areas, you might be standing there waiting forever! But, no more waiting, we have a much more time-effective solution! Watch the following video to learn more about the approach that we’ve used to remove unwanted objects from your cool photos.
How does it work?
Through our thorough research, we’ve discovered that we can attain crystal-clear still framed pictures from multiple, busy or crowded pictures. Just imagine if it were possible to take a number of pictures and then combine their best parts into one picture. Of course, doing this manually doesn’t make sense, but now with the latest Apple technologies, we can do it automatically. You won’t even need to edit your pictures in Photoshop!
All we need is a short video. Ten seconds or even five seconds will do. However, we’ll use only a certain number of frames from this video. Basically, 5 frames should do the trick, but you may opt for 7 or more frames to get an even crispier outcome. 🙂
We created a basic demo macOS application that leverages this algorithm to remove the unwanted moving objects from your pictures. This application uses generic Apple frameworks to deliver some amazing results. Basically, the application takes a short video to create a photo without any moving objects in it!
An online marketplace company managed a 6-terabyte database using an old version of Amazon RDS PostgreSQL version 9.3. With the gaining popularity of their platform, they needed a way to scale the performance and size of their database near term to 15-terabytes. They also had several performance issues including a daily batch script that was taking almost 2 hours to complete that was starting to exceed the maintenance window, and simple tasks like adding a new column to their largest table would time out. The main challenge for the migration project was that downtime could not exceed 6 hours and test efforts by their DBA team could never meet the requirement.
In this blog post, we will walk through two things:
- The various options for upgrading their PostgreSQL 9.3 server to 9.6
- The process of migrating them to Amazon Aurora from RDS
Please read on to see how we were able to complete the entire migration process in under 3 hours and take advantage of the performance of Amazon Aurora for PostgreSQL.
So, you want to upgrade your existing mobile application by adding some cool new features to it? Or do you want to build a new app from scratch, leveraging the most advanced features available on the market? Let us introduce an easily customizable video chat module, which we regularly use in various mobile applications. Watch the following video to learn how we can embed video chat directly into your mobile app quickly and easily.
Big thank you to everyone who attended our webinar on May 1, 2018 – Accelerate Database Migration to AWS with DB Best! Dmitry Balin and myself talked about how DB Best and Amazon Web Services (AWS) can help you improve performance and reduce costs by migrating your on-premises databases to managed Amazon Relational Database Service (Amazon RDS), to virtual machines using Amazon Elastic Compute Cloud (EC2), or database warehousing solutions such as Amazon Redshift. I also did a couple of demos to show how the AWS Schema Conversion Tool (AWS SCT) helps accelerate the database adoption process by converting the schema of your source databases to your choice of databases.
We had a great Q&A session at the end of the webinar, however as soon as the webinar ended, we all got cut off :(. For the attendees and anyone else interested in migrating your databases to AWS, we will be using Twitter to answer your questions. Just log into Twitter with your favorite Twitter handle and post a question using #AWSDBBestWebinar with our @dbbest_tech handle as a mention. For example:
#AWSDBBestWebinar @dbbest_tech What’s the best way to import 30 TB of data from my Oracle data warehouse to #Amazon #Redshift?
For those that missed the webinar, it should be live within the next few days on the AWS Partner Webinar Series on Migration site.
Be sure to check out some of the great resources that we have on our new website and blog as shown below.
Look forward to continuing the conversation on Twitter!
We’re happy to announce the latest release of Database Compare Suite 4.12. This new version brings several important improvements and bug fixes, including:
Continue reading to learn more about the ultimate DBA tool and discover all of the major improvements implemented in this latest application release. Read the rest of this entry »
The goal of DB Best blog is to deliver technical content on various completed projects and researches. Publishing over 100 blog posts per year, we pay great attention to the projects, related to the cloud data platforms in general, and Amazon Web Services (AWS) in particular. Some of the AWS customers’ stories attract more attention than others, so, that’s why we decided to collect them in one place. We consider these articles must-read and super useful.
Please take a look through our list of the most read customers’ stories on AWS.
Top 3 AWS customers’ stories
We’ve had an amazing experience, migrating on-premises Oracle database to the AWS cloud for a major data processing company. We delivered a cost and time-effective turnkey solution, adding automated monitoring and reporting capabilities to their existing solution.
Another brilliant example of reducing customer’s operational costs by moving their Oracle on-premises database into the AWS cloud. We created highly available and easily scalable database system, providing the customer with a set of best practices on operating the new cloud environment.
Our customer wanted to support additional database platform to their original Oracle database system. They wanted to expand their on-premises system with a new PostgreSQL database running at AWS RDS. We came up with a magnificent solution to unify the application’s SQL code. After unification, the application was running correctly against both databases. You can check the details of this sophisticated project in the following blog post.
Bonus track: application development with AWS
Check how we implemented a variety of Amazon Web Services to build a set of video streaming applications for one of our regular customers. Highlighting the unlimited power of web services, we will show you how to keep costs under control even under the extremely increasing workloads.
Be sure to check the related AWS DMS post. It uncovers the technical best practices on AWS cloud migrations and cloud database management.
Sharing our technical experience with the readers, we’ve reached a pretty impressive audience on our blog. So, it was pretty easy to distinguish the most popular AWS Database Migration Service (AWS DMS) Support stories. Let’s jump right in and review the most valuable and really important DB Best blog posts on AWS DMS and AWS Schema Conversion Tool (AWS SCT).
We’ve got an impressive series of blog posts, where we talk about the features of AWS Schema Conversion Tool, which is the must-use utility for moving workloads into the Amazon cloud. In addition to that, we talk about popular conversion issues, helping you overcome the action items, which occur during the migration process.
Let’s start with the Amazon Redshift Performance tuning tips. We’ve worked on this blog post for several months to tell you the real story of Redshift optimization project and describe the best practices we’ve learned.
Another massive experience was related to the AWS Snowball Edge appliance. We had a unique chance to use this cool device, which combines 80 TB of built-in storage and compute power to migrate our on-premises Oracle database to AWS Redshift.
Summing up the top 3 technology AWS blog posts, comes our research on taking advantage of AWS Glue ETL service to load the data into Amazon Redshift after migrating the Teradata data warehouse into the Amazon cloud.
The following blog posts show our immersive experience with AWS Schema Conversion Tool (SCT).
- General Approach to Migration of Data Warehouses to Amazon Redshift
- Specific Features of Migrating Data Warehouses to Redshift
- Migrating an Oracle to MySQL Database using the AWS Schema Conversion Tool
- Extracting Data from Warehouses with Data Migration Agents
- First look at AWS Schema Conversion Tool with tighter DMS integration
- AWS Schema Conversion Tool Offline mode
- Using AWS Schema Conversion Tool Extension Pack for OLTP databases