uncleflo

profile picture

Some cool dude. Higher order of decision making. Absolute.

Registered since September 28th, 2017

Has a total of 3445 bookmarks.

Showing top Tags within 100 bookmarks

development   howto   information   guide   reference   administration   website   software   design   solution   linux   business   service   server   web   code   online   uk   tool   application   system   blog   list   data   tutorial   description   article   video   security   technology   company   windows   world   explanation   product   download   free   javascript   network   project   experience   lookup   london   performance   file   library   php   tools   create   research   programming   build   control   html   support   opensource   example   beautiful   technical   learn   community   image   music   computer   dance   share   database   user   browser   mobile   webdesign   platform   feature   internet   hardware   work   money   css   quality   install   3d   search   camera   access   course   event   standard   source   manage   management   travel   developer   phone   test   client   story   api   marketing   script   simple   review   google   fast   documentation   digital   communication   usa   question   interface   cheap   app   advice   content   photography   program   youtube   setup   account   professional   idea   device   study   startup   process   live   installation   monitor   develop   profile   buy   market   customer   media   resource   industry   analysis   flash   ubuntu   social   inspiration   speed   package   compare   js   framework   cloud   photo   university   graphics   personal  


Tag selected: database.

Clear all

Showing 100 results.

Looking up database tag. Showing 100 results. Clear

AWS RDS Aurora | CLUSTER DEMO | Cross Region Replica, Types of Endpoints, HA & Fully Managed - YouTube

https://www.youtube.com/watch?v=fpkQ0zefud8

Saved by uncleflo on May 27th, 2019.

Let's learn Amazon Aurora Database from scratch. What are new features of Aurora over RDS? How to achieve HA with Aurora Cluster? What are different types of Endpoints with Aurora? Aurora compatibility with MySQL & PostgreSQL. Reader, Writer & Custom Endpoints in Aurora Cluster.

database check understand achieve architect administrator practical exercise amazon watch cluster learn db howto solution problem advanced administration infrastructure system replication available


How to Migrate Microsoft SQL Server to MySQL Database

https://www.thegeekstuff.com/2014/03/mssql-to-mysql/

Saved by uncleflo on May 12th, 2019.

If you are using mostly open source in your enterprise, and have few MS SQL server database around, you might want to consider migrating those to MySQL database. We can migrate MS SQL database to MySQL using migration module of “MySQL Workbench” utility. Download and install this MySQL Installer, which includes Workbench and other necessary connectors and drivers required for the migration.

workbench schema migrate migration database server setup wizard install manually please destination replication convert connect parameter replica table administration business license cost efficient howto require consider module article reference tutorial connector


SQL Server 2016: Create a Database User

https://www.quackit.com/sql_server/sql_server_2016/tutorial/create_a_database_user_in_sql_server_2016.cfm

Saved by uncleflo on May 5th, 2019.

In SQL Server, you can create a database user to allow different users or processes access to a particular database. Even though we have just created a login that can successfully connect to SQL Server, that login still can't access our Music database. This is because we haven't yet associated that login with a database user. There are four things you need to do in order to provide access to a database:

schema tutorial database explorer server privacy connect access connection membership contact user administration development microsoft explanation howto privilege


MySQL Workbench: Database Migration

https://www.mysql.com/products/workbench/migrate/

Saved by uncleflo on May 4th, 2019.

The MySQL Workbench Migration Wizard is designed to save DBA and developer time by providing visual, point and click ease of use around all phases of configuring and managing a complex migration process: White Paper: Migrating from Microsoft Access to MySQL » With the MySQL Workbench Migration Wizard, users can convert an existing database to MySQL in minutes rather than hours or days that the same migration would require using traditional, manual methods. The Migration Wizard allows you to easily and quickly migrate databases from various RDBMS products to MySQL. Click on image to enlarge.

workbench wizard migration migrate database developer process software download mysql mariadb rdbms product traditional visual phase manage administration data structure


Create a Database User - SQL Server | Microsoft Docs

https://docs.microsoft.com/en-us/sql/relational-databases/security/authentication-access/create-a-database-user?view=sql-server-2017

Saved by uncleflo on May 4th, 2019.

