Easy Database Forms For All

Features

• A Windows 32 Bit Version of this Package is also available in the Files Tab Above. Its name is forms.zip . This 32 Bit Version will have a default file / memory size limit of 2 GB.
• The Application Logins mentioned above will only work on the secure https connection and not on the insecure http connection.
• As this system is meant for local network usage, it uses a self-signed https certificate. Hence, browsers will throw a warning for the first time. Please accept the same and proceed ahead.
• Please save this webpage completely, for future and offline references.
• This is also a Quick LAMP / WAMP / MAMP / XAMPP ( x86 / x86_64 Bit ) Package for development, testing & production
• Thanks & Credits to the Adminer & AdminerEvo GitHub Teams, for providing the base for this project. If you like Adminer ( as i did ), you can support its development efforts, by contributing as a sponsor on their websites.
• Hope you find this software very useful in your day to day work. If you do, please give a Star Rating to it, so that others get to know about it.
• For those, who would like to learn the Easy English like Database SQL language commands fast, here is a download link for the same ( Open this link in a new tab ) : https://sourceforge.net/projects/easy-database-forms-for-all/files/Sample_sqlite_database_and_csv_files.zip/download
• While creating multiple tables for a neat data seggregation, you may consider creating foreign keys in them, to reference their source data tables
• Also, refer the screenshots of my other project, for an understanding of how data is normally seggregated into multiple tables and creating foreign keys between them, help in automatically generating and populating list boxes, while inputting records, here : https://sourceforge.net/projects/irbsystem/
• This package will consume about 2.5 GB of free memory. You can also follow this simple guide, for alloting more memory, to the MariaDB database server, for enhancing its performance ( open this link in new tab ) : https://sourceforge.net/projects/easy-database-forms-for-all/files/mysql_mariadb_performance_enhancements_guide.txt/download If needed, you can increase it even more, for the 64 Bit Version of this Software Package. If your organisation has more than 150 users, then set the max_connections variable, in the my.ini file's [mysqld] section, present in the mariadb folder, as shown in this forum article here : https://sourceforge.net/projects/easy-database-forms-for-all/files/MariaDB_max_connections.html/download After making any change to the my.ini file, stop and start the services, for it to take effect. if you plan to install this package on a normal PC ( as opposed to a server grade hardware ), then shutdown the PC at the end of the day, to avoid any memory corruptions creeping into the database.
• Here are some quick mysql / mariadb learning tutorials saved from the internet. Hope you find it useful. - https://sourceforge.net/projects/easy-database-forms-for-all/files/mysql_tutorials.zip/download Here is a list of supported data types in mysql / mariadb : https://sourceforge.net/projects/easy-database-forms-for-all/files/MySQL_MariaDB_Data_Types.html/download
• As discussed earlier, Creating Foreign keys also help immensely in maintaining uniformity of data input and prevents varied / spelling mistake prone data inputs. You can also have a combined field on the target table, which gets automatically populated, by creating a Trigger on the table. An example of a Trigger, before inserting any record ( Hint : Also, add a before updating trigger, similarly, with a different name ) as given in this forum article here : https://sourceforge.net/projects/easy-database-forms-for-all/files/mysql_-_how_to_create_trigger_to_do_concatenation_of_fields_-_Stack_Overflow.html/download Also, it is better to use : CREATE OR REPLACE TRIGGER instead of just CREATE TRIGGER in the above forum article example. It is also necessary, to create an index on the combined field, before creating a foreign key on any other source table, referring to it.
• A small correction in the sample_table created in the package : Sample_Name field's length is chosen as 255 instead of 25 characters.
• A copy of the installation video is also kept in the files tab of this website. Please refer the same, in case youtube is unavailable for some reason
• If any of your created tables, reach a million records count, then rename that table with _year or _quarter suffix and create a fresh table for better performance, for your users. You may create a view with UNION ALL of tables, for a combined report. Refer https://sourceforge.net/projects/easy-database-forms-for-all/files/MySQL_UNION_Operator.html/download
• Tags : Database Engines/Servers, HTTP Servers, Application Servers, Web Server, Database Server, PHP, MYSQL,MARIADB,APACHE,Free, Open Source, Form Creator / Generator / Builder / Tool, helpdesk, support, tasks-app, customer support, knowledge-base, php, mysql, teamwork, team, collaboration, forms, Web-forms, database, erp, hr, Accounting, Operations, Legal, data, collection, crm, business, management, school management, college management, company management, institution, library, sales, marketing, hrms, erp, enterprise, data center, Customer Service, Human Resources, Finance, IT, Compliance, Project Management, Excel, LibreOffice, OpenOffice, Online Spreadsheet, share, employee management, products, services, inventory management, manufacturing, technical support, production, goods, quality control, Information Technology, departments, company, industry, Infrastructure, Version Control, Media sharing, Wiki, Developer, Forum, CMS, eLearning, Bug Tracking, Analytics, Blog, Repository, Poll Management, Portal, Educational, LMS, Learning, Training, Library, Calendar, Student Information System (SIS), School Management System (SMS), School ERP, Task Management, Incident Management, Problem Management, Change Management, Asset Management, Service Request Management, SLA Management, Record, Register, Notes, Diary, Journal, Professional, Lawyers, Hospital, Patient, Client, Medical, Clinic, Pharmaceuticals, Shop, Store, Market, Boutique, Retail, Vendor, Supplier, Procure, Purchase, Workshop, Studio, Factory, Healthcare, Dentists, Optometrists, Therapists, Counselors, Consultants, Architects, Engineers, Dealerships, Real Estate Agents, Travel Agencies, Booking Services, Hardware, Electrical, Electronics, Utilities, Shipping, Delivery, Hospitality, Hotels, Airlines, Educational, University, Non-Profit Organizations, Charities, NGO, Salons, Fitness Centers, Gyms, transactions, payments, billing history, KYC, campaigns, promotions, loyalty programs, complaints, regulations, Contracts, agreements, Doctors, Nurses, Pharmacists, Designers, Developers, Scientists, Civil, Construction, Mechanical, Geologists, Research, Lab, Administrators, Analysts, Investment, Stockbrokers, Managers, Entrepreneurs, Consultants, Public Relations, Police, Military, Planning, Editors, Photographers, Call Center, Chefs, Cooks, Recipes, Staff, Coaches, Trainers, Computer Forms, PC Forms

Follow Easy Database Forms For All

Easy Database Forms For All Web Site