#database

[ follow ]
#cloud-computing

DuckDB and Python: Ducks and Snakes living together

DuckDB simplifies data workflows in Python through efficient in-process architecture and strong integration capabilities.

Amazon Aurora DSQL: Distributed SQL Database with Active-Active High Availability

Amazon Aurora DSQL is a groundbreaking serverless SQL database that supports active-active availability and promises superior scalability and reliability for cloud applications.

DuckDB and Python: Ducks and Snakes living together

DuckDB simplifies data workflows in Python through efficient in-process architecture and strong integration capabilities.

Amazon Aurora DSQL: Distributed SQL Database with Active-Active High Availability

Amazon Aurora DSQL is a groundbreaking serverless SQL database that supports active-active availability and promises superior scalability and reliability for cloud applications.
morecloud-computing
#php

Trying to display all records for a specific customer

To fetch all records for a customer, replace 'fetch' with 'fetchAll' in the PHP code.

PHP For loop with differents IDs

Use fetch_assoc() to iterate through the rows and access IDs directly.

Creating a typeahead/autocomplete/autosuggest input field

PHP can be used to implement an auto-suggest input field for accurate name entry.

Trying to display all records for a specific customer

To fetch all records for a customer, replace 'fetch' with 'fetchAll' in the PHP code.

PHP For loop with differents IDs

Use fetch_assoc() to iterate through the rows and access IDs directly.

Creating a typeahead/autocomplete/autosuggest input field

PHP can be used to implement an auto-suggest input field for accurate name entry.
morephp
#performance

PostgreSQL 17 delivers a leap forward for open-source databases

PostgreSQL 17 introduces major performance improvements and new features, enhancing both scalability and developer experience in database management.

Dataflow-based Query Caching with Readyset

Readyset utilizes partially-stateful streaming dataflow to create an efficient database cache that simplifies caching integration and maintains performance.

GitHub Upgrades its MySQL Infrastructure from v5.7 to 8.0

GitHub upgraded its MySQL infrastructure from version 5.7 to 8.0 to leverage the latest security patches, bug fixes, and performance enhancements.
The upgrade involved careful preparation, rolling replica upgrades, updating replication topology, and a thorough cleanup phase.

PostgreSQL 17 delivers a leap forward for open-source databases

PostgreSQL 17 introduces major performance improvements and new features, enhancing both scalability and developer experience in database management.

Dataflow-based Query Caching with Readyset

Readyset utilizes partially-stateful streaming dataflow to create an efficient database cache that simplifies caching integration and maintains performance.

GitHub Upgrades its MySQL Infrastructure from v5.7 to 8.0

GitHub upgraded its MySQL infrastructure from version 5.7 to 8.0 to leverage the latest security patches, bug fixes, and performance enhancements.
The upgrade involved careful preparation, rolling replica upgrades, updating replication topology, and a thorough cleanup phase.
moreperformance

How to Use Google Sheets as a Database (With Templates)

Google Sheets can function as a database tool with proper usage of its features like the QUERY function.
#javascript

Using the built-in SQLite module in Node js - LogRocket Blog

Node.js v22.5.0 features a native SQLite module, enhancing database management capabilities in an experimental state.

Insert problem in my db

Check the definition and existence of user.primaryEmailAdress.emailAdress in the database.
Verify the database connection and query execution for errors.

Using the built-in SQLite module in Node js - LogRocket Blog

Node.js v22.5.0 features a native SQLite module, enhancing database management capabilities in an experimental state.

Insert problem in my db

Check the definition and existence of user.primaryEmailAdress.emailAdress in the database.
Verify the database connection and query execution for errors.
morejavascript

Pokemon fans steady yourselves, but this site has collected EVERY card ever made

The Art of Pokemon Cards is an extensive database detailing all 23,000 Japanese Pokémon cards, created by a dedicated fan.

.NET vector data abstractions library now available in preview

Microsoft's new library aids .NET developers in integrating vector stores efficiently.

Hanami 2.2.0.rc1 released

Hanami 2.2.0 RC1 introduces advanced features and prepares for the upcoming final release.

Best software for basic dynamic website

Focus on using frameworks like React or Vue.js for the front end and ORM tools for database interactions.

Indexing a dataframe ahead of seeding to database

The original method for creating shop_id in treasures could lead to integrity issues with non-unique shop names.
Creating shop_ids by querying the database ensures accuracy in foreign key relationships.

MongoDB hits back at business critical doubts

MongoDB 8.0 defends its use in business-critical systems through improved performance and cost efficiency, especially in sharding.
#open-source