This topic describes how to create the most common types of database users. There are eleven type of users. The complete list is provided in the topic CREATE USER (Transact-SQL). All varieties of SQL Server support database users, but not necessarily all types of users. You can create a database user by using SQL Server Management Studio or by using Transact-SQL.

authenticate database password user schema folder authentication server select query containment specify feedback certificate connect execute confirm windows transaction manage studio microsoft sqlserver type description variety support topic access privilege


(Sail) Boats For Sale

https://www.yachtworld.co.uk/core/listing/cache/searchResults.jsp?sm=3&searchtype=advancedsearch&Ntk=boatsUK&ftid=0&enid=0&type=%28Sail%29&hmid=0&boatsAddedSelected=-1&slim=quick&currencyid=1005&fromPrice=1000&luom=126&cint=340&cint=343&cint=345&cint=295&toLength=40&fromLength=30&cit=true&toPrice=10000&No=20

Saved by uncleflo on February 23rd, 2019.

Since March 1995, YachtWorld has been connecting yacht brokers with buyers across the globe. With over 110,000 boat listings, YachtWorld has the largest database of brokerage boats for sale offered by more than 2,900 yacht brokers and 70 manufacturers worldwide. Jessica Muffet, founding publisher, launched YachtWorld as the first online business to promote yacht brokers’ boats to the public on the Internet, and still today all members of the YachtWorld broker network have access to the most robust suite of online marketing services, including inventory and lead management powered by BoatWizard, the world’s largest multiple listing service (MLS), SoldBoats data, targeted online advertising and marketing solutions services. In March 2000, YachtWorld expanded its offerings to the European market. Ian Atkins opened the first European office in Fareham, England to launch YachtWorld to the European markets and provide dedicated sites for the UK, Germany, France, Spain, Italy, Netherlands, and Australia. Increasing demand of the Scandinavian and Russian audience brought sites for Finland, Denmark, Sweden, Norway, Russia. YachtWorld’s websites are now localised for 13 different countries that reach over 600,000 unique visitors each month. Boats Group was acquired by Apax Partners in July of 2016 and operates the five leading marine brands of YachtWorld, Boat Trader, boats.com, CosasDeBarcos and YachtCloser. The company continues to build best-in-class software to support the recreational boating community with a commitment to innovation and service, developing and applying leading-edge technology for our industry partners and a superior experience for prospective buyers.

yacht racer cruiser carter handicap displacement qualities inspection sail attractive boat owner search sailboat solution service worldwide database europe market buy sell demand world advertise founder publish expand connect globe offer


Dreamstime - 93 million stock images, world's largest stock community, 23 million users

https://www.dreamstime.com/

Saved by uncleflo on December 20th, 2018.

Dreamstime is one of the world leaders in stock photography and a reliable supplier of high quality digital images at affordable prices. Online since 2000 as a Royalty-Free stock photography website, Dreamstime has evolved into a powerful and active community-based site. The exquisite stock image gallery you can browse today has been uploaded by photographers from all over the world, shot on film or digital. To ensure you receive the best content, all images are reviewed and approved by experienced editors. The Dreamstime database is renewed with thousands of fresh images and titles on a daily basis.

stock photography website evolve powerful active gallery browse today world digital content editor experience database image affordable price lookup reference list find download unique


SAILBOATDATA.COM

https://sailboatdata.com/

Saved by uncleflo on November 29th, 2018.

SAILBOATDATA.COM is a database that contains information on nearly 8000 production and semi-production sailboats dating back to 1900. Boats are generally listed using their class designation rather than the manufacturer or builder name. For example a BENETEAU FIRST 456 will be listed as FIRST 456 (BENETEAU) One could also go to the BUILDERS section and search BENETEAU. All the boats built by BENETEAU should be listed within that title. Search results default to alphabetical, 25 per page. Use SORT BY: to switch your results to sort by year built or LOA.

sailing boat data database information production class designation manufacturer builder section find sort year lookup plan ocean sea river cruise family title alphabetical example contain construct structure marine


AWS Innovate 2018: Developer Edition

https://aws.amazon.com/events/aws-innovate-2018/agenda/

Saved by uncleflo on October 28th, 2018.

