#programmming language

[oidheadh-con-culainn]

i find it very disorientating the way americans refer to uni as "school" (especially postgrad) because sometimes i'm talking to someone online and i'm trying to gauge their age (often if they're talking shit and i want to know how firmly to call them out on it) and they start talking about "school" and "homework" and I'm like. okay, they're sixteen, it's fine, i'll let them off

and then you find out they're 26 and a phd student or something

[shazzbaa]

hi! have you done "evolution" yet? i'm curious how sam got along with the youthful naturalist, another man with a... close relationship with peril :)

Samuel is such a funny choice for the Youthful Naturalist to have dragged into his nonsense. Catholic deacon vs man who is SO done with the church. Man self-consciously worried about getting "too bony" to avoid a fate as the boatman vs man whose skeletally gaunt face is because he ALMOST DID BECOME THE BOATMAN. Man who thinks death should be natural and correct and is mostly just upset about the Far Shore thing vs man with an insane scheme to NEVER DIE.

Sam is so exasperated with this kid constantly but also got attached and really wants him to be okay. He is not smart enough to follow 90% of this research, but he's invested in learning more about what's going on with Death in the Neath so HES DOING HIS BEST TO KEEP UP,

[dawnbreakersgaze]

Guys I was playing the event stories again one last time before they went away forever and I just noticed the sweetest fucking thing ever

When you first walk up to Zayne and catch him on his phone, look at his face. He goes from his normal neutral expression to the softest little smile when he realizes it's you/mc walking up to him 🥺🥺🥺

He even straightens himself up a little taller when he sees you i'm dying send help 😩

I'm gonna squish him 🥲

[daisiesonafield-blog]

[agent-z-coding]

I HAVE FINALLY SUCCEEDED

IT WORKS!!! IT WORKS!!!!!

[4, 5, 4.3] -> add BECOMES 13.3!!!!!!!!!!

YOU PEOPLE I HAVE DONE IT

source code will be coming soon (as soon as i get more helper functions working.

For now, PLEASE contribute if you can. Even as little as suggesting some helper functions could help me a ton.

Contribute below:

Open a PR, An issue, Anything, Just mention what the language lacks and you don't even need to implement it yourself, I'll add it to the To-Do list and get working on it ASAP.

Join the discord server, I will be posting updates and asking for suggestions and providing beta builds: https://discord.gg/JxnKn9jd

[python-programming-language]

Post #91: Pinterest, @usamaawan5752, Python Road Map, 2023.

[smak-annihilation]

linguist parents of a programmer who don't approve of their child's decision to not persue the family craft:

"so anyways, when are you gonna learn a REEAL language?"

"There are always open spots in German"

[hybbat]

The art tutorials never cover the things that actually need tutorials (programming) (graphic design) (navigation) (resources) (terminology) (actually telling you the tool they used and how to use it in the first place)

[frog707]

Go Forth!

Each year on 4 May, geeks everywhere celebrate a famous moviestack-oriented programming language from the 1970s:

[sivaniverse]

Help required to collect data for a project.

Hello everyone,

I am currently working on the development of an Indian Sign Language interpretation system and need your help in collecting sign language gestures for training purposes. I have not found proper data for training a model for this project. Any contributions are would be very helpful and will be used exclusively for this project. I have created a Google form where you can upload video demonstrations of the gestures. Sample videos are provided for your reference. If you're interested in contributing, please use the following link to fill the form

Any support will be very helpful. If you're unable to upload the video files in the form send them to the mail mentioned in the form.

Please reblog and share this post which would help me reach more people who would be able to help me with this.

[lavendertarot]

Tbh I don't think we'll ever have "real AI", because first of all the act of creation in tech implies a level of replicability that requires a person to understand how a quote-unquote "independently thinking computer" came to the conclusions it did and produced the data it has. More importantly though, if one was created I don't think you could spend more than 10 minutes before some investor or self important computer scientist insisted that every thought that came from the AI was their own - thus defeating the whole point of strong artificial intelligence

[aceoffangirls]

Being in a english speaking country that is not the UK or USA can be weird because majority of the time I use like the UK spelling and pronunciation but every now and then I use American Spelling...

[agent-z-coding]

Writing a programming language in C. How is this syntax:

Join the discord server, I will be posting updates and asking for suggestions and providing beta builds: https://discord.gg/JxnKn9jd

[digitaldetoxworld]

Structured Query Language (SQL): A Comprehensive Guide

 Structured Query Language, popularly called SQL (reported "ess-que-ell" or sometimes "sequel"), is the same old language used for managing and manipulating relational databases. Developed in the early 1970s by using IBM researchers Donald D. Chamberlin and Raymond F. Boyce, SQL has when you consider that end up the dominant language for database structures round the world.

Structured query language commands with examples

Today, certainly every important relational database control system (RDBMS)—such as MySQL, PostgreSQL, Oracle, SQL Server, and SQLite—uses SQL as its core question language.

What is SQL?

SQL is a website-specific language used to:

Retrieve facts from a database.

Insert, replace, and delete statistics.

Create and modify database structures (tables, indexes, perspectives).

Manage get entry to permissions and security.

Perform data analytics and reporting.

In easy phrases, SQL permits customers to speak with databases to shop and retrieve structured information.

Key Characteristics of SQL

Declarative Language: SQL focuses on what to do, now not the way to do it. For instance, whilst you write SELECT * FROM users, you don’t need to inform SQL the way to fetch the facts—it figures that out.

Standardized: SQL has been standardized through agencies like ANSI and ISO, with maximum database structures enforcing the core language and including their very own extensions.

Relational Model-Based: SQL is designed to work with tables (also called members of the family) in which records is organized in rows and columns.

Core Components of SQL

SQL may be damaged down into numerous predominant categories of instructions, each with unique functions.

1. Data Definition Language (DDL)

DDL commands are used to outline or modify the shape of database gadgets like tables, schemas, indexes, and so forth.

Common DDL commands:

CREATE: To create a brand new table or database.

ALTER:     To modify an present table (add or put off columns).

DROP: To delete a table or database.

TRUNCATE: To delete all rows from a table but preserve its shape.

Example:

sq.

Copy

Edit

CREATE TABLE personnel (

  id INT PRIMARY KEY,

  call VARCHAR(one hundred),

  income DECIMAL(10,2)

);

2. Data Manipulation Language (DML)

DML commands are used for statistics operations which include inserting, updating, or deleting information.

Common DML commands:

SELECT: Retrieve data from one or more tables.

INSERT: Add new records.

UPDATE: Modify existing statistics.

DELETE: Remove information.

Example:

square

Copy

Edit

INSERT INTO employees (id, name, earnings)

VALUES (1, 'Alice Johnson', 75000.00);

three. Data Query Language (DQL)

Some specialists separate SELECT from DML and treat it as its very own category: DQL.

Example:

square

Copy

Edit

SELECT name, income FROM personnel WHERE profits > 60000;

This command retrieves names and salaries of employees earning more than 60,000.

4. Data Control Language (DCL)

DCL instructions cope with permissions and access manage.

Common DCL instructions:

GRANT: Give get right of entry to to users.

REVOKE: Remove access.

Example:

square

Copy

Edit

GRANT SELECT, INSERT ON personnel TO john_doe;

five. Transaction Control Language (TCL)

TCL commands manage transactions to ensure data integrity.

Common TCL instructions:

BEGIN: Start a transaction.

COMMIT: Save changes.

ROLLBACK: Undo changes.

SAVEPOINT: Set a savepoint inside a transaction.

Example:

square

Copy

Edit

BEGIN;

UPDATE personnel SET earnings = income * 1.10;

COMMIT;

SQL Clauses and Syntax Elements

WHERE: Filters rows.

ORDER BY: Sorts effects.

GROUP BY: Groups rows sharing a assets.

HAVING: Filters companies.

JOIN: Combines rows from  or greater tables.

Example with JOIN:

square

Copy

Edit

SELECT personnel.Name, departments.Name

FROM personnel

JOIN departments ON personnel.Dept_id = departments.Identity;

Types of Joins in SQL

INNER JOIN: Returns statistics with matching values in each tables.

LEFT JOIN: Returns all statistics from the left table, and matched statistics from the right.

RIGHT JOIN: Opposite of LEFT JOIN.

FULL JOIN: Returns all records while there is a in shape in either desk.

SELF JOIN: Joins a table to itself.

Subqueries and Nested Queries

A subquery is a query inside any other query.

Example:

sq.

Copy

Edit

SELECT name FROM employees

WHERE earnings > (SELECT AVG(earnings) FROM personnel);

This reveals employees who earn above common earnings.

Functions in SQL

SQL includes built-in features for acting calculations and formatting:

Aggregate Functions: SUM(), AVG(), COUNT(), MAX(), MIN()

String Functions: UPPER(), LOWER(), CONCAT()

Date Functions: NOW(), CURDATE(), DATEADD()

Conversion Functions: CAST(), CONVERT()

Indexes in SQL

An index is used to hurry up searches.

Example:

sq.

Copy

Edit

CREATE INDEX idx_name ON employees(call);

Indexes help improve the performance of queries concerning massive information.

Views in SQL

A view is a digital desk created through a question.

Example:

square

Copy

Edit

CREATE VIEW high_earners AS

SELECT call, salary FROM employees WHERE earnings > 80000;

Views are beneficial for:

Security (disguise positive columns)

Simplifying complex queries

Reusability

Normalization in SQL

Normalization is the system of organizing facts to reduce redundancy. It entails breaking a database into multiple related tables and defining overseas keys to link them.

1NF: No repeating groups.

2NF: No partial dependency.

3NF: No transitive dependency.

SQL in Real-World Applications

Web Development: Most web apps use SQL to manipulate customers, periods, orders, and content.

Data Analysis: SQL is extensively used in information analytics systems like Power BI, Tableau, and even Excel (thru Power Query).

Finance and Banking: SQL handles transaction logs, audit trails, and reporting systems.

Healthcare: Managing patient statistics, remedy records, and billing.

Retail: Inventory systems, sales analysis, and consumer statistics.

Government and Research: For storing and querying massive datasets.

Popular SQL Database Systems

MySQL: Open-supply and extensively used in internet apps.

PostgreSQL: Advanced capabilities and standards compliance.

Oracle DB: Commercial, especially scalable, agency-degree.

SQL Server: Microsoft’s relational database.

SQLite: Lightweight, file-based database used in cellular and desktop apps.

Limitations of SQL

SQL can be verbose and complicated for positive operations.

Not perfect for unstructured information (NoSQL databases like MongoDB are better acceptable).

Vendor-unique extensions can reduce portability.

Java Programming Language Tutorial

Dot Net Programming Language

C ++ Online Compliers 

C Language Compliers 

[codingcorgi]

I am not dead just severely busy! Days 74-109. I have so much to talk about this time!

So at work (Can't show that due to NDA) I've been bug chasing, and ultimately having to restructure many classes and methods to make one function work as intended.

Then for my C# final I'm still working on my .Net Maui project I finished the journals implementation, and added the event reporting function. I added the events to the journal entry for the day. If there are no entries yet it makes one. I am going to be using the library of microcharts that were used in xamarin (before Xamarin got depreciated into .Net Maui) now it can be used for .Net Maui. I'll be capturing data gathered in the journals to display on graphs to track progress in sleep disorders. At a later time I'll be getting it set up to grab information from sleep tracking apps on mobile.

In C++ my final is to make a game. I am making an adventure game where you can explore a village. It has lore, Easter eggs, and fun imagery (it's a console game unfortunately can't do Unreal). I have to change the code a bit but it has been fun to code!

I might have a contract role coming up for another game studio, so that's exciting.

My plans for the next few days is to get some functionality on the statistics tab in my Maui app, and get my C++ project more put together. At work I'm waiting on the senior dev to plan out how to fix the massive problem we have.

[izicodes]

Zoey's YouTube! 🐝💗

Just wanted to promote @zoeythebee's videos she's made recently since I have been watching them and enjoying them! They're doing a series on programming a physics engine in the C programming language~!

Now I have zero knowledge of the C language but it's still cool for me to see her trying to code and explain what she's doing! I

If you haven't already, I highly recommend visiting @zoeythebee's profile and diving into their video series! ヽ(‘ ∇‘ )ノ

The video above is episode 1, here are the rest so far:

episode 2

episode 3

Have a nice day! 🐝🙌🏾💗