Come to Montreal for a free full-day event devoted to PostgreSQL extension development.
Apply to be a speaker (until April 1st), or register now: https://pgext.day/
cc @yrashk
Recherches récentes
Options de recherche
Administré par :
#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Ü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.
MariaDB - ROW_FORMAT einer Tabelle verändern --> https://blog.purelinux.de/blog/5-mariadb-row-format-fix/
---
MariaDB - changing the ROW_FORMAT of a table --> https://blog.purelinux.de/en/blog/5-mariadb-row-format-fix/
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: https://en.wikipedia.org/wiki/Local_regression#/media/File:Loess_curve.svg
More details: http://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
Anyone reading this who works with #Oracle? Trying to find a good way to replicate ORA-25402 and similar errors for testing. Any advice?
Pointers/ reposts appreciated.
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: https://pgext.day/
Call for Speakers is open until April 1st. https://sessionize.com/pgextday2025mtl
pgext.dayPostgres Extensions Day 2025
#Development #Guidelines
The moment you need a database · When static sites need dynamic solutions https://ilo.im/162qqz
_____
#Cost #Maintenance #Security #Database #Platform #CMS #Website #WebTechnology #WebDev #Backend
ilo.imThe Moment You Need a Database – Frontend Masters BlogThere are quite a few tools to avoid *needing* a database these days, static site generators chief among them. So then what are the things that push toward or require a database?
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.
Years ago I created a #php #mysql #comics #database
https://sourceforge.net/projects/madcollector/
DM me If you'd be interested in reviving it.
SourceForgeMadCollectorDownload MadCollector for free. Comics database with collaboratives tools for comics geeks ! Includes PDF collection export.
The program is the database is the interface — https://www.scattered-thoughts.net/writing/the-program-is-the-database-is-the-interface/
#HackerNews #The #program #is #the #database #is #the #interface #programming #database #interface #design #tech #innovation
www.scattered-thoughts.netThe program is the database is the interface
The dbcooper package turns a database connection into a collection of functions. https://github.com/dgrtwo/dbcooper #rstats #database
GitHubGitHub - pipeline-tools/dbcooper: Create user-friendly accessor functions from a database connectionCreate user-friendly accessor functions from a database connection - pipeline-tools/dbcooper
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: https://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: https://en.wikipedia.org/wiki/Multivariate_interpolation#/media/File:Comparison_of_1D_and_2D_interpolation.svg
Want to expand your knowledge of Statistics, Data Science, R, and Python? Subscribe to my newsletter for more insights! Link: http://eepurl.com/gH6myT
Suite du fil
Remember this from @andy_pavlo?
https://www.cs.cmu.edu/~pavlo/blog/2025/01/2024-databases-retrospective.html
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: https://data-bene.io/en/
How hackers dump databases on vulnerable systems https://chat-to.dev/post?id=bUF5SHlkd1YrQk9palFES0d5eHRVdz09&redirect=/new #database #sql #programming #software #coding
#Development #Guides
Bloom filter · What they are and why they are so powerful https://ilo.im/162mpl
_____
#Programming #Coding #BloomFilter #HashTable #DataStructure #JavaScript #Database #WebDev #Frontend #Backend
kirupa.comBloom Filter: A Deep DiveLearn how to quickly check if a value exists in a ridiculously large collection of data by using the world's favorite little probabilistic data structure, the Bloom filter.
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? 