teleren/devto huggingface dataset:
FETCH FIRST … ROWS WITH TIES
Tags: sql, postgres, analytics
Published: 2023-01-22 19:53:07

In this article, I want to show an innovative solution to a common problem. Find the records in the table with the maximum value in one of the columns.
For example, we will look for employees with the highest salary.

The standard solution is to find the maximum value in the salary column and then use that as a filter.

```
select * 
from employees
where salary = (select max(salary) from employees);
```
[try query on sqlize.online](https://sqlize.online/sql/psql13/d34f5217ccf4618b269061a6a6f7fe7c/)


However, the SQL:2008 standard offers a new solution to this problem: **FETCH FIRST … ROWS WITH TIES**

```
select * 
from employees
order by salary desc
fetch first 1 rows with ties;
```
With the same success, using the FETCH FIRST … ROWS WITH TIES construction, the problem of finding N maximum and minimum values ​​is easily solved, the solution of which in other ways is no longer so trivial

https://sqlize.online/sql/psql13/50703dc61c4b65b38ffaa338bbe7f683/
My attempt at creating a viral game.
Tags: gamedev, webdev, react, javascript
Published: 2023-01-22 19:16:39

The news of Wordle being acquired by the New York Times for over $1 million was not only a surprise, but also a revelation. It highlighted the fact that creating a viral game doesn't always require the backing of large corporations, large teams, or realistic graphics. Instead, it reminded me that simplicity and creativity can be just as effective in capturing the hearts and minds of players. This realization was not only motivational, but also sparked my desire to create a simple casual game of my own. I sat down and began to brainstorm ideas, taking into account my own limitations and skill-set.



### Concept
I find mathematics to be enjoyable, however, I struggle with mental math. I had the idea to create a game that would assist me in enhancing my mental computation skills. This game would be the perfect blend of fun and learning. I decided to name it [Exprn](https://exprn-game.netlify.app/), short for "Mathematical Expression".


### Tech stack 
I recently embarked on my journey of learning React Js. Though I had a grasp of the basics, I had not yet put it into practice through any projects. To strengthen my understanding and skills, I thought it would be a great opportunity to use React Js to develop a game.


### Game logic 
“Create a mathematical expression to match the generated number.” But the catch is you can't use a double digit number. You have 9 digits ‘1,2,3,4,5,6,7,8,9’ and four mathematical operators ‘+ , - ,* , / ' to create an expression that will equal the given number. As you progress through the game, it will generate larger numbers. Another catch is that you cannot erase or reset your move, so you must carefully place each number and operator.


### Build phase  
It took me approximately 5-6 hours to construct the game. The game's mechanics were relatively straightforward, making the development process relatively easy. However, I invested a considerable amount of time figuring out how to implement a restriction on the usage of single digits by the player. As it was my first time utilizing React Js in a project, the learning curve added to the duration of the development process.



Designing a game is more fulfilling than constructing a standard website. It encourages creativity and out-of-the-box thinking. Through the process of creating a game, I gained a deeper understanding of the core concepts of React Js. I highly recommend others in similar situations or those just starting out to also consider creating a game. While my game may not become a viral sensation, the most important thing is that I had a great time developing it.


I encourage you to give it a shot and let me know your highest score.

[Play](https://exprn-game.netlify.app/)
study with self-interest or own way
Published: 2023-01-22 19:40:54

namaskar and welcome to everyone🙏🙏.
What are the benefits of having a blog?
There are many benefits of having a blog, including:

Building an audience for your business or personal brand.
Share your ideas and thoughts with the world.
Connect with like-minded people and build relationships.
Drive traffic to your website or online store.
Build an audience for your products or services.
Stay up-to-date with the latest trends in your industry.
Position yourself as an expert in your field.
Generate leads for your business.
Build trust and credibility with your audience.
Build a community around your brand.
Athena Basics
Published: 2023-01-22 19:37:46

**_What is Athena?_**
 

1.   Interactive query service for analysis of data stored in S3
2.  Serverless avoiding setup of infrastructure
3.  Provides automatic scaling of data volume in queries
4.  Leverages column-based table creation for parallel processing
5.  Cloud based in-memory query system


**_Business Role for Athena_**
 

1.   User friendly query system for S3 data storage
2.  Central metadata store architecture like Hive
3.  Focuses on unstructured and semi-structured data stored in S3
4.  Common examples of queried data include JSON, CSV,
5. Apache Parquet, and Apache ORC large data files
6.  Emphasis is on large capture data files like weblogs, IOT, and other external data


**_Creating Tables in Athena_**


1. Athena creates tables using the Apache Hive Data Definition Language
2. Hive is an open-source Big Data toolset for analytics
3. Uses SQL compliant statements for table creation


**_Schema on Read_**


-  Verifies data organization when a query is issued
-  Provides much faster loading as structure is not validated
-  Multiple schemas serving different needs for the same data

-  Better option when the schema is not known at loading time


**_Parallel Processing of Queries_**


-    Parallel operations within an SQL Query
-  Concurrent users can access columns at the same time
-  Horizontal and vertical parallelization of a single query operation using multiple nodes


**_Governed Tables_**

-  Governed Tables are tables formed within a data lake created by AWS Lake Formation
-  Similar to Managed Tables in Hive
-  When a governed table is dropped the table definition in the metastore and the data file is deleted


**_Iceberg Table_**


-   An Iceberg Table is an Apache open format table designed to capture a large analytics dataset
-  Manages a large collection of files as a table
-  Iceberg tables must be associated with an AWS Glue catalog
-  Must be created using the Parquet format in AWS
-  Drop table deletes the meta store and data file


**_Summary_**

-  Athena is a serverless cloud based in-memory query service
-  Athena federated Query service
-  Uses a common metadata store architecture for table
- definitions
-  Uses common data stored in JSON, ORC, and Parquet formats
-  Uses standard SQL query language
-  Supports external, governed, and iceberg tables
QH88 | QH88 TODAY | Đăng ký nhận ngay 100K miễn phí
Published: 2023-01-22 19:13:06

QH88 | QH88 TODAY | Đăng ký nhận ngay 100K miễn phí
Nhà cái QH88  chính là sòng bài trực tuyến lớn nhất Châu Á hiện tại. Nhà cái đã được cấp phép và được ủy quyền hoạt động hợp pháp bởi tổ chức Philippine Amusement and Gaming Corporation (PAGCOR) uy tín tại Philippines được thành lập từ cuối năm 2012. Dù chỉ mới ra mắt và còn khá mới mẻ tại thị trường Việt Nam; nhưng nhà cái QH88 đã làm cho anh em cược thủ trong giới đứng ngồi không yên với kho tàng trò chơi online cực khủng.

Nhà cái QH88 chính là sòng bài trực tuyến lớn nhất Châu Á hiện tại. Nhà cái đã được cấp phép và được ủy quyền hoạt động hợp pháp bởi tổ chức Philippine
Website: https://qh88.today/
Điện thoại: 0912.999.999
Email: QH88today@gmail.com
Website: https://qh88.today
Tag : #QH88 #QH88today #nhà_cái_QH88
Địa chỉ: 68 P. Trần Phú, Điện Bàn, Ba Đình, Hà Nội, Việt Nam

XEM THÊM : https://qh88.today/ 
XEM THÊM : https://qh88.today/huong-dan-qh88/ 
XEM THÊM : https://qh88.today/soi-cau-xsmb/ 
XEM THÊM : https://qh88.today/xo-so/ 
XEM THÊM : https://qh88.today/casino/ 
XEM THÊM :  https://qh88.today/soi-cau-xsmn/ 
XEM THÊM : https://qh88.today/soi-cau-xsmt/ 
XEM THÊM : https://qh88.today/ban-ca/ 
XEM THÊM : https://qh88.today/the-thao/ 
XEM THÊM : https://qh88.today/game-slot/ 
XEM THÊM : https://qh88.today/da-ga/ 
XEM THÊM : https://qh88.today/khuyen-mai/ 
XEM THÊM : https://qh88.today/game-bai/ 
Tag : #QH88 #QH88today #nhà_cái_QH88
Why can't we have one definition for Component Props, Database Tables, and Validation?
Published: 2023-01-22 19:08:45

One pain point I often expierence is that we have so many repeat definitions for things. Tools like TRPC, ZOD, JSON Schema, AJV, TypeORM, and Prisma all pop up to solve a problem, but soon they collide with what each other are doing, and it's frustrating. I wish we had one way to define a 'schema' that did the following:

1. exports TypeScript types (ZOD does this brilliantly with input and output types **chef's kiss**)
2. defines a database schema
3. provides functions for validation (something that works both on the client, and server)

TypeORM comes closest to fulfilling all three requirements, but it comes with a lot of heft. The input/output types can be confusing, and I fear using decorators as they are not yet standardized.

Interestingly I just discovered [zod-prisma](https://www.npmjs.com/package/zod-prisma) which may be a good solution to my problems.
Why Popguard Chrome Extension is a Must-Have for Online Security
Published: 2023-01-22 19:02:55

In today's digital age, protecting yourself and your personal information online is more important than ever. With so many different websites and apps collecting data on us, it can be hard to keep track of who has access to our personal information. That's where **Popguard** Chrome Extension comes in. This powerful tool helps to keep you safe and secure online by blocking unwanted pop-ups and protecting your personal information.

[Popguard](shorturl.at/QRUZ5) Chrome Extension is a powerful tool that helps to keep you safe and secure online. One of its main features is the ability to block unwanted pop-ups and ads. This can be especially helpful when you're trying to focus on important tasks, such as completing a project or studying for an exam. Popguard blocks all unwanted pop-ups, ensuring that you can focus on the task at hand without being distracted by irrelevant ads.

Another great feature of Popguard is its ability to protect your personal information. When you use the extension, it automatically blocks trackers and cookies that can be used to collect data on you. This helps to keep your personal information safe and secure, and ensures that you're not being tracked or targeted by advertisers without your knowledge.

Overall, Popguard Chrome Extension is an essential tool for anyone who wants to stay safe and secure online. With its powerful pop-up blocking and personal information protection features, it's a must-have for anyone who wants to protect themselves and their data while using the internet.

Check Out Now!! [Click Here](shorturl.at/QRUZ5)
Check Out Now!! [Click Here](shorturl.at/QRUZ5)
Amazon Web Services
Tags: aws, amazon, amazonwebsevices
Published: 2023-01-22 18:36:36

Amazon is a leading e-commerce and technology company that offers a wide range of services to its customers. From online shopping and streaming to cloud computing and AI, Amazon has something for everyone.

One of the most popular services offered by Amazon is its e-commerce platform, Amazon.com. This platform allows customers to easily purchase a wide variety of products, including books, electronics, clothing, and more. Amazon also offers a subscription service called Amazon Prime, which provides customers with free two-day shipping, streaming of movies, TV shows and music, and other benefits.

Another popular service offered by Amazon is its streaming platform, Amazon Prime Video. This platform allows customers to stream a wide variety of movies, TV shows, and original content, such as the award-winning series "The Marvelous Mrs. Maisel" and "Transparent". The platform also offers a rental and purchase option for the latest movies and TV shows.

Amazon also offers a streaming service for music, called Amazon Music. The service provides access to millions of songs, albums and playlists, and also allows customers to upload their own music library. Amazon Music is integrated with Alexa, Amazon's AI assistant, which allows customers to play their favorite songs and playlists by voice commands.

In addition to its consumer services, Amazon offers a wide range of enterprise services through its Amazon Web Services (AWS) division. This includes cloud computing services, such as Elastic Compute Cloud (EC2) and Simple Storage Service (S3), as well as a variety of other services such as databases, analytics, and machine learning. These services are designed to help businesses of all sizes to easily scale and manage their IT infrastructure.

Amazon also offers a variety of other services, such as Amazon Fresh (grocery delivery service), Amazon Logistics (delivery service), and Amazon Web Services (cloud computing services for business).

In conclusion, Amazon offers a wide range of services to its customers, from e-commerce and streaming to cloud computing and AI. These services have made it easier for consumers and businesses to access the products and services they need, and have helped to make Amazon one of the most successful companies in the world. As Amazon continues to evolve and expand its offerings, it's likely that it will continue to shape the way we shop, watch, listen and work.
Space Tourism App
Tags: webdev, programming, react, typescript
Published: 2023-01-22 18:51:18

This is a challenge from frontend mentor
[**frontend mentor**](https://www.frontendmentor.io/)
[**_website_**](https://fanciful-axolotl-fa2e40.netlify.app/)
[**Code**](https://github.com/aaradj/space-tourism-wesite)

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/xxjnqlqdzf9jz1sxv8vn.jpg)
...Here goes our first post: Mastering Responsive Web Design(RWD)
Tags: seo, webdev, javascript
Published: 2023-01-22 18:34:52

Search engine optimization ([SEO](https://dev.to/gbengelebs/how-search-engines-work-finding-a-needle-in-a-haystack-4lnp)) is a critical aspect of digital marketing for financial institutions. It involves optimizing a website to rank higher in search engine results, which can drive more traffic to the site and ultimately lead to more conversions. One of the most important aspects of SEO is responsive web design.

Responsive web design (RWD) is an approach to web design that allows a website to adjust its layout and display content according to the size and type of device being used to access it. This approach is crucial for financial institutions, as more and more customers are using mobile devices to access financial services.

One of the main benefits of responsive web design for SEO in the financial sector is that it improves the user experience. Search engines, such as Google, prioritize websites that provide a good user experience, as they want to provide the best results for their users. By creating a seamless user experience across different devices, responsive web design can increase the likelihood that a customer will stay on the site and engage with the content. This, in turn, can improve the website's ranking in search engine results. 

[Responsive web design agency](https://www.techpax.co.uk/responsive-web-design) also makes it easier for search engines to crawl and index a website. Search engines use web crawlers to scan websites and index their content. However, if a website is not optimized for different devices, the crawlers may have difficulty accessing and understanding the content. Responsive web design ensures that the website is optimized for different devices, which can make it easier for the crawlers to scan and index the site.

Another way responsive web design can improve SEO in the financial sector is by reducing the risk of duplicate content. When a website is not optimized for different devices, it can create multiple versions of the same content, which can confuse search engines and lead to a lower ranking in search results. Responsive web design ensures that there is only one version of the content, which can improve the website's ranking in search results.

Responsive web design also improves the website's speed, which is another important factor for SEO. Search engines prioritize websites that load quickly, as they want to provide the best results for their users. Responsive web design ensures that the website is optimized for different devices and loads quickly, which can improve the website's ranking in search results.

In conclusion, responsive web design is essential for SEO in the financial sector. By creating a seamless user experience across different devices, improving the website's accessibility for web crawlers, reducing the risk of duplicate content, and improving website's speed, responsive web design can significantly improve the website's ranking in search engine results, which can drive more traffic to the site and ultimately lead to more conversions.
Certificate Viewer
Tags: webdev, javascript
Published: 2023-01-22 18:25:40

[View on GitHub](https://github.com/OutOfIdeasException/kenscertviewer)

I haven't been posting here a lot. I'd like to contribute more so I'll share projects here as I finish them. 

## Lessons Learned
- Most of the "head scratch" issues I ran into were due to minor typos. For example, a missed capital letter in my JavaScript reference to the HTML ID. "I swear this should work!" 
- I had an issue where the background was cutting off at the bottom. This was resolved by assigning `height: 100%` to the `HTML` element
- I had an issue with the `overflow-x` property as the scroll bar was not showing when I'd dummy values to the certificate selector area. I'm not 100% what resolved it, but after some research it appears that it is because the parent `div` was set to `display: grid`. I set the `grid-template-rows` attribute to `100%` and I believe this is what resolved the issue. 

I'm still new, but if anyone checks out the code and has any questions I'd love to discuss. Likewise, if anyone had any recommendations on how I could have optimized my code, I'm always open for suggestions.
Cryptopals challenge #48 solution
Tags: cryptopals, rust, rsa, bleichenbacher
Published: 2023-01-22 18:22:41

I couldn't find a solution in Rust when I wanted, so I decided to cover this.

This solution received absolutely no optimizations, so there are a lot of space for improvements.

It dates back to November and initial cleaned version have been lost, so I cleaned it again, now without #47 branch, and maybe forgetting some details, but everything important is there.

Also this challenge raised couple of question, which landed to [`crypto.stackexchange`](https://crypto.stackexchange.com/questions/102862/bleichenbacher-1998-million-message-attack-cca). Namely
* Why do we get intervals with their ends interchanged? And
* Why does it work to discard intervals in pairs?

If you have ideas to explain any of those, please put them to the comments or on the linked page.

If you find links and explanations in the code not clear enough you're always welcome to leave a comment here, or at the Gist page! https://gist.github.com/skaunov/3c6a5dc68c008bc4865adf720eb589a6#file-main-rs
{% embed https://gist.github.com/skaunov/3c6a5dc68c008bc4865adf720eb589a6 %}
Best Way To Prepare for Interviews: A Guide to Ace Your Next Job Interview
Published: 2023-01-22 18:16:30

Interviews can be nerve-wracking, especially if you're not fully prepared. However, with the right techniques and strategies, you can increase your chances of acing your next job interview. In this guide, we will discuss the best ways to prepare for interviews and give you the tools you need to succeed.


1. Research the Company: Before the interview, research the company and the position you're applying for. This will help you understand the company's values, mission, and culture, as well as the skills and qualifications required for the job. It will also give you a chance to prepare relevant answers to potential questions.

2. Practice Your Interview Skills: It's important to practice your interview skills to build your confidence and reduce anxiety. You can do this by practicing with a friend or family member, or by using online interview simulations.

3. Prepare Responses to Common Questions: Prepare answers to common interview questions such as "Why do you want this job?" and "What are your strengths and weaknesses?". Having a well-prepared answer to these questions can make a great impression on the interviewer.

4. Dress Professionally: Make sure you dress professionally for the interview. This will show the interviewer that you are serious about the job and that you respect the company's culture.

5. Prepare Questions to Ask: Come up with a list of questions to ask the interviewer. This shows that you're engaged and interested in the company and the position.

6. Follow Up: After the interview, follow up with a thank-you note or email to the interviewer. This shows that you're still interested in the position and it will make a good impression.

Conclusion:

By following these tips, you can increase your chances of acing your next job interview. Remember to stay calm, be confident, and show the interviewer that you're the best fit for the job. With the right preparation, you can make a great impression and land your dream job.
Lets build a Telegram bot using NodeJS
Tags: node, telegram, bot, automation
Published: 2023-01-22 18:00:00

To create a Telegram bot using Node.js, you will need to install the `node-telegram-bot-api` package. This package provides an easy-to-use interface for interacting with the Telegram Bot API.

Here is an example of a basic Telegram bot that can respond to messages:

```javascript
const TelegramBot = require('node-telegram-bot-api');

// replace with your own token
const token = 'YOUR_TOKEN';

const bot = new TelegramBot(token, {polling: true});

bot.on('message', (msg) => {
  const chatId = msg.chat.id;
  bot.sendMessage(chatId, 'Hello World!');
});
```

In this example, the bot will listen for incoming messages and respond with "Hello World!" when a message is received. The `polling: true` option tells the bot to use long polling to receive updates from Telegram.

You will need to replace `YOUR_TOKEN` with the token you received from the Bot Father after creating your bot.

You can also use commands to make the bot do specific things. For example, you can make the bot respond to the command '/start' like this:

```javascript
bot.onText(/\/start/, (msg) => {
  const chatId = msg.chat.id;
  bot.sendMessage(chatId, 'Welcome! How can I help you today?');
});
```
This is just a simple example, you can make your bot more complex by using more advanced features of the Telegram Bot API, such as sending photos, audio, etc.

Checkout the github [repo](https://github.com/muhammadabir64/telegram-bot-nodejs)
Auto Clicker Auto Fill
Tags: webdev, beginners, extension, javascript
Published: 2023-01-22 17:57:11

This is my first post about my software (browser extension) developed and maintained by me.

It’s [Auto Clicker Auto-Fill](https://getautoclicker.com)

It’s developed to do repeated task like form filling and clicking on web page.

I know it’s little complicate to start for new user to understand how to use same but once you get to use of it you will love it .

I’m also working on new feature which will help new user to configure page in just a single click. Will post about same in upcoming post.

Again this is my first post of my life so show your love and yes do let me know how I can improve my writing and software also if you have any input