article thumbnail

User-defined Order in SQL (2018)

Hacker News

Re-ordering a todo list

SQL 139
article thumbnail

Is web3 data storage ushering in a new era of privacy?

Dataconomy

Thankfully, a new era is beginning to dawn, carried on the winds of change that gusted after the Cambridge Analytica scandal came to light in 2018. One game-changing innovation credited to SxT is Proof of SQL, an zk-SNARK that cryptographically validates the accuracy of SQL operations.

professionals

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

article thumbnail

The mystery of indexing – A guide to different types of indexes in Python

Data Science Dojo

Most Data Science enthusiasts know how to write queries and fetch data from SQL but find they may find the concept of indexing to be intimidating. In 2018, the old librarian asked an expert to create an index based on Book ID, assigned to each book at the time when it is stored in the library.

Python 368
article thumbnail

The journey of PGA TOUR’s generative AI virtual assistant, from concept to development to prototype

AWS Machine Learning Blog

We formulated a text-to-SQL approach where by a user’s natural language query is converted to a SQL statement using an LLM. The SQL is run by Amazon Athena to return the relevant data. Our final solution is a combination of these text-to-SQL and text-RAG approaches. The following table contains some example responses.

SQL 130
article thumbnail

Becoming A Data Scientist In 2020: Skills, Degrees, And Work Experience

Smart Data Collective

And that’s remained a consistent trend over the past two years (40% in 2018 and 43% in 2019). 74% of the cohort uses Python, 56% are proficient in R, and 51% have good command of SQL. In terms of popuarity, SQL has grown by 40% since 2019 (36%), thus moving closer to R. Coding Languages. Conclusion.

article thumbnail

Generative AI and multi-modal agents in AWS: The key to unlocking new value in financial markets

AWS Machine Learning Blog

For structured data, the agent uses the SQL Connector and SQLAlchemy to analyze databases, which includes Amazon Athena. It generates a SQL query using an LLM based on the question and queries the Athena database. The financial analyst asks the following question: “ What are the closing prices of stocks AAAA, WWW, DDD in year 2018?

AWS 130
article thumbnail

How to use Netezza Performance Server query data in Amazon Simple Storage Service (S3)

IBM Journey to AI blog

This data will be analyzed using Netezza SQL and Python code to determine if the flight delays for the first half of 2022 have increased over flight delays compared to earlier periods of time within the current data (January 2019 – December 2021). Figure 7 – Initial query using the historical data (2003 – 2018).