#database
Worried about data loss during node failure?🙇
New CrateDB Cloud alerts minimize the risk by ensuring you have enough replicas configured 🔔 ☁️
Experience it yourself, deploy your FREE tier cluster now ➡️ https://hubs.ly/Q01S30rw0
#cratedb #cratedbcloud #cloud #database #db #newfeature #newrelease #alerts
ClickHouse: A Blazingly Fast DBMS with Full SQL Join Support - Part 1
📢Japanese and #ResearchLuxembourg researchers have joined forces to make a major discovery: detecting markers of neurodegenerative diseases from a simple blood test.
🧠For the first time, they have demonstrated that pathological forms of the α-synuclein protein found in patients' blood can help diagnose Parkinson's disease.
🔎This major discovery was made possible, among other factors, thanks to #Luxembourg's remarkable Parkinson's disease #database
Using ClickHouse to Serve Real-Time Queries on Top of BigQuery Data
https://clickhouse.com/blog/clickhouse-bigquery-migrating-data-for-realtime-queries
Five Methods For Database Obfuscation
https://clickhouse.com/blog/five-methods-of-database-obfuscation
Today's #CitusCon video 📺 of the day is from the amazing PostgreSQL hacker (on the team at Microsoft) Melanie Plageman.
In this talk, you'll learn about IO observability & the new pg_stat_io feature for Postgres that Melanie contributed to PG16.
Melanie is a great explainer, trust me you'll like this talk!
https://aka.ms/cituscon-melaniep-2023
#PostgreSQL #Postgres #CitusCon #observability #Microsoft #OpenSource #database
Woah. Legit interested to see where this goes! #mongodb #ferretdb #opensource #database
https://blog.ferretdb.io/ferretdb-1-0-ga-opensource-mongodb-alternative/
New – AWS DMS Serverless 👉 Automatically Provisions and Scales Capacity for Migration and Data Replication – Nice post by @donnieprakoso https://aws.amazon.com/blogs/aws/new-aws-dms-serverless-automatically-provisions-and-scales-capacity-for-migration-and-data-replication/ #AWS #Database #Migration #Serverless
Issue 272 On the DVD: The July issue is available now! The print edition includes @fedora Workstation 38 and @xubuntu 23.04. Buy direct from us to get the best price and get it faster! https://www.sparkhaus-shop.com/magazines/linux-magazine.html #Linux #OpenData #CKAN #ODI #CommandLine #backup #database #OpenSource
ClickHouse welcomes Metabase Cloud GA integration
https://clickhouse.com/blog/metabase-clickhouse-plugin-ga-release
This video from @tigerbeetledb is a wonderfully revealing survey of fault models in a #database, and how their design solves for these from grounds up.
Aligns strongly with my belief that the future of databases is full-stack, bypassing the kernel.
And so many lessons to be had from their fully deterministic approach to #distributed #systems design.
We are hiring!
We are looking for a senior computer scientist or junior with good practical experience.
It's about #data, #knowledgegraph, #database and computer #network .
More info at https://ontopic.ai/en/jobs/2023-01-sd/
A Story of Open-source GitHub Activity using ClickHouse + Grafana
https://clickhouse.com/blog/introduction-to-clickhouse-and-grafana-webinar
Bringing observability to the modern data stack
Check it out! 👇
https://www.infoworld.com/article/3697650/bringing-observability-to-the-modern-data-stack.html#tk.rss_all
Bringing observability to the modern data stack - You can’t manage what you can’t measure. Just as software engineers need a comprehensi... - https://www.infoworld.com/article/3697650/bringing-observability-to-the-modern-data-stack.html#tk.rss_all #datamanagement #datagovernance #analytics #database
MariaDB & IONOS: Improving performance for hosting: https://mariadb.org/mariadb-ionos-improving-performance-for-hosting/ #mariadb #opensource #database #hosting
The latest version of PostgreSQL is available for testing https://www.admin-magazine.com/News/PostgreSQL-16-Beta-Now-Available #PostgreSQL16 #beta #security #testing #monitoring #OpenSource #database
Make Use Of: Working With SQL Databases in Rust https://www.makeuseof.com/working-with-sql-databases-in-rust/ #Tech #MakeUseOf #TechNews #IT via @morganeogerbc #CodingTutorials #Programming #Database #SQL
Introducing the ClickHouse Query Cache
https://clickhouse.com/blog/introduction-to-the-clickhouse-query-cache-and-design
The #dbaday 2023 is approaching. Get ready to say thank you to your #dba for keeping your data safe and sound.
#thankyou #data
#database #administrators #appreciation #day 2023 will happen the 7th July 2023.
@databricks today announced a partnership with #database virtualization player @datometry to facilitate easy transitions from legacy data warehouses to Databricks' #data #lakehouse platform.
https://venturebeat.com/data-infrastructure/databricks-accelerates-migration-data-lakehouse-new-technology-partner/
Dew Drop – May 30, 2023 (#3953)
Top links today:
- Scott Hanselman & Mark Russinovich Learn to Code
- Angular 16 unveiled: Discover the top 7 features
- Technology & Friends - Mark Downie on DasBlog
- 9 announcements from Microsoft Build 2023 and their implications for the future
- The prickly case of JavaScript proxies
https://www.alvinashcraft.com/2023/05/30/dew-drop-may-30-2023-3953/
#dotnet #ai #webdev #cloud #windowsdev #csharp #mobiledev #visualstudio #database #dewdrop
Just published Kitten’s¹ new database² commands:
- kitten db [table name] to see info the database/a specific table
- kitten db delete [table name] to delete the database/a specific table
- kitten db tail <table name> to follow a specific table
Full docs: https://codeberg.org/kitten/app#database-commands
¹ https://codeberg.org/kitten/app
² https://codeberg.org/small-tech/jsdb
#Kitten #SmallWeb #SmallTech #JavaScriptDatabase #javascript #database #JSDB #web #dev #js #NodeJS #commandLineInterface #CLI
Intel's Steve Shaw speaks to MariaDB Foundation's Kaj Arnö on the value of sponsoring the MariaDB Foundation. https://mariadb.org/the-value-of-sponsoring/ #mariadb #database #intel
Using Aggregate Combinators in ClickHouse
https://clickhouse.com/blog/aggregate-functions-combinators-in-clickhouse-for-arrays-maps-and-states
Still love the struggling client who explained they picked their #NoSQL database because they misread the documentation.
Our company still goes into clients who are considering #NoSQL and it turns out it's because they don't know how to use a #database. Denormalized, no foreign keys, 20 indexes on a table that needs one, and so on. So they decide to trade a known set of problems for an unknown set of problems. It often ends poorly.
PS: we can fix this for you.
Sauron says to Dumbledore and Merlin… MariaDB's Sergei Golubchik epics up a lame cross-genre math problem: https://mariadb.org/sauron-says-to-dumbledore-and-merlin/ #mariadb #database
Analyzing AWS Flow Logs using ClickHouse
https://clickhouse.com/blog/analyzing-aws-fow-logs-using-clickhouse
Connect SE JDBC table type: Accessing Tables From Another DBMS: https://mariadb.org/connect-se-jdbc-table-type-accessing-tables-from-another-dbms/ #mariadb #database
After years of strange problems and bad performance with MongoDB, this week I successfully migrated chesscraft.ca to PostgreSQL. This took lots of preparations, went smoothly, and is performing great, so I thought I'd write about it.
Introducing Inverted Indices in ClickHouse
https://clickhouse.com/blog/clickhouse-search-with-inverted-indices
Regarding your personal computer, or online equivalent:
The need to organize files into folders, so you can find them, indicates that you lack a sufficiently powerful and easy to use search engine
#PC #Wintel #Mac #FolderTree #files #folders #computers #Data #Database
ClickHouse and dbt - A Gift from the Community
https://clickhouse.com/blog/clickhouse-dbt-project-introduction-and-webinar
Major #ocean #database that will guide #deep-sea #mining has flaws, #scientists warn
As sea-bed mining looms, researchers say better records of #sea-floor #biodiversity are needed to assess its #environmental impact.
Sitting at the hotel bar in Paris, sipping some red wine and adding a new database command to the Kitten¹ command-line interface.
You can now tail JavaScript Database (JSDB)² tables with:
kitten db <table name>
(Remember that JSDB writes its tables as append-only JavaScript logs.)
¹ https://codeberg.org/kitten/app
² https://codeberg.org/small-tech/jsdb
Are you very knowledgeable on #PostgreSQL and open to working in #Riyadh, #SaudiArabia with a large financial services customer? #EDB is looking for a Senior #Postgres #Consultant / Resident Engineer (full-time #onsite). Please feel free to ping me for details!
#Saudi #postgres #work #job #jobs #jobsearch #joboffer #opensource #database #databases
Interesting case study 👉 How Deliveroo migrated their Dispatcher service to Amazon DynamoDB https://aws.amazon.com/blogs/database/how-deliveroo-migrated-their-dispatcher-service-to-amazon-dynamodb/ #AWS #Database #NoSQL
MariaDB is part of Google Summer of Code 2023: https://mariadb.org/mariadb-is-part-of-google-summer-of-code-2023/ #mariadb #gsoc #googlesummerofcode #database
I've been working on a project to load data into a #database and started from scratch with the #SQLAlchemy ORM. I'm super impressed at how easy it was to set up. To be fair, it's a simple set of tables, but it makes me want to go back to older projects I coded up with custom classes/manual SQL 🤣
Is it important for a Senior #WebDeveloper to be able to craft a form that writes to a #database without resorting to #browser client #JavaScript?
#webDev #web #programming #html #js #software #engineering #frontEnd
Going to formally follow some accounts with my homegrown #fediverse app this week!
Been focused on building out the #database / blob storage properly, capturing and authenticating #activitypub messages I receive and updating my homegrown #python #framework (I'm referring to as #Jenkwerx)
I'm FINALLY at a point we're I am allowing myself to formally log in, which means I can automate activities instead of faking them
Really excited to build out some fedi ideas for my online #game and beyond!
The MariaDB Health Checks for Wordpress plugin is now in the official WordPress plugin repository, and is still being improved: https://mariadb.org/mariadb-health-checks-in-wordpress/ #mariadb #wordpress #PHP #database
Blockchain vs. database: Similarities, differences explained
Reno property blockchain: City of Reno announced a big blockchain project. Here it is, a table of 21 historic places.
https://reno.stagingnet.blockapps.net/historicPropertys
#blockchain #property #database #crypto #ledger #record #scam #reno #-
Right, implemented workaround for JavaScript’s Proxy / Date object incompatibility in JavaScript Database (JSDB)¹ and released in version 3.0.2².
Calling methods on persisted Date objects read back into memory now works as it should.
Workaround (diff): https://codeberg.org/small-tech/jsdb/commit/9e039e76f7a149df2fa7ecbbf626f813e44c0ab2
3.0.2 update (diff): https://codeberg.org/small-tech/jsdb/commit/f212566f8da4327d0b91d81e8cc6f5058ce63c47
Kudos to Pravin Divraniya for https://stackoverflow.com/a/57958494
¹ https://codeberg.org/small-tech/jsdb
² https://www.npmjs.com/package/@small-tech/jsdb
#JSDB #JavaScript #JS #database #SmallTech #Date #Proxy #web #dev
Picking the right language is a sign of respect: Coming to a language near you - https://mariadb.org/coming-to-a-language-near-you/ #mariadb #database
There were 37 delightful Postgres & Citus talks at Citus Con: An Event for Postgres 2023 this year!
So I have more to share with y'all in my 37 days of Citus Con mission.
Today's Citus Con video of the day is by Taras Kloba, about "PostgreSQL Security: Defending Against External Attacks."
It's actionable & super important & presented in an engaging way. Boosts appreciated.
#PostgreSQL #Postgres #security #OpenSource #database #CitusCon
Kinda cool how many #localfirst and #p2p #database projects are active right now.
#CaseStudy - Take a sneak peek into #Dropbox’s Magic Pocket!
Magic Pocket is a horizontally scalable exabyte-scale blob storage system and can maintain 99.99% availability and extremely high durability.
#InfoQ article by Facundo Agriel: https://bit.ly/45dN8fq
#CloudComputing #Database #Storage #Scalability #performance
Dew Drop – May 17, 2023 (#3945)
Top links today:
- Announcing .NET 8 Preview 4
- #ASPNETCore updates in .NET 8 Preview 4
- How Microsoft 365 Copilot works
- Big changes coming for Blazor in .NET 8
- EF Core 8 Preview 4: Primitive collections and improved Contains
- Visual Studio 2022 - 17.6 now available
https://www.alvinashcraft.com/2023/05/17/dew-drop-may-17-2023-3945/
#visualstudio #ai #webdev #cloud #windowsdev #dotnet #mobiledev #database #csharp #dewdrop
It's an unfortunate meme IMO that tech Reddit is low-quality. You just have to find interesting subreddits!
I've updated my list for 2023.
https://notes.eatonphil.com/high-quality-subreddits-you-should-be-following.html
MariaDB Foundation developer Anel Husakovic writes about migrating to MariaDB Server from Oracle: https://mariadb.org/data-migration-from-oracle-to-mariadb-with-docker-and-connect-se-a-step-by-step-guide/ #mariadb #database #oracle
Good tips 👉 Deploy schema changes in an Amazon Aurora MySQL database with minimal downtime https://aws.amazon.com/blogs/database/deploy-schema-changes-in-an-amazon-aurora-mysql-database-with-minimal-downtime/ #AWS #Database
Today's #CitusCon video of the day 📺 was presented by Postgres committer @tmunro who I am privileged to work with at Microsoft.
It's all about Parallelism in PostgreSQL. With a lovely sock analogy to boot. Thomas is such a good explainer & teacher, hope y'all enjoy it.
https://aka.ms/cituscon-thomasm-2023
#PostgreSQL #Postgres #databases #database #conference #OpenSource #Microsoft
"Fluree: an Immutable, Verifiable, Shareable Database" by Daniel Petranek
https://www.youtube.com/watch?v=PV4IUuqblig
More #database stuff – this time, with a completely different idea. The talk makes a really compelling argument for how we should have a #SemanticWeb database and for using the tools that already exist. I also like the idea of getting rid of the typical Web Server - Persistence interaction boilerplate.
New – Amazon Aurora I/O-Optimized Cluster Configuration with Up to 40% Cost Savings for I/O-Intensive Applications 👉 Improved price performance and predictable pricing for I/O-intensive apps, such as e-commerce, payment processing systems https://aws.amazon.com/blogs/aws/new-amazon-aurora-i-o-optimized-cluster-configuration-with-up-to-40-cost-savings-for-i-o-intensive-applications/ #AWS #Database
Dew Drop – May 12, 2023 (#3942)
Top links today:
- Marten v6 is out and the road to Wolverine 1.0
- Budding love for compose animation
- ASP.NET Core basics: Build a complete CRUD app with VS Code
- MAUI App Accelerator v1.2.4 released
- Surround selection experiment in Visual Studio
https://www.alvinashcraft.com/2023/05/12/dew-drop-may-12-2023-3942/
#dotnet #webdev #ai #windowsdev #cloud #mobiledev #csharp #visualstudio #database #dewdrop
Nice addition! Amazon MemoryDB for Redis now supports IAM Authentication 👉 You can now associate IAM users and roles with MemoryDB users and manage their cluster access https://aws.amazon.com/about-aws/whats-new/2023/05/amazon-memorydb-redis-iam-authentication/ #AWS #Database #NoSQL #Redis
🆕 blog! “Doctrine - difference between bindValue() and setParameter() on prepared statements”
This pissed me off and I couldn't figure out what I was doing wrong. So I'm blogging about my ignorance. Imagine you're using Symfony and Doctrine to access a database. You are using prepared statements to prevent any SQL injection pr…
👀 Read more: https://shkspr.mobi/blog/2023/05/doctrine-difference-between-bindvalue-and-setparameter-on-prepared-statements/
⸻
#database #mysql #php #Symfony
MariaDB 10.11.3, 10.10.4, 10.9.6, 10.8.8, 10.6.13, 10.5.20, 10.4.29 and 10.3.39 now available https://mariadb.org/mariadb-10-11-3-10-10-4-10-9-6-10-8-8-10-6-13-10-5-20-10-4-29-and-10-3-39-now-available/ #mariadb #database
Announcing the 2023 MariaDB (Un)Conference and the MariaDB Server Fest: https://mariadb.org/announcing-the-2023-mariadb-unconference-and-the-mariadb-server-fest/ #mariadb #database
#CaseStudy - Suhail Patel shares some practical lessons they learned while constructing their architecture at #Monzo. He delves into both successful endeavors & unfortunate mishaps.
Read the #InfoQ article for more insights: https://bit.ly/3LLKPHx
#SoftwareArchitecture #Microservices #Cassandra #Kubernetes #Database #CloudAdoption
Dew Drop – May 9, 2023 (#3939)
Today's top links:
- MAUI applications in .NET 7 with Maddy Montaquila - Azure DevOps Podcast Episode 244
- GitHub Code Search is generally available
- PowerShell extension for VS Code Spring 2023 update
- The Stack Overflow 2023 Developer Survey is now live
- Create and validate a login form in .NET MAUI
https://www.alvinashcraft.com/2023/05/09/dew-drop-may-9-2023-3939/
#dotnet #ai #webdev #csharp #windowsdev #devops #visualstudio #database #dewdrop
Multi-tenancy through catalogs in MariaDB Server: https://mariadb.org/multi-tenancy-through-catalogs #mariadb #database
In case you weren't already aware of it, here's a link to the #p2p #database chat we've got on Matrix. Mostly talking about stuff related to #ProllyTrees
An interesting JavaScript Database (JSDB) edge case I just encountered:
If you’re persisting custom objects, please do NOT use setter methods (`set something () {…}`).
Use regular methods instead (`setSomething () {…}`) for predictable behaviour that likely matches your conceptual model of how things should work.
(This is due to how setters interact with proxies.)
Details: https://codeberg.org/small-tech/jsdb#custom-data-types
#JavaScriptDatabase #javascript #database #jsdb #accessors #SmallTech #SmallWeb #web #dev
@Shini92 Nice. One very similar use case for me is database schemas for JavaScript Database (JSDB)¹, which is part of Kitten² :)
https://codeberg.org/domain/app/src/branch/main/app_modules/database/database.js
¹ https://codeberg.org/small-tech/jsdb
² https://codeberg.org/kitten/app
#Development #Previews
Deno KV · A global database built for JavaScript and TypeScript with zero setup https://ilo.im/12nl7x
_____
#WebDevelopment #WebDev #Frontend #Backend #Database #Serverless #JavaScript #TypeScript #FoundationDB #SQLite
That feeling when you realise you've been using MS Access since back when the example date given was recent.
#database #access #MSaccess #FeelingOld
PS. I’ll update Kitten¹ with the latest JSDB today.
¹ https://codeberg.org/kitten/app
#Kitten #Domain #JSDB #SmallWeb #SmallTech #web #dev #nodeJS #database
Just released #JavaScript #Database (#JSDB)¹ version 3.0.0
Breaking change²: data is now evaluated in virtual machine contexts.
If you were persisting custom objects³ and referencing classes from global scope (`globalThis`) to have your objects keep their types when read, you must now explicitly register your list of custom classes using the new `classes` property of the `options` object when calling JSDB.open().
¹ https://codeberg.org/small-tech/jsdb#javascript-database-jsdb
² https://codeberg.org/small-tech/jsdb/src/branch/main/CHANGELOG.md#3-0-0-2023-04-28
³ https://codeberg.org/small-tech/jsdb#custom-data-types
Honest question about #coding -
I felt early on in my career that I was in the minority as I enjoy #database development and honestly most #backend #developer work, but I started to question that belief over the last several years..
Was I wrong this whole time?
What type of #internet dev work do you most enjoy? Feel free to elaborate!
@selfcare just yesterday when I attended and spoke at the brilliant #PGDay #Chicago ♥️:postgresql:
#postgres #postgresql #opensource #database #databases
Yikes, I am in the home straight before Citus Con: An Event for Postgres 2023, our 2nd annual virtual event happening:
- Tue Apr 18 @ 9am PDT
- Wed Apr 19 @ 9am CEST
Who do I know on Twitch who has #PostgreSQL followers & would be willing to "raid" the Twitch livestream from #Microsoft Developer for the 2 #CitusCon livestreams? Boosts welcome!
@nova would you—or do you know anybody whose Twitch ppl care about #postgres
@sushee that is why I never got into nosql database at all.
I did learn them but when it comes to reporting sql dbs are so good, one cant beat them.
Also I have yet to work at an organisation where they get user numbers near a million.
If one is working with thousands of users sql is the best.
I suppose I should write an #introduction. I mean, I've only been on the fediverse for five years. :P
Hi, my name is Martin, I go by DarkFox (or DarkFoxDK) on the internet. I'm in my mid-30's and I've been doing #WebDevelopment, #programming, and #database stuff since I was still in school.
Currently I'm working with complex #automation systems in #HealthCare, where I'm a bit of a jack of all trades, doing a bit of #UserSupport, #SystemAdmin, and #DataAnalysis.
At home I thinker with a lot of #SmartHome stuff, based on #HomeAssistant. This includes building my own #electronics and #3DPrinting stuff.
At times, I enjoy running around as a big silly #fox, as part of the #Furry fandom.
I'm also #ActuallyAutistic, #AuDHD, and part of the #lgbtqia #AlphabetMafia.
Track All of Your Stuff with Under My Roof from Binary Formations
https://www.podfeet.com/blog/2023/04/under-my-roof/
A beautiful UI with a rock-solid application that makes tracking your stuff actually enjoyable.
🆕 blog! “Some thoughts on "Hacking the Cis-tem"”
I recently read a wonderful paper by Mar Hicks called "Hacking the Cis-tem" which is about database design in the 1960s and the nascent digital state's approach to transgender individuals. It's a short and readable paper with some jaw-dropping anecdotes. Like the man who immediately got a pay rise after his …
👀 Read more: https://shkspr.mobi/blog/2023/04/some-thoughts-on-hacking-the-cis-tem/
⸻
#ComputerScience #database #gender #trans
Using #JetBrainsRider new #database schema compare tool to compare @maartenballiauw zoo with my zoo.
Hey... wait a minute. His "lions" are really just cats! #meow #cats
#Business #Design #Development #Launches
sqlTranslate · Easily translate SQL commands into natural language and vice versa https://ilo.im/11vh0y
_____
#Tool #WebDesign #WebDevelopment #WebDev #Backend #Database #SQL #NaturalLanguage #Translator #DataAnalysis
#Development #Launches
MySQL for Developers · A video course to learn everything you need to know about MySQL https://ilo.im/11tvb8
_____
#WebDevelopment #WebDev #Backend #Database #SQL #MySQL #Free
https://buff.ly/3EijryB #database-driven applications using #SQLserver need to #scale to succeed. In this class by @jdanton you'll learn the techniques to scale your SQL applications to grow with your user base. #rdbms #CloudComputing #Azure