Search Results for "sql sorting queries"

Kysely (pronounce “Key-Seh-Lee”) is a type-safe and autocompletion-friendly typescript SQL query builder. Inspired by knex. Mainly developed for node.js but also runs on deno and in the browser. Kysely makes sure you only refer to tables and columns that are visible to the part of the query you're writing. The result type only has the selected columns with correct types and aliases. As an added bonus you get autocompletion for all that stuff. As shown in the gif above, through the pure magic...

...nuBuilder uses either MySQL or MariaDB databases and gives its users the ability to do database operations like... • Search, Create, Insert, Read, Update, Delete ✪ With low-code tools that create ... - Forms with the Form Builder - Fast Reports - Database queries with the SQL Builder - Customised date and number formats with the Format Builder - Calculated fields with the Formula Builder - Email Templates - Move and resize objects. - Further customisation that can be done with JavaScript and PHP. ✪ nuBuilder stores all forms, reports, company data and PHP/JavaScript code in MySQL. ...

DataAdapter - Java library to work with Oracle and PostgreSQL database. This library simplifies the work of loading, creating or editing database data, as opposed to working directly with JDBC. In a few lines of code, you get objects relay database table with fields. Object Types fields correspond to types of database table fields. Here you will find similarities with familiar to you ActiveRecord.

Find this useful tool to run scripts or extracting inserts from a table on MSSQL. Query execution runs each query separate, that is separated with a ";". The reason for this is because Views and Procedure creation expects to be executed separate from other queries which resulted in me having to run several queries 1 by 1 and thus resulted in me creating this tool. Insert script creation can happen from a conditional query.

Osezno Framework PHP is a framework written in PHP that allows you to: Set HTML templates, tabbed contents, forms, dynamic list. All on a MVC pattern, and incorporate technologies such as active record and xajax.

Github repository: https://github.com/miguelaxcar/PHP-MSSQL-Server-Admin Web based tool written in PHP by Luiz Miguel Axcar to build and run queries on a remote or local MSSQL (Microsoft SQL Server). Support for SQL code highlight (!), table browser, field browser, TOP records, most used tables, CSV results export, etc. Most tested in SQL 2000 version. If you find some issue ther let me know and I help you fixing it.

An Ant task for generating property files with testsets based on the results of SQL queries and validation plug-ins. Very usefull when building unit tests that make use of changing datasets.

PURPOSE: reporting, content-management. easy to use GUI-frontend for the popluar java build-tool 'ANT'. looks like a 'wizard'. additional ant-taskdefs for processing SQL(JDBC)->XML->XSLT->HTML. 'sql2xml' allowes nested queries (for 1:n-relationships)