mastodon.ie is one of the many independent Mastodon servers you can use to participate in the fediverse.
Irish Mastodon - run from Ireland, we welcome all who respect the community rules and members.

Administered by:

Server stats:

1.8K
active users

#sql

15 posts13 participants2 posts today

Introdução ao SQL

Laboratório Hacker de Campinas, terça-feira, 22 de abril às 19:30 BRT

Introdução ao SQL

Oficina prática para aprender alguns conceitos básicos de SQL. Como inserir, alterar, e buscar dados em bases de dados relacionais e usar esses conceitos para descobrir informações sobre os dados disponíveis.

A participação é GRATUITA.pedimos para fazer sua inscrição no link a seguir para termos um controle sobre a ocupação do LHC.

https://pretix.lhc.net.br/lhc/sql-101/

Foto da divulgação por Tima Miroshnichenko: https://www.pexels.com/photo/a-person-standing-near-data-base-wooden-drawer-6549358/

eventos.lhc.net.br/event/intro

#PHP operations on #mysqli are a treat. They return either the expected object, or a true/false boolean.

Connection fails? Boolean. Succeeds? Connection object. Preparing an #SQL statement fails? Boolean. Succeeds? Statement object. Binding parameters to prepared statement fails? Boolean. Succeeds? Boolean. Executing the statement fails? Boolean. Succeeds? Boolean as well, or an associative array, depending on intent.

And thanks.

And Now It’s All This: SQL help from ChatGPT. “I had a couple of SQL database queries that I wanted to improve. Instead of going my usual route of searching for the answer in SQLite’s documentation, I decided to give ChatGPT a crack at it. I hoped that I would not only get better queries, but that I’d also learn something about SQL by studying the answers. It took a couple of tries, but I […]

https://rbfirehose.com/2025/03/31/and-now-its-all-this-sql-help-from-chatgpt/

ResearchBuzz: Firehose | Individual posts from ResearchBuzz · And Now It’s All This: SQL help from ChatGPT | ResearchBuzz: Firehose
More from ResearchBuzz: Firehose

I am in urgent job search mode, so I'm gonna throw this out here and see if anything comes of it.

I am a #Canadian, fluent in both #English and #French. I have experience with several programming languages. My strongest proficiency is with #Haskell and #C. I also have a reasonable grasp of #HTML, #JavaScript, #SQL, #Python, #Lua, #Linux system administration, #bash scripting, #Perl, #AWK, some #Lisp (common, scheme, and emacs), and probably several others I've forgotten to mention.

I am not necessarily looking for something in tech. I just need something stable. I have done everything from software development, to customer support, to factory work, though my current circumstances make in-person work more difficult than remote work. I have been regarded as a hard worker in every job I have ever held.

A Practical Guide to Uncovering Malicious Infrastructure With Hunt.io

This guide demonstrates how to use Hunt.io to investigate and track malicious infrastructure. Starting with a single suspicious IP address, the process involves analyzing hosting providers, domain information, open ports, HTTP responses, and TLS certificates. The investigation reveals connections to potential cryptocurrency fraud and malware operations. By leveraging Hunt's scan data and SQL queries, a small cluster of related servers is identified, possibly linked to Latrodectus malware. The guide emphasizes the importance of persistence, pattern recognition, and correlating data from multiple intelligence sources to effectively track threat actor operations.

Pulse ID: 67e342d7a17ba37eb960497a
Pulse Link: otx.alienvault.com/pulse/67e34
Pulse Author: AlienVault
Created: 2025-03-25 23:57:11

Be advised, this data is unverified and should be considered preliminary. Always do further verification.

LevelBlue Open Threat ExchangeLevelBlue - Open Threat ExchangeLearn about the latest cyber threats. Research, collaborate, and share threat intelligence in real time. Protect yourself and the community against today's emerging threats.

Exploring the Vivaldi History Database
lonm.vivaldi.net/2025/03/04/ex

"My browser, Vivaldi (based on chrome), allows syncing history. This works for new entries, but I wanted to see if there was a way to merge the history files for some of my devices that started off in a diverged state. Each of my files are a few years old, are are several hundred MB in size."

UML diagram of the history table, visualising what is discussed in text in the blog post
LonM's Blog · Exploring the Vivaldi History Database | LonM's BlogAn exploration into the structure of the Vivaldi browser history database file

sqlmap: Automatic SQL injection and database takeover tool

sqlmap is an open source penetration testing tool that automates the process of detecting and exploiting SQL injection flaws and taking over of database servers. […]

🔎 darkwebinformer.com/sqlmap-aut

Dark Web Informer - Cyber Threat Intelligence · sqlmap: Automatic SQL injection and database takeover toolsqlmap: Automatic SQL injection and database takeover tool
#sql#check#database

What is the best free, open source program to make an Entity-Relationship Diagram of a database? Must be a local application, not web based.

Once upon a time I would have googled this but now all the results are search-engine optimized "blogs" from vendors trying to convince you their browser-based, subscripton-model app is the best option.

EDIT: One more requirement. I would like the field names and data types listed within the box for each table.