Level 13
These datatypes are the same. One is just an alias for another.
Apr 19, 2016
6
Level 2
Why use tinyInteger over boolean for migrations?
I noticed Taylor uses tinyInteger instead of boolean. Why would he not use the built in boolean?
As seen in create_users_table.php in Spark: $table->tinyInteger('uses_two_factor_auth')->default(0);
Level 48
Not all database types have a boolean type.
For example postgres has a boolean type but mysql and sqlite don't.
Because laravel needs to work with multiple database types it just uses an integer with 1 or 0 which is supported in all databases.
1 like
Level 2
But why not use Boolean? It looks cleaner and he built it after all.
Level 56
But why not use Boolean? It looks cleaner and he built it after all.
For example postgres has a boolean type but mysql and sqlite don't.
Level 50
I think @canfiax means 'Laravel has a boolean column type which is mapped to a tinyint on mysql, so why didn't Taylor use it?'. The answer being 'No idea - ask Taylor via twitter maybe' :-)
1 like
Level 65
@Prez Most of the time it's someone else :)
1 like
Please or to participate in this conversation.