Best of SQLDecember 2022

  1. 1
    Article
    Avatar of phProduct Hunt·3y

    AI Query - Generate SQL Queries with AI in Seconds

    The fastest way for engineers to generate queries using basic English and let AI do the heavy lifting for you. With AI Query anyone can create efficient queries, without even knowing a thing about it. AI Query is not rated yet. This is AI Query's first launch.

  2. 2
    Article
    Avatar of gcgitconnected·3y

    Ultimate 10 Stages to Master Backend Development

    Backend development refers to server-side programming in which a developer creates application architecture and business logic to process and store the data and output useful information. There are multiple backend programming languages, frameworks, and stacks like JavaScript, Python, PHP, Java, Ruby, etc.

  3. 3
    Article
    Avatar of threedotslabsThree Dots Labs·3y

    The Go libraries that never failed us: 22 libraries you need to know

    Awesome Go contains over 2600 libraries, but popularity is not always the best indicator of library quality. It’s generally better to use libraries instead of frameworks for long-term projects. We’ve included some common anti-patterns to help you avoid making those mistakes.

  4. 4
    Article
    Avatar of sqlshackSQL Shack·3y

    5 Best Practices for writing SQL queries

    Queries are used to communicate with the databases and perform the database operations. We use the queries to update data on a database or retrieve data from the database. In addition to performing accurate database operations, a query also needs to be performance, fast and readable. Microsoft offers two different tools to develop queries.

  5. 5
    Article
    Avatar of supabaseSupabase·3y

    What's new in Postgres 15?

    The Postgres community released version 15 (stable) in October 2022. The permission model is more secure permission is revoked from all users except the database owner. It makes permission assigning more tunable ( details) Sorting rows of data is a frequent operation inside the Postgres code.

  6. 6
    Article
    Avatar of faunaFauna·3y

    Side-by-side comparison of serverless databases

    Serverless databases make it easy to build and scale your application because they abstract away the underlying infrastructure and automatically scale to meet the need of your application. With MongoDB, you don’t have to manage any infrastructure by yourself. This article compares commonly used serverless databases so you can make an informed decision.

  7. 7
    Article
    Avatar of phProduct Hunt·3y

    hubble - Github star manager

    The best of Product Hunt, everyday Web3 Keep up to date with the latest in web3 Community Discussions Ask questions, find support and connect Stories Tech news, interviews and tips from Makers Changelog Release notes from the Product Hunt team Office hours Give feedback directly to our product team Visit streaks.

  8. 8
    Article
    Avatar of supabaseSupabase·3y

    graphql v1.0

    pg_graphql is a Postgres extension that allows you to query your database using GraphQL. It is the foundation of GraphQL support in the Supabase stack. Since our first platform release, v0.2.1, the feature set of Postgres has steadily grown and stabilized.

  9. 9
    Article
    Avatar of glcGolang News·3y

    A Golang based SQL console for API queries

    The Steampipe community has grown a suite of plugins that map APIs to tables. The interactive query shell is one way you can query those tables. You can run queries on the command line and include them in scripts. Other commands run benchmarks, launch Steampipes as a service, and start the dashboard server.

  10. 10
    Article
    Avatar of towardsdevTowards Dev·3y

    ORM -The good and the bad things

    An ORM (Object Relation Mapper) is a piece of software dedicated to translating between the data representations in relational databases and the representation in memory used with object-oriented programming (OOP) The good - Helps to save time to write queries - Reduce development time - reduce development costs - Adds an abstract layer for the DB repository.

  11. 11
    Article
    Avatar of tuts_plusTuts+·3y

    Mapping Relational Databases and SQL to MongoDB

    MongoDB is an open source document-oriented NoSQL database which stores data in the form of JSON-like objects. This article will drive you to understand how the RDBMS/SQL domain, its functionalities, terms and query language map to MongoDB database. The article assumes that you are aware of the basic relational database concepts.

  12. 12
    Article
    Avatar of phProduct Hunt·3y

    NotifyLog - One stop tool for events tracking and analytics

    See what makers are currently building Collections Products curated by the community Time travel. Discover the best products by month. Check out the latest in web3 Community Discussions Ask questions, find support and connect Stories Tech news, interviews and tips from Makers Changelog Release notes.

  13. 13
    Article
    Avatar of freecodecampfreeCodeCamp·3y

    Database Normalization – Normal Forms 1nf 2nf 3nf Table Examples

    Database normalization entails organizing a database into several tables in order to reduce redundancy. You can design the database to follow any of the types of normalization such as 1NF, 2NF, and 3NF. In this article, we’ll look at what database normalization is in detail and its purpose.

  14. 14
    Article
    Avatar of hackernoonHacker Noon·3y

    6 Best SQL Programming Books Ranked by Reviews

    Each item on this list will be chosen based on their total number of reviews as well as their average rating. This book includes 57 problems at varying skill levels while providing online videos and programs that can be used while solving those problems. The book’s Amazon listing warns that used copies might not contain important resources.

  15. 15
    Article
    Avatar of communityCommunity Picks·3y

    Practical data engineering concepts and skills

    Data engineers are responsible for wrangling, manipulating, and streaming data to fuel insights and better decision-making. These skills are in high demand, so if you’re looking to make a career change and become a data engineer or develop your existing skill set, this is the article for you.

  16. 16
    Article
    Avatar of influxdbInfluxData·3y

    An Introduction to Apache Superset: An Open Source BI solution

    Apache Superset is based on a Dataset-Centric methodology, which lies firmly in the middle of a query-centric and semantic-centric architecture. In the dataset-centric approach, all charts are built from these datasets that contain a comprehensive collection of relevant dimensions and metrics.

  17. 17
    Article
    Avatar of systemweaknessSystem Weakness·3y

    Let’s Learn SQL - Learning Web-Sec - Day 1

    Let’s Learn SQL - Learning Web-Sec - Day 1 Getting Hands Dirty With SQL Caspar Camille Rubin on Unsplash Keep reading and I promise to teach you hours of what I learnt today in just a few minutes. Feel free to comment below about things that need a better explanation or if there's any type or mistake.