racl101 + database   471

DB Browser for SQLite
Pretty good app actually. Use it to open sqlite .db or .sqlite files. Works on MacOS High Sierra as of March 20, 2019. You can even run SQL queries on it.
sqlite  sqlite3  browser  app  macos  client  database  program  macosx 
27 days ago by racl101
spatie/laravel-permission: Associate users with roles and permissions
This pretty much does the job that Zizaco Entrust used to do but doesn't require Redis to be installed and is still being maintained.
github  laravel  permission  library  package  roles  permissions  laravel5  user  database  models  guide  reference  documentation  howto  example  tutorial 
8 weeks ago by racl101
Backup (mysql dump) all your MySQL databases in separate files - Running with Ruby
Really good, simple to understand Bash shell script demonstrating how to backup all the databases in a given mysql server installation into a single file or into separate files (one for each database).
blog  tutorial  howto  example  guide  reference  backup  export  database  dump  sql  files  shell  script  single  separate  mysql  bash 
november 2018 by racl101
Script to open a mysql database in Sequel Pro from a service in docker-compose.
A gist of an Bash Shell Script to open up Sequel Pro MacOS / MacOS X app with credentials to view a MySQL database running within a Docker container.
github  gist  script  bash  shell  open  sequel  pro  sequelpro  database  mysql  docker  container  credentials  totry  guide  reference 
october 2018 by racl101
Connecting to a mysql running on a Docker container · Issue #95 · docker-library/mysql
Frankly, this forum page has no consensus on a solution to this issue. Nevertheless, what worked for me on my set up with running MacOS as the Docker host and running a container with: Ubuntu 16.04 and MySQL 5.7 is the following:

