PHP download

Download the PHP package max13/laravel-sqfix without Composer

On this page you can find all versions of the php package max13/laravel-sqfix. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.

Table of contents
Download max13/laravel-sqfix
More information about max13/laravel-sqfix
Files in max13/laravel-sqfix

Vendor max13
Package laravel-sqfix
Short Description Laravel package fixing SQLite Schema grammar
License MIT
Homepage https://github.com/max13/laravel-sqfix

Keywords max13 laravel-sqfix

FAQ

After the download, you have to make one include require_once('vendor/autoload.php');. After that you have to import the classes with use statements.

Example:

If you use only one package a project is not needed. But if you use more then one package, without a project it is not possible to import the classes with use statements.

In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.

Some PHP packages are not free to download and because of that hosted in private repositories. In this case some credentials are needed to access such packages. Please use the auth.json textarea to insert credentials, if a package is coming from a private repository. You can look here for more information.

Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
To use Composer is sometimes complicated. Especially for beginners.
Composer needs much resources. Sometimes they are not available on a simple webspace.
If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.

Please rate this library. Is it a good library?

Example code of max13/laravel-sqfix

Informations about the package laravel-sqfix

Laravel package fixing SQLite Schema grammar

SQLite has many quirks, some of them are bugs and stayed like this because of legacy code, bugs that became features, etc… See the complete list on their website:

ROWIDs: Every table (except explicitely created WITHOUT ROWID) have a 64-bit signed integer column named rowid. This column has the same attributes expected for a PRIMARY KEY (starts at 1, is an INTEGER, is UNIQUE across the table, and is usually incremented by 1 on every insert), and can reuse (in certain condition) previously deleted rowids. Only the exact type (case insensitive) INTEGER PRIMARY KEY will make a column an alias of rowid. Which is recommended in most cases.
AUTOINCREMENT: When this keyword is used, it will use a different algorithm for rowid, briefly, an AUTOINCREMENT will make SQLite create an table used to track the increments (sqlite_sequence), rowids are guaranteed to be increasing and never reused. The AUTOINCREMENT keyword imposes extra CPU, memory, disk space, and disk I/O overhead and should be avoided if not strictly needed. It is usually not needed.

This package replaces the default optimized behavior advised by SQLite and will have no effect on other drivers. Laravel’s ids are automatically created as aliases of rowid, and the ->trueSyntax() modifier will use the "unfixed" SQL grammar.

Installation

You can install the package via composer:

That’s it!

Usage

The normal behavior of Laravel is to define the table jobs with the following statement:

Which will both create a column named id distinct from rowid with the same properties. Double the work.

This package is making Laravel produce the following table:

Optimisation max.

Testing

Contributing

Please see CONTRIBUTING for details.

Credits

Adnan RIHAN

License

The MIT License (MIT). Please see License File for more information.

All versions of laravel-sqfix with dependencies

PHP Build Version

Package Version

Version 1.3.2 Release 09. Jan 2025
create-project require 0 people chose require and
0 people chose create-project.

Download

Download latest version of laravel-sqfix from vendor max13

Requires php Version ^7.3|^8.0
illuminate/contracts Version ^7.0|^8.0|^9.0|^10.0|^11.0

Composer command for our command line client (download client) This client runs in each environment. You don't need a specific PHP version etc. The first 20 API calls are free. Standard composer command

The package max13/laravel-sqfix contains the following files

Loading the files please wait ....