engineering - The Locale.ai Blog

Monitoring and Optimizing Slow Database Queries: A Proactive Approach with Locale

Facing heavy database loads, we transformed our approach at Locale. This post explores our journey from frequent CPU spikes to proactive database query optimization, leveraging Locale's alerting system and SQL efficiency to prevent downtime and enhancing customer reliability

engineering

How to run SQL queries using cron

Different ways of running SQL queries as a cron-job to get actionable data from database at regular intervals.

engineering

We were all using Airflow wrong... And now, it's fixed!

This blog talks about easily turning your existing automation scripts into Airflow tasks using the relatively new Kubernetes Pod Operator.

engineering

How We Scaled Locale.ai to Crunch Billions of Rows under a Second

A leaf out of our playbook for engineering teams that are looking to scale up their analytics stack with ClickHouse

engineering

[Tech] How to Merge Consecutive Rows in SQL?

A tutorial explaining where you might need to merge consecutive rows in SQL and how to do it

case study

Tackling Business Decisions in Mobility through Advanced Geo-Analytics

Enrique Camacho from OMNi talks about the role advanced analytics plays in the mobility industry and how a collaboration with Locale.ai helped OMNi leverage it to sharpen their business decisions.

engineering

Why Sidu Ponnappa Invested in Locale.ai

Sidu Ponnappa, SVP Engineering- Internal Products at Gojek, talks about his Investment in Location Analytics Startup Locale.ai

inside locale

Why you need both Al Pacino and his consigliere in your engineering team

Locale.ai is hiring senior engineers who can scale & augment our already strong engineering team

inside locale

How Locale.ai's Application Process is a Class Apart

An Engineer's musings on his journey to Locale, the application process and his first few weeks at the company.

engineering

[Tech] Measuring Fleet Utilization & Idle time Using Location Analytics

Learn how to use location analytics, to analyse fleet data and measure various metrics from it in real time, improving operational efficiency.

engineering

Large Scale Geospatial Visualization with Deck.gl, Mapbox-gl and Vue.js

Deck.gl is Uber's open source library for large scale visualisations, let's see how we can use it along with Vue.js to build beutiful visualizations.

engineering

From Thoughts to Visuals —How we designed our geospatial analytics product

How do we apply “design thinking” to bring our ideas to life at locale.ai?

engineering

Architecting HTTP clients in Vue.js applications for efficient network communication

For handling all the edge cases in communicating with external APIs.

inside locale

10 ways in which we’re building a tech & design first culture at Locale.ai!

Because the smartest engineers and designers need the right aura to solve the hardest problems. And they can’t wait!

engineering

Architecting Vuex store for large scale Vue.js applications

Best practices and tips to architect state management on a large scale Vue.js application

Subscribe to The Locale.ai Blog