Daily Edition · Page 4

THE DAILY INDEX

Technology, AI, software, security, crypto and business

ARTICLES & TUTORIALS

TLDR Web Dev

SIMPLE WAYS TO FIND EXPOSED SENSITIVE INFORMATION

Search engine dorking is a technique that uses crafted queries to find specific types of sensitive information on the internet, such as leaked documents or API keys. Another way to discover sensitive data is through GitHub dorking, which searches for accidentally committed credentials or API keys in public repositories. Tools like PublicWWW can be used to search for API keys and other sensitive information on live websites, while tools like S3Scanner help find misconfigured cloud storage buckets that expose private data.

A BETTER WAY TO CODE: DOCUMENTATION DRIVEN DEVELOPMENT

Documentation-driven development (DDD) involves writing documentation before coding, which can help clarify project scope and API design. DDD can take many forms, such as design mockups, API reference docs, tickets, or even tests. It is not a "write once and done" process but rather an iterative cycle of refining both code and documentation. DDD can help identify potential issues in the design phase, saving time and resources in the long run.

THE PLAN-EXECUTE PATTERN

The plan-execute pattern is a design pattern used to separate the planning phase (decision-making) from the execution phase (actions) when developing software. It helps in testing the decision-making part and debugging by allowing inspection of the plan data structure. This pattern is commonly used in various areas, such as query planning in relational databases and interpreters. The execution phase can be further split into a state machine and a driver loop to handle uncertainties.

DEEP DIVE INTO HOW PINTEREST BUILT ITS TEXT-TO-SQL SOLUTION

Both WrenAI and Pinterest share their Text-to-SQL solutions and how they built them. WrenAI and Pinterest both innovate in Text-to-SQL with indexing and retrieval phases, though WrenAI distinguishes itself through a semantic engine and robust user interaction features, while Pinterest focuses on metadata-driven approaches and table summarization. WrenAI has semantic modeling and user feedback integration in its roadmap.

TLDR IndexPage 4