ludosphere.fr est l'un des nombreux serveurs Mastodon indépendants que vous pouvez utiliser pour participer au fédiverse.
Communauté ludique (jeux vidéo, de rôle, de société, etc) destinée aux joueuses et joueurs francophones de tous horizons. French speaking people only.

Administré par :

Statistiques du serveur :

386
comptes actifs

#database

31 messages11 participants0 message aujourd’hui

I can't really complain about the functionality of my brain synapses. It's just that with languages, they don't work the way I want them to. This also applies to programming languages – unfortunately.

My upcoming project requires data output. Of course, I'm familiar with the combination of #PHP and #MySQL, without being able to create both of them. I'm concerned about the how, since I won't be using any of the common monsters (WordPress, Drupal, etc.). I've heard of #frameworks and read various things about them, but – this is where it gets embarrassing – I just don't understand how to use them. However, I have a feeling they can help me [1]. Does anyone have any ideas how I can overcome my lack of understanding? #Linux #Programming #Database #json

[1] For example, the recently discovered #Flight

docs.flightphp.com/de/v3/

docs.flightphp.comÜber - Flight - An extensible micro-framework for PHPFlight is a fast, simple, extensible framework for PHP. Flight enables you to quickly and easily build RESTful web applications.

Local regression is a non-parametric method for fitting smooth curves to data by applying multiple localized regressions. It is useful for uncovering non-linear relationships when the data’s exact form is unknown. Proper use of local regression can reveal trends in noisy data, but poor implementation might lead to misleading results.

Image: en.wikipedia.org/wiki/Local_re

More details: eepurl.com/gH6myT

Phew! I need to figure out a way to get data from a Raspberry Pi into a database on a server over an unreliable network.
The data is not a stream, but there is a new data point being generated every 5 minutes.
I'm thinking I need something like a local queue on the Pi, and once Internet is there, the elements from the queue need to be transferred, one by one, then added into the database.
Rabbit hole, here I come!
#BuildInPublic #Internet #database #queue

New #PostgreSQL event announcement - Postgres Extensions Day 2025 in Montreal is "a full day dedicated to extensions – their development, lifecycle, and so on. A perfect event for extension developers and heavy extension users."

It's a free event and you can register now: pgext.day/

Call for Speakers is open until April 1st. sessionize.com/pgextday2025mtl

pgext.dayPostgres Extensions Day 2025
#postgres#tech#techevent

🚀 FREE SQL & PL/SQL Workshop - Learn Cursors in Oracle! 🚀

👨‍💻 Want to boost your SQL & PL/SQL expertise? Join this FREE workshop led by Mr. Shiva Chaitanya and learn how to handle Cursors in Oracle efficiently.

✅ What You’ll Gain:

Practical hands-on experience with SQL & PL/SQL
Best practices for using Cursors in database management
Expert mentorship to enhance your learning
📢 Limited spots available! Secure yours today.

#SQL#PLSQL#Oracle

The Django MongoDB Backend is evolving, and now’s a great time to try it out. You can configure your database connection, model your data, and interact with MongoDB like never before.
Just remember, it’s still in Public Preview and not ready for production yet, so there might be some breaking changes.
Explore the documentation and see what’s in store here: fnf.dev/4h1CNbk
Thank you to @MongoDB for supporting our community
#Django #MongoDB #Python #WebDev #Backend #PublicPreview #Database

fnf.devDjango MongoDB Backend - Django MongoDB Backend v5.1 - MongoDB Docs

Multivariate interpolation estimates unknown values based on multiple variables, making it useful in physics, finance, and machine learning. It allows for smoother approximations and more accurate predictions in multidimensional spaces.

Visualization: en.wikipedia.org/wiki/Multivar

Want to expand your knowledge of Statistics, Data Science, R, and Python? Subscribe to my newsletter for more insights! Link: eepurl.com/gH6myT

Suite du fil

Remember this from @andy_pavlo?

cs.cmu.edu/~pavlo/blog/2025/01

He points out:

> We also found that the DBMS's lack of guard rails means that extensions can interfere with each other and cause incorrect behavior.

It can be challenging to set up #PostgreSQL with to ensure you're making the most of your #database deployment.

Questioning if you need to optimize for #performance, high availability, disaster recovery, or other scenarios?

Get in touch: data-bene.io/en/

Talk me out of building a #Neo4j implementation in parallel to my existing #PostgreSQL DB (with a subset of tables as nodes) for queries that tend to be "graph-like" in nature.

In particular, I'm thinking of failure analysis, predictive maintenance, etc in relation to physical infrastructure I model as a directed acyclic graph.

Is this just my #ADHD wanting to try something new, or could I actually find value in this side-quest? 😬