recentpopularlog in

racl101 : database   436

« earlier   later »
json - json_contains in MySQL 5.7.8 - Stack Overflow
Really useful bugfix for when you use JSON_CONTAINS clause and looking for a string value.
stackoverflow  howto  mysql  json_contains  json  database  string  troubleshoot  fix  example  guide  Reference 
september 2017 by racl101
php - Lumen HTTP Basic Authentication without use of database - Stack Overflow
Shows how to implement Basic Auth using custom Middleware, that doesn't require a Users database table to check against. Worked on Lumen 5.1
stackoverflow  lumen  http  basic  auth  user  database  less  no  lumen5.1  howto  example  guide  reference  middleware  custom 
september 2017 by racl101
Configuring multiple database connections in Lumen without facades | Andy Fleming
Really great tutorial showing howto set up multiple database connections in the Lumen framework. I've made this work for me using Lumen 5.1 and Lumen 5.4
blog  tutorial  guide  reference  documentation  howto  example  multiple  database  connections  lumen  framework  lumen5.1  lumen5.4  php 
september 2017 by racl101
Custom data pagination with Laravel 5 – psampaz.github.io
Really good tutorial on how to do custom database record pagination on Laravel 5. Works for Laravel 5.4.
blog  tutorial  howto  guide  reference  custom  database  record  pagination  laravel5  laravel5.4  example 
august 2017 by racl101
PHP: mysqli_connect - Manual
This is the PHP7 function to connect to a database.
php  mysqli  mysqli_connect  manual  guide  reference  documentation  tutorial  mysql  database  php7 
july 2017 by racl101
sql - MySQL -- join between tables in 2 different databases? - Stack Overflow
This might be useful for multitenant / multitenancy web app architectures with multiple databases.
stackoverflow  howto  example  mysql  join  table  different  databases  query  guide  reference  database  multitenancy  multitenant 
may 2017 by racl101
[5.4] SQL error when migrating tables · Issue #17508 · laravel/framework
Shows how to troubleshoot issue with Laravel 5.4 which the utf8mb4 character set by default but causes issues with older versions of MySQL.
github  laravel  laravel5  laravel5.4  issue  character  set  encoding  database  mysql  mysql5  howto  fix  troubleshoot  forum 
april 2017 by racl101
Multi Tenancy in Laravel 5
Nice blog tutorial explaining how to get started with single database, same schema multitenant architecture on Laravel 5.
laravel5  blog  tutorial  laravel  saas  multitenant  multitenancy  single  database  schema  explanation  guide  reference 
april 2017 by racl101
Laravel 5: simple multi-tenant/multi-site model setup (many-to-many relation covered as well) - Dev Problems
Nice blog tutorial explaining how to get started with single database, same schema multitenant architecture on Laravel 5.
laravel5  blog  tutorial  laravel  saas  multitenant  multitenancy  single  database  schema  explanation  guide  reference 
april 2017 by racl101
sql - Can MySQL reasonably perform queries on billions of rows? - Database Administrators Stack Exchange
Using this as justification for why I believe that even though Meritcore's databases are big, a few million rows shouldn't be a showstopper.
database  dba.stackexchange  stackexchange  guide  reference  advice  size  rows  millions  billions  performance  explanation  toread  tolearn  tounderstand  meritcore 
april 2017 by racl101
HipsterJazzbo/Landlord: A simple, single database multi-tenancy solution for Laravel 5.2+
This package facilitates same database same schema mult-tenancy / multi-tenant architecture.
github  package  library  database  web  app  multitenant  multi  tenant  same  schema  laravel  laravel5 
april 2017 by racl101
PSequel, a PostgreSQL GUI Tool for macOS
Looks like a good app for Mac OS X to view Postgres databases in
psql  macos  macosx  app  postgres  postgresql  database  totry 
march 2017 by racl101
How To Measure MySQL Query Performance with mysqlslap | DigitalOcean
Really good tutorial to explain the mysqlslap tool and how you can use to test loads on databases.
DigitalOcean  Tutorial  Blog  Howto  Measure  test  Load  performance  Database  Mysql  Mysqlslap  explanation  Guide  ReferencE  Toread  Tolearn  tounderstand  totry  Linux  centos  Server 
march 2017 by racl101
eloquent - Laravel: dynamic where clause with Elouquent - Stack Overflow
Note the part whee you can build a bare query with: $query = User::query(); For a model.
Guide  dynamic  query  Database  db  Stackoverflow  library  ReferencE  model  Howto  PHP  LAravel  example  Laravel5.2  Laravel5 
december 2016 by racl101
« earlier      later »
per page:    204080120160

Copy this bookmark:





to read