Change SQL Server into an Application Server with "TSQL.APP"

T-SQL dot app: A Revolutionary Approach to Web Application Development

Introduction

T-SQL dot app is an innovative skeleton web application with a built-in Integrated Development Environment (IDE), designed to work entirely data-driven based on T-SQL, Microsoft SQL Server's programming language. The platform enables developers to build complete web applications by writing T-SQL code exclusively, eliminating the need to master multiple programming languages and frameworks.

Here you can listen to the podcast that will give you a complete picture of the unique power of our TSQL.APP framework in just 10 minutes.

---

Listen to the Podcast here

What is T-SQL dot app?

Core Features

• Fully Data-driven Development: All application logic and user interfaces are defined within the database, enabling direct and efficient data access.
• Built-in IDE with Monaco Editor: Write, test, and debug T-SQL code directly in the browser with advanced coding features like syntax highlighting and code auto-completion.
• Data-driven React Client: A fully functional frontend built with React, automatically generated based on data and T-SQL code.
• Comprehensive Functionality: Built-in support for authentication, authorization, role management, server-side processing, task processing, mail server, FTP, and file management.
• Rich Set of Stored Procedures and Functions: Over 400 built-in procedures and functions capable of fulfilling virtually any business need via action code.
• Custom GPT Support: A custom-trained GPT model helps developers generate action code and provides support within the platform, accessible via https://t-sql.app.

What can T-SQL dot app be used for?

1. Business Applications

• Enterprise Resource Planning (ERP): Manage business processes such as purchasing, sales, inventory management, and finance within one integrated system.
• Customer Relationship Management (CRM): Manage customer data, interactions, and sales opportunities to improve customer relationships.
• Inventory Management: Real-time tracking of inventory levels, orders, and deliveries for efficient supply chain management.

2. Data Analysis and Reporting

• Internal Dashboards: Create interactive dashboards for real-time monitoring of business performance.
• Reporting Tools: Generate custom reports and visualizations directly from the database without additional BI tools.

3. Automation and Workflow

• Task Automation: Automate repetitive tasks and processes with the built-in task server.
• Workflow Management: Define and manage business processes to promote efficiency and consistency.

4. Industry-Specific Solutions

• Produce Trading Sector: Proven applications in the potato, vegetable, and fruit sector, with successful implementations at large companies.
• Logistics and Transport: Management of complex logistic processes, including route planning and tracking.

5. Internal Tools and Utilities

• File Management: Manage documents and files with built-in FTP and file manager functionality.
• User and Role Management: Manage user accounts, roles, and access rights for enhanced security.

Why is T-SQL dot app a Game Changer?

1. Simplicity and Efficiency

• Single Language Development: Both frontend and backend can be developed using only T-SQL, reducing the learning curve and development time.
• Faster Implementation: By eliminating the need for multiple technologies, applications can be developed and deployed more quickly.

2. Cost Savings

• Lower Development and Maintenance Costs: Less dependency on different technologies leads to reduced overhead and lower costs.
• Resource Efficiency: Centralization of development within the database reduces the need for additional infrastructure.

3. Complete Data Control

• Direct Data Access: All logic is executed within the database, ensuring fast and efficient data and transaction processes.
• Enhanced Security: Managing data and application logic within one environment strengthens security and simplifies regulatory compliance.

4. Extensive Out-of-the-Box Functionality

• Built-in Business Functions: Features such as authentication, authorization, mail server, and task processing are available by default.
• Data-driven UI Generation: User interfaces are automatically generated based on data and T-SQL code, promoting consistency and efficiency.

5. Proven Success in Practice

• Large Enterprise Implementations: Multiple large companies in the Dutch produce trading sector use T-SQL dot app, processing hundreds of thousands of transactions and realizing annual revenue exceeding 200 million euros.
• Scalability and Reliability: The platform has proven capable of handling large volumes and critical business processes.

6. Innovative Approach to Application Development

• Custom GPT Support: The custom-trained GPT model assists developers in writing code, increasing productivity.
• Development Centralization: Managing both frontend and backend within the database significantly reduces development process complexity.

Looking for Collaboration and Further Development

T-SQL dot app has proven its value and is now poised to grow further and transform the market. To achieve this, we are looking for interested parties who want to contribute to the further development and commercialization of this groundbreaking technology.

Potential Collaboration Areas

• Technical Development: Contribute to expanding functionality, optimizing performance, and improving user experience.
• Commercial Exploitation: Develop business models for offering T-SQL dot app as a commercial product or service.
• Implementation Partners: Companies wanting to integrate T-SQL dot app into their own infrastructure or provide solutions to their customers.
• Support and Training: Provide services such as technical support, training, and consultancy to stimulate the use and adoption of T-SQL dot app.

Why Join?

• Innovation Leadership Role: Participate in the forefront of technological innovation in web application development.
• Market Potential: Benefit from a growing need for efficient and cost-effective development solutions.
• Collaboration with Experienced Teams: Work with experts who have already achieved success with T-SQL dot app in critical business environments.
• Industry Impact: Help redefine industry standards and best practices.

Conclusion

T-SQL dot app is more than a tool; it's a revolution in how web applications are developed and deployed. By harnessing the power of T-SQL and centralizing development within the database, the platform offers unparalleled efficiency, scalability, and cost savings.

With proven successes at large companies and a wide range of applications, T-SQL dot app is ready to transform the market. We invite you to be part of this exciting journey and help shape the future of application development together.

Interested?

Contact us today to discover how you can contribute to and benefit from the growth and opportunities that T-SQL dot app has to offer.

Contact Details:

• Website: https://t-sql.app
• Email: [e-mail]
• Address: [Add physical address if desired]

Together we can redefine the future of web application development with T-SQL dot app as a catalyst for change.

/*
We have built it. Technically it is a data-driven stack containing MICROSOFT SQL SERVER, .NET, NODE AND REACT, But we have made it completely data-driven, so the ONLY language you have to use is T-SQL. For everything, UI Modal Dialogs CRUD apps, functions, actions, reports. like so:
*/

-- learn from the TSQL.APP Assistent at https://tsql.app
EXEC sp_api_modal_text @text=N'TSQL.APP Choose Example',@class='h2'
DECLARE @var01 
        NVARCHAR(MAX); EXEC sp_api_modal_get_value @name='@var01', @value=@var01 OUT;   
DECLARE @selected_ids nvarchar(128)
DECLARE @T nvarchar(max)

DECLARE @switch_1 nvarchar(max); EXEC sp_api_modal_get_value @name='@switch_1',@value = @switch_1 OUT 
EXEC sp_api_modal_switch @name = '@switch_1', @value = @switch_1 OUT,@label = N'Single / Multi', @direct_post = 1
DECLARE @multi bit = case when isnull(@switch_1,'false')='false' then 0 else 1 end

DECLARE @switch_2 nvarchar(max); EXEC sp_api_modal_get_value @name='@switch_2',@value = @switch_2 OUT 
EXEC sp_api_modal_switch @name = '@switch_2', @value = @switch_2 OUT,@label = N'List / Table', @direct_post = 1
DECLARE @use_table bit = case when isnull(@switch_2,'false')='false' then 0 else 1 end

--exit button (action ends)
DECLARE @exit nvarchar(max); EXEC sp_api_modal_get_value @name='@exit',@value = @exit OUT 
EXEC sp_api_modal_button @name='@exit',@value = 'Exit', @valueout = @exit OUT,@class='btn-danger',@key='Esc'
IF @exit is not NULL
BEGIN
    EXEC sp_api_modal_clear
END 
--prepare table and list
SELECT top 10 id=id, name=name, selected=0  INTO #tmptable FROM api_card order by id DESC
DECLARE @list nvarchar(128)=N'A,B,C,D'

if @use_table =0 -- gebruik dan de list !
BEGIN
    EXEC sp_api_modal_choose 
        @list = @list,
        @value = @var01 OUT 
        --,@name = '@button_choose'
        --,@class = 'btn-outline-danger'
        --,@class_updated = 'btn-danger'
        --,@startkey = 1 -- 0 = no keys or NULL = first character of text
        --,@keyprefix = 'F'
        ,@multi = @multi --1 --allow multiple values
        --,@tmptable = '#tmptable'
        --,@ids =@selected_ids OUT
        --,@orderby = 'ORDER BY name'
        --,@inline = 1
        --,@reducer = NULL
        --,@reset_values = N'@button,lastname,etc' -- onchange, reset other values
    SET @T=concat('selected: ',@var01)
    EXEC sp_api_modal_text @T
END

if @use_table =1 -- gebruik dan de table
BEGIN
    EXEC sp_api_modal_choose 
        --@list = @list,
        @value = @var01 OUT 
        --,@name = '@button_choose'
        --,@class = 'btn-outline-danger'
        --,@class_updated = 'btn-danger'
        --,@startkey = 1 -- 0 = no keys or NULL = first character of text
        --,@keyprefix = 'F'
        ,@multi = @multi --1 --allow multiple values
        ,@tmptable = '#tmptable'
        --,@ids =@selected_ids OUT
        --,@orderby = 'ORDER BY name'
        --,@inline = 1
        --,@reducer = NULL
        --,@reset_values = N'@button,lastname,etc' -- onchange, reset other values
    SET @T=concat('selected: ',@var01)
    EXEC sp_api_modal_text @T   
    EXEC sp_api_modal_table @tmptable=N'#tmptable'
END

-- Add 'Quit' button
exec sp_api_modal_text N'click Quit/Exit button to end the action.'
DECLARE @ButtonQuit nvarchar(128)
EXEC sp_api_modal_get_value @name='@ButtonQuit', @value=@ButtonQuit OUT;
EXEC sp_api_modal_button 
    @name='quit',
    @value='Quit this Action', 
    @class='btn-secondary', 
    @valueout=@ButtonQuit OUT;

IF @ButtonQuit IS NOT NULL
BEGIN
    --SET @Quit = 1;
    EXEC sp_api_modal_clear;
    RETURN;
END