#Database
If you were to start a new #Database and #WebServer project, what tools would you use? This is something new to me and I’m leaning towards #RustLang and #postgresql :postgresql: but I’m out of my league :mastoread:
Maybe #RubyOnRails :ruby: ?
#AskFedi :boost_ok:
Nice solution 👉 Join a streaming data source with change data capture (CDC) data for real-time serverless data analytics using AWS Glue, AWS DMS, and Amazon DynamoDB https://aws.amazon.com/blogs/big-data/join-streaming-source-cdc-glue/ #AWS #Database #Analytics
Have you ever heard of a "bitemporal" database? 🤔
This week, I'm talking to James Henderson, lead developer of #XTDB, to explore the world of bitemporality and the life of a #database developer.
Listen: https://pod.link/developer-voices/episode/f191f62237641ea6a53ad8517949154f
Watch: https://youtu.be/3sRKQg9-In8
This tips can be handy 👉 Cost-effective bulk processing with Amazon DynamoDB https://aws.amazon.com/blogs/database/cost-effective-bulk-processing-with-amazon-dynamodb/ #AWS #Database #NoSQL #FinOps
🚨 Attn #UK #Conservation, #History, #Geology, #StoneMason, #Architecture, & #Surveyor peeps!
Together w #BritishGeologicalSurvey, #HistoricEngland has launched a #BuildingStones #database for #England, the country's first online searchable tool featuring over 4,000 types of building stone, their uses & sources, with 45 illustrated guides to the distinctive stone buildings, geology, & #quarries that define local areas.
#BGS #GIS #England #Heritage #Lithology #Histodon
https://historicengland.org.uk/advice/technical-advice/buildings/building-stones-england
DataStax, Google partner to bring vector search to NoSQL AstraDB - DataStax is partnering with Google to bring vector search to its AstraDB NoSQL databas... - https://www.infoworld.com/article/3698713/datastax-google-partner-to-bring-vector-search-to-nosql-astradb.html#tk.rss_all #nosqldatabases #database #google
DataStax, Google partner to bring vector search to NoSQL AstraDB
Check it out! 👇
https://www.infoworld.com/article/3698713/datastax-google-partner-to-bring-vector-search-to-nosql-astradb.html#tk.rss_all
What are the implications of the geographical concentration of #migration research in immigrant destination countries? #globalNorth
We try to answer this question in our new article written with Lorenzo Piccoli and Andrew Geddes based on an original #database of migration research institutes globally. #knowledge #academia #decolonization
https://comparativemigrationstudies.springeropen.com/articles/10.1186/s40878-023-00336-1
How do people #backup their self-hosted #plausible (in Docker) databases? Seems there's 2: the users etc. and the #clickHouse #database (which is completely new to me). All the data is in Docker volumes.
Excited to say that my @infoq article has just gone live! ✨
Debugging Outside Your Comfort Zone: Diving Beneath a Trusted Abstraction
https://www.infoq.com/articles/debugging-beneath-trusted-abstraction/
Handling Updates and Deletes in ClickHouse
https://clickhouse.com/blog/handling-updates-and-deletes-in-clickhouse
One month left for the #dbaday 2023.
The 7th July 2023 say thank you to your #dba for keeping your data safe and sound. #thankyou #data #database #administrators #appreciation #day
https://dbaday.org/
#AITA? #devops allowed #GCP to automatically add random digit strings to project names to make them unique. I complained because now the #datascience and #machinelearning team has to memorize and type out those digits whenever we do ad hoc queries, which is all the time. #devops does not actually use the #GBQ #database so didn’t realize how annoying this would be. Am I the asshole? I don’t think so 🤷 some people just don’t think about how their work impacts others
Nice case study 👉 How Twilio modernized its Messaging Postflight service data store with Amazon DynamoDB https://aws.amazon.com/blogs/database/how-twilio-modernized-its-messaging-postflight-service-data-store-with-amazon-dynamodb/ #AWS #Database #NoSQL
Announcing Amazon Keyspaces Multi-Region Replication 👉Automated, fully managed, active-active replication across the AWS Regions of your choice https://aws.amazon.com/blogs/database/announcing-amazon-keyspaces-multi-region-replication/ #AWS #Database #NoSQL #OpenSource
When dealing with mysqldump error 1412 (table definition has changed) during a #backup process on a #MySQL or #MariaDB server, your first task is to identify the script modifying the table(s).
Always make sure you find a proper application "downtime" to create a consistent #database backup.
https://www.claudiokuenzler.com/blog/1317/mysqldump-error-1412-table-definition-has-changed
How do you get around a #raspberrypi's ram being too small to use an up to date #clamav #virus #database?
Dew Drop – June 6, 2023 (#3958)
Top links today:
- What’s new in SSDT 17.6: Ledger, performance, Copilot
- Personalize your WinUI DataGrid: Quick & simple customization
- Unity runtime on Arm-based Windows devices
- M365 Dev Podcast - MS Graph Dev Proxy w/ Garry Trinder & Waldek Mastykarz
- New Uno Platform release: Media Player Element on mobile, web, Linux. WebView2 support.
https://www.alvinashcraft.com/2023/06/06/dew-drop-june-6-2023-3958/
#dotnet #ai #webdev #cloud #mobiledev #windowsdev #database #csharp #visualstudio #dewdrop
I have been a #developer for just a little more than 2 years now, and today marks the first time I ever opened #SQL developer, and interacted with a real #database.
Not saying that I never worked with databases ever, but since I do mostly work with low-code platforms, everything is usually handled in the back-end.
Super cool to learn new things!
Fintech Leader Juspay Analyzes Over 50 Million Daily Payment Transactions in Real-Time with ClickHouse
https://clickhouse.com/blog/juspay-analyzes-payment-transactions-in-real-time-with-clickhouse
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 - 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
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
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
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
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
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
