Recent searches
Search options
#sql
1 post1 participant0 posts today
If you're a developer, #SurrealDB might be the ultimate prototyping tool for your data. Check out my latest blog post on using SurrealDB with Node.js and Fastify! #sql #nosql #nodejs #fastify https://reverentgeek.com/meet-surrealdb-nodejs/
Continued thread
Here’s another dashboard variant built using Claude Desktop as the MCP client and the virtual Northwind Knowledge Graph, derived from underlying Northwind tables. This edition adds both a Company and Employee dimension:
https://claude.site/artifacts/7c4f5e75-d33a-4902-8a83-ed095de146a2
I really hate the term "vibe coding" - particularly because there is an assumption that it's easy to get usable and bug-free code out of an LLM. I use it as a tool to bounce ideas off of and spend most of my time telling it how wrong it is. Occasionally, you get some great results in a much faster way. It's definitely not plug and play - or a substitute for experience.
Hacking in movies.
#Programming #Coding #IT #Tech #Software #Python #SQL #Computer #webdevelopment #Statistics #DataAnalysis #MachineLearning #DataScience #Jokes #Memes #Funny #NeuralNetworks #SEO #AI #DevOps
Python Knowledge Base
https://python-code.pro/
New CV - Still secretly just a waiter. Available for pennies on the dollar.
This week’s edition of my @linkedin newsletter shines a light on the impact of the Model Context Protocol (MCP) across multiple computing eras—leading right up to today.
We’ve arrived at a moment where loose coupling principles are cool (and super useful) again.
Naturally, there are some live demo nuggets in the post to help bring it all to life:
https://www.linkedin.com/pulse/model-context-protocol-bridging-generational-computing-idehen-qdtce/
All things (even people) need to be touched at some point cos things break when they're left unmaintained and lonely out there.
I haven't been touched in 5+ years, but I maintain myself every few days lol
Also fuck you Oracle.
https://odysee.com/@AlphaNerd:8/oracle-tried-to-coverup-this-data-breach:8
Diving into #Vermont wildlife for the #30DayChartChallenge "circle" day! 
Using #Python & #plotly to compare monthly #Moose and #BlackBear sightings 
Data wrangled with #BigQuery and #SQL. Any guesses which animal is seen more consistently throughout the year? 
#DataViz #Wildlife #RadialChart
Why are #sql keywords usually written in uppercase when it's not required by the language? Was there a time (or variant) when it was required, or is this just a formatting convention? Can you answer this question? https://software.codidact.com/posts/293677
software.codidact.comWhy is SQL usually written in CAPS?Why are keywords in SQL usually written in capital letters? For example:
```sql
SELECT FROM person WHERE mood = 'happy';
```
My understanding...
Welcome to this month's meetup on Tuesday 15th April 2025 at Reaktor!
Talks:
@maaretp - Exploratory Unit Testing with and for GenAI
Toni Vanhala - Stable and Observable: Celery Setup Essentials for SQL Pipelines
And the famous HelPy quiz!
https://www.meetup.com/helpy-meetups/events/307043355/
See you there!
MeetupApril Helsinki Python meetup, with Reaktor, Tue, Apr 15, 2025, 5:30 PM | MeetupThe clocks have gone forward and that means it's time for our fourth meetup of 2025, this time kindly hosted by [Reaktor](https://www.reaktor.com/en-fi)!
17:30 - Doors ope
On today's Crafter Hours stream, we'll continue working on porting over the Discourse Single-Sign On authentication that I implemented in JavaScript for another version of the System Crafters site.
Let's see how things look when we reimplement this in Guile Scheme!
Join us here:
- https://youtube.com/live/OFBCZ1uMBWk
- https://twitch.tv/SystemCrafters
www.facebook.comTask Excel Vs SQL VS Python Excel Load Data file Open File SELECT FROM table_nane; Python (Pandas) B10, SELECT Columns table Use column Letters read_csv("file.c Short df(df[ column'] Data SELECT colunnl, colunn2 100] Sort Aggregate ORDER Pivot Table DESC; colu GROUP Average Mean dept; =AVERAGE(B2:B100) aggo B100) Remove VG(salary) Data salary' Renove FROM nean( Join Tables sun() DISTINCT colunn table; LODKUP XLOOHUP FROM =B2 column JOIN ,drop_duplicates() df2, salary, salary*Đ. Manually 'bonus'] Missing Data colunn FROM table; IF(ISBLANK(A2), "N/A", Export File Save NULL, COALESCEO inplace=True) Visualization Insert or Charts SSMS) df.dropnaC) Not native; use f.to_csv("output. ,index=False) .plot(kind=" 'bar'), natplotLibDifference between Excel vs SQL vs Python✅
Thanks to a live Data Camp session I found out that there are helper aggregate functions for linear regression in SQL in DuckDB
e.g.
regr_slope()
regr_intercept()
https://duckdb.org/docs/stable/sql/functions/aggregates.html
DuckDBAggregate Functions
Replied in thread
Love the new article :
LibreOffice Base and Firebird – a special relationship
The Document Foundation Blog · LibreOffice Base and Firebird – a special relationship - The Document Foundation Blog(Translated from the Spanish original.) Juan C. Sanz writes: The Firebird database is distinguished by its unique features within the LibreOffice Base compatible database ecosystem. Why do I consider Firebird to be special? Because it is the only database engine that supports all possible forms of connection in Base and also allows the creation of […]
Suche dringend nach menschen die mir #SQL erklären / an die ich fragen stellen kann.
Ich bin in der #Berufsschule komplett raus aus dem Thema da ich leider einen nicht sehr guten Lehrer erwischt habe
(bsinfo, nm 
)
Es geht konkret um JDBC, Select Statements, Metadaten
