uncleflo

profile picture

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

Registered since September 28th, 2017

Has a total of 3394 bookmarks.

Showing top Tags within 95 bookmarks

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


Tag selected: database.

Clear all

Showing 95 results.

Looking up database tag. Showing 95 results. Clear

(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


Information Security Stackexchange

https://security.stackexchange.com/

Saved by uncleflo on June 27th, 2017.

Q&A for information security professionals. Ask questions and get answers on any and all information security related topics.

information security information security question answer stackexchange problem incident reference lookup technical business hacker hack community solve solution topic professional relate computer server linux windows os operating system site database advice


SQL Source Control

http://www.red-gate.com/products/sql-development/sql-source-control/

Saved by uncleflo on June 7th, 2017.

Connect your database to your version control system. Version control schemas and reference data, roll back changes, and maintain the referential integrity of your database. Solve other database challenges like deploying without losing data. And because it works with the tools you already use, it's an easy setup. Plugs into SQL Server Management Studio. Version control your schemas and static data. See who made what changes, when, and why

source control product software solution administer develop development server dbms database db howto introduction website explanation use application


OFFSCALE Get your database under control

http://off-scale.com/

Saved by uncleflo on June 7th, 2017.

Ready for the cloud. Creating so many DB snapshots that you never find the one you need? We’ll help you manage them! Reseting a server is easy but rolling back the DB is hard? Not anymore! Your database runs in someone else’s cloud? No problem! OffScale runs on your laptop and on the virtual server with the same ease

cloud software solution control version manage management schema data dbms database server reset rollback snapshot technical administer admin


How to avoid many-to-one problems in SQL

https://www.xaprb.com/blog/2006/03/11/many-to-one-problems-in-sql/

Saved by uncleflo on May 15th, 2017.

It’s been a while since I’ve posted an abstract, theoretical article on a fine point of SQL. Today I want to bring your attention to two ways in which an RDBMS can allow you to do something that has no well-defined result. These involve queries where several values are eligible, but only one is chosen – and chosen in an undefined manner. I’ll show you the two blunders, tell you when they might occur, and explain how to avoid them.

sql blog article problem query database description relation involve eligible many-to-one one-to-many explanation mysql


Managing Hierarchical Data in MySQL

http://mikehillyer.com/articles/managing-hierarchical-data-in-mysql/

Saved by uncleflo on May 15th, 2017.

Most users at one time or another have dealt with hierarchical data in a SQL database and no doubt learned that the management of hierarchical data is not what a relational database is intended for. The tables of a relational database are not hierarchical (like XML), but are simply a flat list. Hierarchical data has a parent-child relationship that is not naturally represented in a relational database table. For our purposes, hierarchical data is a collection of data where each item has a single parent and zero or more children (with the exception of the root item, which has no parent). Hierarchical data can be found in a variety of database applications, including forum and mailing list threads, business organization charts, content management categories, and product categories.

mysql databases dbms hierarchical tree database blog article question solution category relation purpose parent child sql collection item table lookup technical howto theory explanation list