article thumbnail

Data News — Week 24.08

Christophe Blefari

JVM vs. SQL data engineer — There's a big discussion in the community about what real data engineering is. Is it DataFrames or SQL? Still, I prefer SQL/Python data engineering, as you know me. Neurelo raises $5m seed to provide HTTP APIs on top of databases (PostgreSQL, MongoDB and MySQL).

Data Lake 130
article thumbnail

Five Ways to Run Analytics on MongoDB – Their Pros and Cons

Rockset

MongoDB is a top database choice for application development. MongoDB wasn’t originally developed with an eye on high performance for analytics. Developers have formed ingenious solutions for real-time analytical queries on data stored in MongoDB, using in-house solutions or third-party products.

MongoDB 52
Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

article thumbnail

Methods for Running SQL on JSON in PostgreSQL, MySQL and Other Relational Databases

Rockset

Consider the hoops we have to jump through when working with semi-structured data, like JSON, in relational databases such as PostgreSQL and MySQL. JSON is a good match for document databases, such as MongoDB. This feature is available in some relational database systems— PostgreSQL and MySQL support columns of JSON type.

article thumbnail

Planet Scale SQL For The New Generation Of Applications With YugabyteDB

Data Engineering Podcast

Your host is Tobias Macey and today I’m interviewing Karthik Ranganathan about YugabyteDB, the open source, high-performance distributed SQL database for global, internet-scale apps. In terms of the query API you have support for a Postgres compatible SQL dialect as well as a Cassandra based syntax.

SQL 100
article thumbnail

Top Database Project Ideas to Work on 2023 [with Source Code]

Knowledge Hut

Some of the most important lists of database project examples using MySQL are: Online Job Portal using Python and SQL database An online job portal is a platform that connects job seekers with potential employers. Here is a link to source codes for Online Job Portal using Python and SQL databases.

article thumbnail

TimescaleDB: The Timeseries Database Built For SQL And Scale - Episode 65

Data Engineering Podcast

How have the improvements and new features in the recent releases of PostgreSQL impacted the Timescale product? How have the improvements and new features in the recent releases of PostgreSQL impacted the Timescale product? Have you been able to leverage some of the native improvements to simplify your implementation?

Database 100
article thumbnail

What Is Full Stack Web Development? A Complete 2024 Guide

Edureka

Backend developers use database management systems such as MySQL, PostgreSQL, MongoDB, and Redis to securely and efficiently store and manage data. Security: Implementing security measures to prevent common threats and vulnerabilities like SQL injection, cross-site scripting (XSS), and cross-site request forgery (CSRF).

MongoDB 40