AWS Innovate: Developer Edition is a digital event designed for developers, business analysts and all types of builders. Hear from Ian Massingham, Lead of Technical & Developer Evangelism at AWS, and learn more about AI & ML, Serverless, Containers, Database Management and Amazon Game Tech in the 20+ sessions offered. Software development practices have evolved substantially over the almost 5 year period that Ian Massingham has been with Amazon Web Services. In this keynote, Ian focuses on the latest trends in software architecture and developer tools. From modern application architectures, to when you should choose serverless over servers, and how you can take advantage of the fundamental characteristics of the AWS cloud to supercharge your Machine Learning applications.

innovation service design developer development administration type builder aws ai server serverless container database management amazon vps webservice howto deep dive reference introduction general insight learn application software digital event analyst


MySQL: Scaling & High Availability

https://www.percona.com/sites/default/files/presentations/Webinar-MySQL-Scaling-HA-Production-experience.pdf

Saved by uncleflo on June 27th, 2018.

Production experience for the last decade(s). Peter Zaitsev, CEO, Percona. June 19, 2018. Percona Technical Webinars. Please join Percona’s CEO, Peter Zaitsev as he presents MySQL: Scaling and High Availability – Production Experience Over the Last Decade(s) on Tuesday, June 19th, 2018 at 7:00 AM PDT (UTC-7) / 10:00 AM EDT (UTC-4). Percona is known as the MySQL performance experts. With over 4,000 customers, we’ve studied, mastered and executed many different ways of scaling applications. Percona can help ensure your application is highly available. Come learn from our playbook, and leave this talk knowing your MySQL database will run faster and more optimized than before.

experience percona technical webinar scaling high availability performance application presentation pdf database fast speed howto mysql insight explanation references administration production


Data Warehousing Summary Tables

https://mariadb.com/kb/en/library/data-warehousing-summary-tables/

Saved by uncleflo on June 27th, 2018.

This document discusses the creation and maintenance of "Summary Tables". It is a companion to the document on Data Warehousing Techniques. The basic terminology ("Fact Table", "Normalization", etc) is covered in that document. Summary tables are a performance necessity for large tables. MariaDB and MySQL do not provide any automated way to create such, so I am providing techniques here. (Other vendors provide something similar with "materialized views".) When you have millions or billions of rows, it takes a long time to summarize the data to present counts, totals, averages, etc, in a size that is readily digestible by humans. By computing and saving subtotals as the data comes in, one can make "reports" run much faster. (I have seen 10x to 1000x speedups.) The subtotals go into a "summary table". This document guides you on efficiency in both creating and using such tables.

mysql mariadb warehouse warehousing summary table technique terminology normalization performance large material view total guide efficiency improve development developer create database average administration administrator infrastructure howto blog article description solution


How to use MySQL to search in php serialized fields

http://blastar.biz/2013/11/28/how-to-use-mysql-to-search-in-php-serialized-fields/

Saved by uncleflo on June 22nd, 2018.

Well, first rule – you should not do this. But if there is good reason, consider using such query for searching in index-based arrays: SELECT * FROM table WHERE your_field_here REGEXP '.*;s:[0-9]+:"your_value_here".*' In case you have assoc array serialized you can use: SELECT * FROM table WHERE your_field_here REGEXP '.*"array_key_here";s:[0-9]+:"your_value_here".*' Of course it won’t be very fast but in small tables should be enough

rule index mysql search query array regex fast table associate serialized reason field php database stored solution development code sql


Create MySQL table by using another table

http://www.geeksengine.com/database/manage-table/create-table-as.php

Saved by uncleflo on May 29th, 2018.

Let's look at a common task that a developer does in their day-to-day job. A database table is to be modified for its data and/or structure. Before making any changes, the first thing that is always wise to do is to back up the database table. The easy way to accomplish this is to write a piece of SQL script like below. The scenario is we're going to make some changes to Products table, so here we go. Copy and paste the following SQL to your SQLyog free Community Edition query window. Note that the SQL needs to end with semi-colon if you have multiple queries in the query window. Most of the queries in the tutorials need Northwind MySQL database, you can download the database script on this page.

common task database table development administration windows query tutorial mysql create howto example script modify structure web


MySQL Table Locking

http://www.mysqltutorial.org/mysql-table-locking/

Saved by uncleflo on May 9th, 2018.

