Profile cover photo
Profile photo
Alan Hicks
19 followers -
IT & Marketing, database whisperer, open source evangelist, http://gbcomp.p-o.co.uk
IT & Marketing, database whisperer, open source evangelist, http://gbcomp.p-o.co.uk

19 followers
About
Posts

Post has attachment
Looking to understand, engage or hire a developer for your next project?
What developers choose for performance metrics?
Check the results of this developer survey and see what drives them and what they're looking for. https://insights.stackoverflow.com/survey/2017#work-what-would-developers-choose-for-performance-metrics
Photo
Add a comment...

Post has attachment
See how we scaled our data insights.
Take a tech-dive into how we empowered users by implementing database Views and Procedures, offering insights into the hows and whys, their
respective advantages, plus real life examples how we got greater results for our users.

https://p-o.co.uk/tech-articles/views-and-stored-procedures-in-postgresql-what-are-they-and-when-to-use-them-for-increasing-user-and-database-efficiency/
Add a comment...

Post has attachment
Is your database complex and difficult to use?
This article demonstrates what Views and Procedures are, and when to use them, in an attempt to make our lives easier and more efficient than ever.
Views and Procedures can be perceived as advanced and unnecessary, this article attempts to demonstrate that they are an essential aspect to making complex data both accessible and easier to use.

Efficiency has a number of meanings.

Efficient adj: Making, Causing to be; Productive of effects; Adequately skilled and active.

In this article, efficiency can mean:

- Efficiency of people's time - fast and responsive;
- Efficiency of people's time - ease of use and re-use;
- Efficiency of machine resources;
- Scalability.

As there is a natural tension between these meanings of efficiency, it makes sense that any technical decision is made in conjunction with defining and balancing business objectives.

Business context
With an imperative to continually ask questions and reduce time to market, it's essential to make access to information easy and intuitive.

Typically feedback and reports can be time critical for example "What was my commission on that last sale?", and non time critical such as "How well did we do yesterday?". They may be straightforward, or complex with many calculations to produce the final output.

Technical choices
Views are a way of packaging up complex queries into something more manageable. Main benefits include avoiding re-inventing common queries, aiding best practice, increasing productivity through re-use and understanding. Views can be used with other tables and views and are usually intended to be filtered and combined in a flexible manner.

Stored procedures are highly optimised and can include complex business logic. They are normally used as discrete components though can be combined with tables and views.

Database views
As their name suggests, they are a packaged view into data. Often combined with other views and tables, they are flexible and can filter, join, manipulate and sort data. Great for generic or specific queries, perfect for packaging up common queries, with reduced complexity, making use and re-use easy.

For example a 24 line query can be packaged up into a view that can be reduced to six. This helps democratising data by making it easier to use and re-use.

Procedures and complex functions
When requirements are complex or need additional processing, procedures can be ideal. A complete programming language in their own right. Most major databases include choices for programming languages so you can use whichever best fits your requirements. With very close access to data they are incredibly fast. Closely tied to data, it can make sense investing in optimisation to process information through procedures, presenting output in a more easily
digested format.

Highly optimised, stored procedures are usually used as discrete components, though they can be combined with other tables and views if required. Often used to generate specific reports or data sets, they are frequently used in single data panels or as a focused aspect to a report combined with other data.

Using a procedure to access data is easy, as is presenting it using normal tools such a Excel, Access or a website.

Summary
Views and Procedures add simplicity and ability to extend databases making them faster and easier to use and re-use than ever. A version of this article is available at https://p-o.co.uk/tech-articles/views-and-stored-procedures-in-postgresql-what-are-they-and-when-to-use-them-for-increasing-user-and-database-efficiency/ with examples using #PostgreSQL and a list of resources to explore more about database optimisation, views and procedures.

Make your data easier to use and you could discover more about your users, products and services and reduce the time it takes to surface new opportunities.
Add a comment...

Post has attachment
Many thanks to SixXS for many years of unbroken solid network offering #IPv6.

You have increased take-up of this essential technology, enabled tech developers like me to test and develop the next generation of high performance and cross platform apps benefiting users of all aims and abilities.

It's now time for ISPs to complete their delivery of IPv6 for all.

Thanks again to SixXS for enabling me to continue delivering ever higher quality.
Add a comment...

Post has attachment
Intelligence is artificial, automating it wisely helps.
Photo
Add a comment...

Post has attachment
The weekend starts now(ish)
Photo
Add a comment...

Post has attachment

#IPv6 the Next Generation internet protocol is 22 years old
IPv6 is ready are you?
See this country league table https://www.sixxs.net/wiki/Call_Your_ISP_for_IPv6
Photo
Add a comment...

Post has attachment
I'm glad I've got the easy part in supporting a broad range of services. #IPv6 and traditional #IPv4 are the protocols to access them, thanks to tireless network engineers, both 'just work', Thank You. http://www.circleid.com/posts/20160819_examinning_ipv6_performance_revisited/
Add a comment...

Post has attachment
Trust is essential and with CAP Code, the UK Code of Non-broadcast Advertising, Sales Promotion and Direct Marketing has teeth from the ASA to ensure what you see is both legal and fair as well as being clearly identified as marketing material.

https://en.wikipedia.org/wiki/CAP_Code
Add a comment...

Post has attachment
Reputation matters, #DMARC adds confidence for emails.
Managing feedback reports helps implement DMARC and better understand who is impersonating you. The latest version improves error checking and resolution.
http://p-o.co.uk/tech-articles/django-dmarc/
Add a comment...
Wait while more posts are being loaded