Daffodil Software Saves Hundreds of Hours Managing Databases with Google Cloud SQL
Of your peers have already read this article.
The most insightful time you'll spend today!
Daffodil Software was able to build and deploy apps quickly and save hours of management with Google’s easy-to-use database management service—something it couldn’t do as easily with AWS.
Daffodil Software is an India-based
information technology services company with 180 employees and satellite
offices in the US, Singapore, and the United Arab Emirates.
Its product: A suite of web-based
applications, including a business customer relationship management (CRM)
program and an enterprise resource planning (ERP) app for schools.
Daffodil needed a cloud-based hosting platform for its applications that would save money and time over in-house hosting. The company tried Amazon Elastic Cloud Compute (EC2) with MySQL to manage the databases that its applications depended on. The potential was there, but building, testing and deploying the applications took too long, and scalability was also an issue.
“The old system provided the option to scale up if many users accessed our applications at the same time, but we had to do this manually,” says Gaurav Sharma, assistant head of Daffodil’s product team.
Soon, Daffodil switched to Google App
Engine, which allows businesses to build and host web apps on the same
infrastructure that powers Google applications.
Integration with App Engine lets Sharma and
his team quickly build, test and deploy applications and allows them to
automatically accommodate fluctuations in the number of users so they don’t
have to manually manage the system when demand increases.
Although App Engine’s built-in Datastore was useful, they found that they wanted more SQL-like functionality for their data-driven programs.
At Google’s suggestion, Daffodil migrated to Cloud SQL three months later to take advantage of the system’s database indexing and dynamic filtering abilities, which speed up data sorting for Daffodil’s end users.
Besides indexing and dynamic filtering,
Cloud SQL has simplified database management for the Daffodil team. Sharma can
easily import their databases and administer them through an intuitive interface,
while Google handles backend maintenance and administration.
Google Cloud SQL replicates data among
multiple geographic regions, giving Daffodil CEO Yogesh Agarwal peace of mind
that users’ data held by the applications is protected.
“The safety of our customers’ data is a
major concern, so we appreciate that we don’t need to worry about data loss,”
With App Engine and Cloud SQL, the Daffodil team is saving about 80 hours of development time every month because of easier deployment, no active management for scaling, and simplified database management. They have also slashed the time it takes to bring new products to market.
“Using Google App Engine and Google Cloud
SQL make our applications go live in half the time and have provided us with
hassle-free control over all processes, such as development, deployment and
monitoring,” Agarwal says. “We’re able to deploy our applications much faster
and spend less time managing them.”
Going forward, the Daffodil team plans to add other Google services to their applications, including Prediction API, which allows CRM application users to better predict the probability of a lead becoming a customer, and App Engine’s Full Text Search API, which helps users retrieve customer data more easily.
Agarwal is happy with the move to App Engine and Cloud SQL. “The shift has allowed us to focus on making our applications even better,” he says.
In the United Kingdom, the popularity of online grocery shopping is expected to surge from about 6% of the market today to 9% by 2021, according to market research firm Mintel. One of the pioneers of online-only grocery retailing is Ocado, based in Hatfield, Hertfordshire in the U.K. Since starting commercial deliveries
As more enterprises migrate a growing number of workloads to the cloud, migrating databases, too, has become a key focus. But migrating databases is also really tough. This is due to a number of different reasons. The first one is that there's a lot of proprietary technology and functionality that's
Enterprise data warehouses are getting more expensive to maintain. Traditional data warehouses are hard to scale and often involve lots of data silos. Business teams need data insights quickly, but technology teams have to grapple with managing and providing that data using old tools that aren’t keeping up with demand.
At Precognitive, we were able to start with a blank technology slate to support our fraud detection software products. When we started building the initial version of our platform in 2017, we had some decisions to make: What coding language to use? What cloud infrastructure provider to choose? What database
SHOW MORE STORIES