In this tutorial, you will learn how to use MySQL locking for cooperating table access between sessions. MySQL allows a client session to acquire a table lock explicitly for preventing other sessions from accessing the table during a specific period. A client session can acquire or release table locks only for itself. It cannot acquire or release table locks for other sessions. Before going into detail, we will create a sample database named sampledb that includes a simple table named tbl to practice the table locking statements.

mysql lock howto tutorial demonstration table client session explicit administration rdbms db database practice technical understand article demo concurrency control learn guide description


Locking for Concurrency in MySQL

http://www.brainbell.com/tutors/php/php_mysql/When_and_how_to_lock_tables.html

Saved by uncleflo on May 9th, 2018.

The first and most important point is that the primary use of locking is to solve concurrency problems. If scripts are being implemented that write to the database but aren't multistep operations susceptible to the problems described in the last section, locks aren't needed. Simple scripts that insert one row, delete one row, or update one row, and that don't use results of a previous SELECT or data entered by the user as input, don't require a lock.

lock database concurrency problem script operation howto description article technical result implement php mysql tutor resource reference control mechanism command


VividCortex - Application performance starts with your database

https://www.vividcortex.com/

Saved by uncleflo on April 18th, 2018.

Most app performance issues originate in the database, but engineering teams lack visibility into the data tier. VividCortex provides unique insights into database workload and query performance, enabling faster issue resolution. The result is better application performance, reliability, and uptime. This ebook will help you understand key questions that you should pose about your database—and it will show you exactly how you can answer them, quickly and safely, with VividCortex.

performance development engineering team database db test optimization overview analysis question code query sql


MySQL LOCK TABLES and UNLOCK TABLES Syntax

https://dev.mysql.com/doc/refman/5.7/en/lock-tables.html

Saved by uncleflo on April 18th, 2018.

MySQL enables client sessions to acquire table locks explicitly for the purpose of cooperating with other sessions for access to tables, or to prevent other sessions from modifying tables during periods when a session requires exclusive access to them. A session can acquire or release locks only for itself. One session cannot acquire locks for another session or release locks held by another session. Locks may be used to emulate transactions or to get more speed when updating tables. This is explained in more detail later in this section. LOCK TABLES explicitly acquires table locks for the current client session. Table locks can be acquired for base tables or views. You must have the LOCK TABLES privilege, and the SELECT privilege for each object to be locked.

lock unlock lock mechanism sql mysql database db development administration howto release data table code deadlock solution description reference documentation


Temporary tables in SQL query optimization

https://www.endpoint.com/blog/2015/02/25/temporary-tables-in-sql-query

Saved by uncleflo on April 18th, 2018.

SQL queries can get complex in a big hurry. If you are querying multiple tables, and in particular if your query involves operations like UNION and INTERSECT, then you can find yourself in a big, messy pile of SQL. Worse, that big pile will often run slowly, sometimes to the point where a web application times out! I won’t inflict a real-world example on you; that would be cruel. So let’s look at a “toy” problem, keeping in mind that this won’t illustrate any time-savings, just the technique involved.

query complex temporary table operation union intersect problem description solution development database db howto sql optimize blog article


FIN - Our core service for exchanging MT format financial messages

https://www.swift.com/our-solutions/global-financial-messaging/fin

Saved by uncleflo on March 27th, 2018.

FIN connects you to financial institutions, corporates and market infrastructures. FIN enables financial institutions to exchange individual structured (MT and ISO 15022 message formats) financial messages securely and reliably. FIN is used by over 10,800 financial institutions and their corporate customers worldwide to exchange over 22.3+ million messages per day across a wide range of business areas within the banking and securities industries. FIN value-added processing includes: Message validation to ensure messages are formatted according to SWIFT message standards. Delivery monitoring and prioritisation. Message storage and retrieval. It is based on a distributed processing architecture with full, built-in redundancy to ensure maximum availability.

financial infrastructure infra development administration institution exchange individual message security secure business industry validation standard monitor priority distributed database money fin iso corporation process availability


select without from

https://modern-sql.com/use-case/select-without-from

Saved by uncleflo on March 27th, 2018.

Let's get that straight from the beginning: select without from is not standard conforming SQL. Full stop. Nevertheless it works in many databases—also in standard conforming ones. That's no contradiction: the standard explicitly allows conforming databases to “provide user options to process non-conforming SQL statements”0. The behavior of such statements is completely up to the vendor, of course. So what alternative does the standard offer to select without from? A surprisingly simple and yet powerful one: values without insert.