Concerns Rise in Open-Source Community as CockroachDB Ends Core Free Edition

CockroachDB has discontinued the free Core version, now offering only the Enterprise version, prompting concerns about the sustainability of open-source solutions.

Redis users considering alternatives after licensing move

Around 70% of Redis users are exploring alternatives after a licensing change to less permissive terms.
The emergence of Valkey highlights the shift in user sentiment towards more permissive licensing.

CockroachDB scuttles away from open source Core offering

CockroachDB is retiring its free Core product in favor of a new Enterprise licensing structure, while remaining source code available for innovation.

Concerns Rise in Open-Source Community as CockroachDB Ends Core Free Edition

CockroachDB has discontinued the free Core version, now offering only the Enterprise version, prompting concerns about the sustainability of open-source solutions.

Redis users considering alternatives after licensing move

Around 70% of Redis users are exploring alternatives after a licensing change to less permissive terms.
The emergence of Valkey highlights the shift in user sentiment towards more permissive licensing.

CockroachDB scuttles away from open source Core offering

CockroachDB is retiring its free Core product in favor of a new Enterprise licensing structure, while remaining source code available for innovation.
moreopen-source

Master Project Management with Airtable

Airtable offers versatile project management with free and paid plans.
It provides customizable project management bases tailored to user needs.
Automation features enhance workflow and efficiency while reducing errors.
from The New Yorker
3 months ago

The Failures of the Military-Justice System

The military justice system rarely punishes perpetrators of possible American war crimes, as revealed by a comprehensive new database.

ServiceNow moves its backend off MariaDB to Postgres

ServiceNow is transitioning to RaptorDB, enhancing performance and scalability in its applications, catering to growing customer data needs.
#ai

From Open Source Success to Empowering Startups and Corporations Worldwide, MindsDB is Revolutionizing AI Accessibility

MindsDB is an AI virtual database for creating AI-centered applications
MindsDB recently received investment from NVentures to further advance its mission

Cassandra 5.0 promises better search after indexing redesign

Cassandra 5.0 enhances performance and flexibility for AI applications with new features like Storage Attached Indexes and Vector Search.

From Open Source Success to Empowering Startups and Corporations Worldwide, MindsDB is Revolutionizing AI Accessibility

MindsDB is an AI virtual database for creating AI-centered applications
MindsDB recently received investment from NVentures to further advance its mission

Cassandra 5.0 promises better search after indexing redesign

Cassandra 5.0 enhances performance and flexibility for AI applications with new features like Storage Attached Indexes and Vector Search.
moreai

How I Created My Own Telegram Bot - Pt. 3 Final | HackerNoon

Created a new database solution to overcome Telegram API limitations in data storage.

SQL Aggregate Functions: Explore 5 Types of Functions

Aggregate functions in SQL compute multiple values to return a single value, crucial for data analysis.

MIT just launched a new database tracking the biggest AI risks

MIT researchers have developed a comprehensive AI Risk Repository to address overlooked risks in AI adoption frameworks.

sphinxcontrib-sqltable 2.1.0 - SQLAlchemy 2.0 support

Sphinxcontrib-sqltable 2.1.0 update includes support for SQLAlchemy 2.0 and packaging changes to pyproject.toml.

Scores of European decision-makers on Russia's wanted list DW 02/14/2024

Russia has an official database of individuals suspected of evading justice, which can be found on the Interior Ministry website.
The database includes the names of hundreds of non-Russian nationals, including Ukrainian soldiers, politicians, and civil servants from Estonia, Lithuania, Latvia, Poland, and Ukraine.

CockroachDB tempts legacy databases to crawl to the cloud

CockroachDB has released version 23.2 with new features aimed at attracting mainframe and legacy database users.
The update includes improved support for stored procedures, making them more powerful and suitable for enterprise workloads.
CockroachDB aims to provide better compatibility with PostgreSQL and is wire-compatible; it also uses a distributed execution engine for processing large amounts of data in parallel.

Solid Queue & understanding UPDATE SKIP LOCKED

Takeaway 1: Solid Queue is an open-source software developed by 37signals.
Takeaway 2: UPDATE SKIP LOCKED is a feature in databases that allows for efficient concurrency control.

Opinion | AI Won't Learn to Think. It'll Be Taught to Lie

Artificial Intelligence is simply the processing of 1s and 0s
The danger of AI is that it can be taught to lie

CTOs' frustration with GenAI? Tool changes that break stuff

DataStax focuses on aiding GenAI app development with new tooling and partnerships in the database market.
[ Load more ]