Create accountLogin

Recent searches

No recent searches

Search options

Not available on lingo.lol.
lingo.lol is one of the many independent Mastodon servers you can use to participate in the fediverse.
A place for linguists, philologists, and other lovers of languages.

Administered by:

Server stats:

64
active users

lingo.lol: AboutProfiles directoryPrivacy policy

Mastodon: AboutGet the appKeyboard shortcutsView source codev4.3.9

#database

4 posts4 participants0 posts today
Public *
mobidic

The GDELT project taken down by Google in June 2025. Google shares no effort to restore it! Save the GDELT Database to allow others to track down how democracy under GOP/Trump vanished over the last 10 years.

Share their database (it will take me time to upload the 42GB for all zipped CSV data from 2025 to 2010 - will note): 1024terabox.com/s/1Hs0sSKCNt-O

Support web.archive.org/web/2025052601
Support en.wikipedia.org/wiki/GDELT_Pr

Screenshot of the GDELT Project from June 15th 2025. GDELT monitors print, broadcast, and web news media in over 100 languages from across every country in the world to keep continually updated on breaking developments anywhere on the planet. Its historical archives stretch back to January 1, 1979 and update every 15 minutes. Through its ability to leverage the world's collective news media, GDELT moves beyond the focus of the Western media towards a far more global perspective on what's happening and how the world is feeling about it. Src: https://web.archive.org/web/20250526014208/http://gdeltproject.org/
#democracy#GDELT#Google
Public
Alfonso Siciliano

🖥️ My ultra-budget server powering websysctl.alfonsosiciliano.net has been running smoothly for the past 2 months. So far, so good!

📈 #Crawlers hit tens of thousands of sysctl parameter pages daily. That's fine, since robots.txt allows it. But why keep requesting non-existent pages as if the site were built with WordPress 😤 ? Fortunately, the stack (#FreeBSD :freebsd: + #OpenResty 🌐 + #Lapis ✏️ + a custom-built #database 📦 ) stays well within the limited resources of my $5/month cloud server.

The code might soon be #OpenSource stay tuned!

Screenshot of the "Tree MIB" page from the WebSysctl site. The left panel shows an expandable tree view of the FreeBSD sysctl MIB hierarchy, with nodes like sysctl, kern, vm, sys, security, and their subcategories. The security.mac.mmap_revocation_via_cow node is selected. The right panel displays detailed information about this sysctl parameter, including its link, OID, name, description ("Revoke mmap access to files via copy-on-write semantics, or by removing all write access"), type (integer), format (I), flags (RD, WR, MPSAFE), label, and handler status (Defined). The top navigation bar includes links: Home, Docs, Table, Tree (highlighted), Update, Login, and Contacts.
#UNIX#sysctl#WebDev
Public
Benjamin Carr, Ph.D. 👨🏻‍💻🧬

30 years of #MySQL, the #database that changed the world
From ubiquitous go-to system for early Noughties startups to a legacy like no other
The arrival of MySQL coincided with the #dotcom boom, which heralded the arrival of technologies and businesses that, for better or worse, became known as Web 2.0.
MySQL became the M in LAMP, the de facto standard used to build web-facing systems, which included Linux, Apache web server, and programming languages Perl, PHP, or Python
theregister.com/2025/05/06/30_

The Register · 30 years of MySQL, the database that changed the worldBy Lindsay Clark
Continued thread
Public
George E. (he/him/his)

Heads up #Sharkey #admins when #upgrading...
If you have a lot of #data in your #instance #database, running pnpm run migrate might fail because one or more of the ALTER TABLE... statements might actually timeout on your #PostgreSQL server!

To fix this, attach yourself to your sharkey database and enter the following...

ALTER DATABASE sharkey SET statement_timeout = '10min'; 
ALTER ROLE sharkey SET statement_timeout = '10min';
...and try the pnpm run migrate command again.

#SharkeyAdmin #InstanceAdmin @sharkey@sharkey.team
Public
K Belisario (she/her)

Looking for any examples of using a ShinyApp to allow researchers to select the data they would need for their specific research question. This will be for a large, multi-site project and I was hoping there would be a way to have the the dataset processed based on selection and then sent all securely in the format they need (e.g. long vs wide format). For this to be done securely, I’m thinking the app sends a request which is downloaded regularly to a local machine which can then automatically send out the data as needed using secured methods… But there’s probably a more eloquent way to do this! #R #AskFedi #Data #Database

Public
Claire Giordano ✨

Next week, #PosetteConf is happening Jun 10-12. Free & virtual

✅ Newly-published, this "ultimate guide" blog post will help you navigate the 4 livestreams & 42 #PostgreSQL talks at POSETTE: An Event for Postgres (or to figure out where the virtual hallway track is happening) 🐘

POSETTE is now in its 4th year. It's organized by the Postgres team at Microsoft, and our team's goal (in partnership with the amazing speakers) is to delight all of you who care about Postgres

🚀 Boosts appreciated. Don't let your #Postgres friends miss out.

techcommunity.microsoft.com/bl

TECHCOMMUNITY.MICROSOFT.COMUltimate Guide to POSETTE: An Event for Postgres, 2025 edition | Microsoft Community HubA guide to help you navigate all 42 talks at the 4th annual POSETTE: An Event for Postgres, a free and virtual developer event happening Jun 10-12, 2025.
#Conference#OpenSource#database
Continued thread
Public
Annales HSS

Le troisième dossier de ce numéro, « Compter les dieux », revient sur les effets méthodologiques de la création d'une base de données, à l'occasion d'un projet financé, sur les mentions épigraphiques des dieux grecs. L'article est à la fois présentation de la base et réflexion sur les effets d'une telle approche quantitativiste en histoire ancienne.

▶️ Corinne Bonnet, Julie Bernini, Thomas Galoppin, Sylvain Lebreton, Giuseppina Marano, Enrique Nieto Izquierdo et Alaya Palamidis
Des dieux qui comptent. Approches quantitatives des hiérarchies divines

👉 doi.org/10.1017/ahss.2025.5
👉 shs.cairn.info/revue-annales-2

#histodons @histodons #histoireancienne #greceancienne #antiquity #database #digitalhumanities

Cambridge CoreDes dieux qui comptent | Annales. Histoire, Sciences Sociales | Cambridge CoreDes dieux qui comptent - Volume 79 Issue 4
Public *
Veronica Olsen 🏳️‍🌈🇳🇴🌻

Any database wizards out there?

I have a table with an ID column. The ID column is unique together with a valid date, so the ID itself is not unique.

However, I also need a name column that is unique under the condition that any given name can only correspond to one specific ID (but not necessarily the other way around).

The database is PostgreSQL. Is it possible to formulate, for instance, a UNIQUE INDEX to achieve this?

Edit: Solved 🥳

#Programming#Development#Help
ExploreLive feeds
About