1) Within the container: change in /etc/mysql/mysql.conf.d/mysqld.cnf the bind-address option from to
2) Restart MySQL server (note that whenever you start MySQL you must use this command in the Dockerfile:

RUN sed -i -e"s/^bind-address\s*=\s* =" /etc/mysql/mysql.conf.d/mysqld.cnf
RUN find /var/lib/mysql -type f -exec touch {} \; && service mysql start

That is, you must touch the files in /var/lib/mysql and then start the server with service command and not systemctl.

Next, create a user separate from root e.g. dev_1, in MySQL and given them privileges to their '' and '%' hosts. Like this in the Dockerfile:

RUN find /var/lib/mysql -type f -exec touch {} \; && service mysql start && mysql -uroot -proot mysql -e "GRANT ALL ON *.* TO root@'' IDENTIFIED BY 'secret' WITH GRANT OPTION; CREATE USER 'dev_1'@'' IDENTIFIED BY 'secret'; GRANT ALL ON *.* TO 'dev_1'@'' IDENTIFIED BY 'secret' WITH GRANT OPTION; GRANT ALL ON *.* TO 'dev_1'@'%' IDENTIFIED BY 'secret' WITH GRANT OPTION; FLUSH PRIVILEGES;"

Then when you start the container you must publish the port number like so:

docker run -t -d -p 4406:3306 ubuntu_16_04_lemp_php_7_2:latest

If your container stops prematurely, then you might want to add a CMD line in your docker file to run a start.sh script and within that script you might want to add something like this:

# stupid hack to keep container from being stopped
tail -f /dev/null

Finally, to connect to your DB instance on your local MacOS machine with an app like Sequel Pro for example, use the following credentials:

Username: dev_1
Password: <dev_1_password>
Port: 4406

If you don't like to use port 4406, try 3307, 3308, 3309.
github  forum  howto  example  troubleshoot  mysql  server  docker  host  connection  issue  sequel  pro  mariadb  client  hostname  docker-machine  ip  address  ipaddress  guide  reference  toread  tolearn  totry  tounderstand  image  port  detached  database  credentials 
october 2018 by racl101
SQLAlchemy Documentation — SQLAlchemy 1.2 Documentation
Seems that the key to learning to work with databases in Python requires understanding SQL Alchemy.
documentation  guide  reference  sqlalchemy  python  database  toolkit  driver  orm  relational  engine  mysql  sqlite3  tutorial  howto  example  resource 
september 2018 by racl101
php - belongsToMany relationship in Laravel across multiple databases - Stack Overflow
Someone figured out how to do a relationship column / property between two models (with pivot table), i.e. belongsToMany where the second model might have a dynamic database connection (i.e. it's not the same each time a query is done). So they figured out howto obtain the database for the current database connection (i.e. the current PHP script execution).
stackoverflow  laravel  laravel5  howto  belongstomany  model  relationship  property  column  between  different  database  connections  example  guide  reference  pivot  table 
may 2018 by racl101
Update Amazon RDS max_connections with Parameter Group · Issue #16 · jollygoodcode/jollygoodcode.github.io
This thread discussion might provide some insight into manually increasing the mysql max_connections option / setting manually and overriding Amazon's AWS "sensible" defaults.
github  forum  aws  amazon  howto  override  change  mysql  database  db  option  variable  max_connections  setting  totry  example  guide  reference 
april 2018 by racl101
Welcome to PyMySQL’s documentation! — PyMySQL 0.7.2 documentation
The documentation is kind of sparse, but it has some good reference links. That's where the meat is.
python  library  pymysql  module  database  mysql  query  api  guide  reference  documentation 
march 2018 by racl101
« earlier      
per page:    204080120160

related tags

access  account  accounts  actionscript  active  activerecord  add  addon  address  admin  administration  administrator  advanced  advancedwhere  advice  aggregate  aggregated  Airtable  algorithms  all  all-in-one  allocation  alter  amazon  amazonlinux  amazonlinux2  And  android  anonymous  ansible  apache  api  app  apple  application  apply  apps  apt  apt-get  architecture  Array  artisan  askubuntu  assignment  asterik  auth  authentication  automation  auto_increment  auto_increment_increment  availability  average  awesome  aws  backend  backup  bar  base2  bash  basic  batch  beginner  belongstomany  best  bestpractice  bestpractices  between  bigint  billions  binary  bitnami  blob  blog  blogging  boxfile  brew  browser  buider  builder  buttons  by  byte  bytes  calculate  canada  cannot  capistrano  cascade  cassandra  casting  catch  centos  certificate  chaching  chaIn  change  changes  character  characters  charactersets  charset  cheatsheet  check  class  clause  cleanup  cli  client  cloud  cloudsites  cms  code  codeigniter  Codetutus  codex  collation  collations  column  columns  comma  command  commandline  commands  comments  comparison  Composer  compromised  config  configuration  connect  connection  connections  cons  console  constraint  container  content  convert  converter  cookies  copy  count  create  created  Createdb  created_at  Createuser  credentials  cron  cronjob  crow  crowfoot  cspan  csv  culttt  curated  currency  current  cursor  custom  custom-post-type  customer  customfields  customizer  cyberciti  data  data-validation  database  Database-Deployment  database.com  databases  dataframe  datatables  datatypes  date  dates  datetime  david-walsh  db  db:migrate  dba  dba.stackexchange  dbadmin  dbconsole  dbd  dbdeploy  dbi  debian  debug  debugger  decimal  default  definition  delete  dependencies  dependency  deploy  deployment  description  design  detached  dev  development  diff  difference  differences  different  digitalocean  disable  distinct  distributed  docker  docker-machine  doctrine  documentation  documents  documetntation  domain  double  dreamhost  driver  drop  dropdb  dsl  dump  duplicate  dynamic  dzone  each  eager  ec2  ecommerce  edit  edraw  ee2  eer  eloquent  emulation  enable  encoding  encryption  encyclopedia  endpoint  engine  entity  entries  entry  environment  erm  error  escape  example  examples  excel  exception  execute  expired  explanation  export  expressionengine  extension  external  extra  ezsql  fail  failure  Fiddle  field  fields  fielmaker  file  filemaker  filemakerpro  files  filetype:png  filtering  finances  financial  find  first  fix  float  floatingpoint  foot  for  force  foreign  foreignkey  form  format  formatting  forms  forum  forwarding  frame  framework  free  from  FTP  fuelphp  fulltext  function  functions  gdpr  gem  gems  generator  get  gettingstarted  gist  Git  github  give  gotcha  gotchas  government  grant  grants  graphic  gravityforms  greater  grep  group  groupby  grouped  Grouping  gui  guide  hack  hacked  hack_file  handles  handling  hard  hasmany  having  help.ubuntu  heroku  hierarchical  Homebrew  homestead  hook  host  hosting  hostname  howto  howtoforge  html  http  id  identifier  image  imporant  import  IN  including  incorrect  increase  increment  index  indexes  INex  inner  innodb  inspect  install  installation  instance  instances  int  integer  interesting  interview  into  invoice  ip  ipaddress  is  issue  java  javascript  join  jquery  js  json  json_contains  justin-tadlock  justinvincent  kb  key  keys  kill  knowledgebase  lamp  laracasts  laravel  laravel4  laravel5  Laravel5.1  laravel5.2  laravel5.3  laravel5.4  large  last  learning  left  legacy  length  less  library  lightsail  like  limit  limits  line  linux  list  literacy  Load  loading  local  location  lock  log  logging  login  logout  long  lookup  lost  lower  lowercase  lumen  lumen5.1  lumen5.4  mac  machine  macos  macosx  macports  management  manual  manually  many  manytomany  mariadb  mass  massassignment  master  matching  MAth  matrix  max  maximum  max_connection  max_connections  Measure  media:image  mediatemple  mediumint  memory  meritcore  methods  microsoft  middleware  migrate  migration  migrations  millions  min  minimum  mistakes  mobile  model  modeling  models  module  money  monitoring  move  movie  msdn  msyql  mtmw  multi  multibyte  multiple  multitanancy  multitenancy  multitenant  music  mutators  My.cnf  Myisam  mysql  mysql.sock  mysql5  mysql5.7  mysqladmin  mysqldump  mysqli  mysqli_connect  Mysqli_ssl_set  Mysqlslap  mysql_db_query  name  names  namespaces  navidat  nested  nettuts  new  newest  nixcraft  no  non-aggregated  non-compound  normalization  nosql  not  notation  notifications  null  number  numbers  numeric  nvarchar  obfuscate  object  objectrelationalmapping  objects  occurrences  odbc  offset  oldest  ondelete  onupdate  oop  open  opensource  open_files_limit  optimization  optimize  option  options  or  oracle  order  orderby  orm  ormlite  orphan  orwherein  osx  output  outside  override  overrun  package  packagist  paginate  pagination  paginator  pagodabox  pagodaboxv2  paid  pandas  parent  passport  password  path  pattern  patterns  pdo  pear  peer  peewee  percentage  performance  perl  permission  permissions  pg  pg_dump  pg_restore  phing  php  php7  phpbuilder  phpmyadmin  phpunit  pivot  pixelandtonic  playa  playbook  plugin  plugins  populate  port  post-type  postgre  postgres  postgresql  POSTs  practices  precision  prefix  pricing  primary  privacy  privileges  pro  procedure  process  processes  processlist  production  program  programming  project  prompt  property  pros  protection  provision  psql  purge  pymysql  python  python2.7  queries  query  rackspace  rackspacecloud  rails  rails-guides  railsguides  rake  range  ranges  raw  rds  read  reconnect  record  records  recover  redirect  reference  regex  regexp  registrars  relation  relational  relationship  relationships  Reload  remote  Remotely  remove  rename  replace  repository  requirements  RESeed  resolution  resolve  resource  restart  restore  RESTrict  result  results  revoke  role  roles  rollbacks  root  ror  ror4.2.0  round  row  rows  ruby  rubyonrails  run  saas  safety  same  sass  save  scalability  schema  scope  screencast  script  scripts  search  searching  secure  security  seed  seeder  seeding  select  Selectable  separate  separated  sequel  sequelpro  serialization  server  server-2008  serverfault  servers  service  services  sessions  set  setting  settings  setup  shell  show  Simplon  single  Site  size  sizes  slow  Snapshot  snipplet  soft  software  sorting  specific  spreadsheet  sql  sqlalchemy  SQLfiddle  sqlite  sqlite3  sqlserver  Ssh  Ssl  stack  stackexchange  stackoverflow  start  State  statement  Stop  Storage  Store  string  strings  subquery  SUBSTRINg  sum  support  suspicious  sync  synching  synchronization  syntax  sysadmin  system  table  tables  Tags  taxonomy  template  temporary  tenant  tenanti  terminal  terminate  test  testing  text  than  theme  Thread  time  timeout  times  timestamp  Timing  tips  to  Tocheck  tocheckout  token  toleaern  tolearn  too  tool  toolkit  tools  toread  totry  tounderstand  transaction  transactions  transients  tree  trigger  troublehshoot  troubleshoot  troubleshooting  troubleshot  truncate  try  tunderstand  tuner  tuning  Tunnel  tutorial  tutorials  tutsplus  type  types  ubuntu  ubuntu14.04  ubuntu16.04  under  understand  unicode  unique  unit  unittest  unittesting  unix  unixcraft  unsigned  up  update  updated_at  usage  use  useful  user  username  users  utf8  utf8mb4  utility  vagrant  validation  value  values  varchar  variable  vendor  version  versioncontrol  versioning  view  views  virtual  virtualmachine  vps  vulnerabilities  w3chools  w3schools  wait  web  webapp  webdesign  webdev  well  when  where  wherein  whois  Wiki  windows  windows-server  windows-server-2008  with  without  word  wordpress  wordpress.stackexchange  work  workbench  wp  wpdb  wpengine  wpengineer.com  wptuts  WP_Query  write  yajra  youtube  zone 

Copy this bookmark: