Search Results for "sql query"

sqlit is a keyboard-first terminal UI that lets you connect to, browse, and query SQL databases quickly without relying on heavyweight GUI clients. It positions itself as a “lazygit-style” experience for databases, aiming for fast startup, intuitive navigation, and developer-friendly workflows directly inside your terminal. The tool supports a wide range of database providers, so you can use one interface across local databases, remote servers, and cloud-hosted instances rather than juggling multiple clients. ...

BotSlayer is an application that helps track and detect potential manipulation of information spreading on Twitter. The tool is developed by the Observatory on Social Media at Indiana University --- the same lab that brought to you Botometer and Hoaxy. BotSlayer is not a tool to detect and remove likely social bots from your list of Twitter followers or friends. For that purpose, check out Botometer. If you just want to visualize the spread of some piece of information, consider Hoaxy....

...The project includes user registration and login, password hashing, profile editing, and avatar support, but it goes deeper by illustrating how to implement following/follower relationships, posting short messages, and displaying personalized feeds. It integrates SQL databases through SQLAlchemy and shows how to manage migrations, query optimization, and pagination for scalable content delivery. The app also includes unit and integration tests to reinforce test-driven development practices. Additional features such as full-text search, localization, email notifications, and deployment configurations are included or discussed to take developers beyond the basics.

SQLiv is a command-line security tool designed to identify SQL injection vulnerabilities in web applications through automated scanning techniques. Written primarily in Python, the project focuses on discovering potentially vulnerable web pages by analyzing URLs that contain database query parameters. It can perform large-scale scanning by using search engine queries known as SQL injection dorks to collect candidate websites and then test them for vulnerabilities. ...

Pony is an object-relational mapper. The most interesting feature of Pony is its ability to write queries to the database using generator expressions. Pony works with entities which are mapped to a SQL database. Using generator syntax for writing queries allows the user to formulate very eloquent queries. It increases the level of abstraction and allows a programmer to concentrate on the business logic of the application. Following is an example of a query in Pony: select(p for p in Product if p.name.startswith('A') and p.cost <= 1000) Pony translates queries to SQL using a specific database dialect. ...

A cgi program written in Python that turns HTTP GET and POST queries into SQL queries, runs them, turns the results into XML, and then returns the XML as the response to the HTTP query. It also supports returning a single BLOB as the whole response.

HTSQL is an HTTP access library to SQL databases, at http://htsql.org -- it is implemented with Python, and initially uses the PostgreSQL database. It has a do-as-you-please BSD style license for use with open source databases.