sql database db conform option explicit values howto discussion blog development code data select modern


phpMiniAdmin for MySQL

http://phpminiadmin.sourceforge.net/

Saved by uncleflo on March 8th, 2018.

phpminiadmin - extremely lightweight alternative to heavy phpMyAdmin for quick and easy access MySQL databases. Instead of installing huge phpMyAdmin (~11Mb) and trying to figure out how to use all it's features, just upload one ~30Kb file and it's ready to use! Then access it via the browser (ex. http://yoursite.com/phpminiadmin.php). Script will ask you for DB login/pwd. After successfull db login you will see area where you able to enter any SQL commands (select, update, insert, etc.). Even if you don't know SQL it's still easy to: browse tables and see all the data, click to un/highlight rows
manage tables in DB, export and import data to .sql and CSV using 'quick links' on the top bar (see screenshots), see what databases you have permission with, check server status and statistics, ability to do CRUD (i.e. insert, select, update, delete), and launch any SQL supported by any version of MySQL. And due to it's simplicity script really fast and need just a little server resources! (your hosting provider will be glad ;)

installation mysql script page fast mini admin administration web website data database db sql browser permission table server developer work


PHP Mini SQL Admin

https://sourceforge.net/projects/phpminiadmin/

Saved by uncleflo on February 15th, 2018.

PHP Mini SQL Admin - Lightweight alternative to heavy phpMyAdmin. Extremely small (~30Kb) standalone php script. Easy to Install, simple to use. No SQL knowledge required for basic operations. Features: full MySQL support, extremely small (~30Kb), just in one php file.

php tool mysql interface connect light lightweight alternative small simple operation feature database file easy useful db dbms frontent mini query sql


Fallacies of distributed computing

https://en.wikipedia.org/wiki/Fallacies_of_distributed_computing

Saved by uncleflo on December 28th, 2017.

The fallacies of distributed computing are a set of assertions made by L Peter Deutsch and others at Sun Microsystems describing false assumptions that programmers new to distributed applications invariably make.

fallacies stupid quote silly distributed database computer cluster infrastructure application assumption assume description knowledge assertion


Comma-separated values

https://en.wikipedia.org/wiki/Comma-separated_values

Saved by uncleflo on December 28th, 2017.

In computing, a comma-separated values (CSV) file stores tabular data (numbers and text) in plain text. Each line of the file is a data record. Each record consists of one or more fields, separated by commas. The use of the comma as a field separator is the source of the name for this file format. The CSV file format is not standardized. The basic idea of separating fields with a comma is clear, but that idea gets complicated when the field data may also contain commas or even embedded line-breaks. CSV implementations may not handle such field data, or they may use quotation marks to surround the field. Quotation does not solve everything: some fields may need embedded quotation marks, so a CSV implementation may include escape characters or escape sequences. In addition, the term "CSV" also denotes some closely related delimiter-separated formats that use different field delimiters. These include tab-separated values and space-separated values. A delimiter that is not present in the field data (such as tab) keeps the format parsing simple. These alternate delimiter-separated files are often even given a .csv extension despite the use of a non-comma field separator. This loose terminology can cause problems in data exchange. Many applications that accept CSV files have options to select the delimiter character and the quotation character.

csv text format data plain text line file record field comma separator description store exchange specification export database spreadsheet platform stream list information type sequence proprietary standard wikipedia development howto reference administration rule technology recommendation protocol


How to setup your PHP site to use UTF8

https://allseeing-i.com/How-to-setup-your-PHP-site-to-use-UTF8

Saved by uncleflo on June 27th, 2017.

According to Google (via: DF), UTF8 is now the most popular character set on the web! I wonder how much this is down to sensible defaults in web authoring tools, rather than a conscious shift in mindset. It's a long time since I looked at it, but as far as I can remember Dreamweaver defaults to UTF8 for new web pages, so a lot of beginning web designers are probably building Unicode sites without even realising it. I think there are a couple of reasons that many web designers and developers still aren't using Unicode across the board.

reference technical development administration utf-8 utf8 db database php webpage unicode site advice lookup server guideline practice web code setup character set