How to Install and Manage PostGIS with a Non-Superuser Role

Image
Prerequisite: PostgreSQL Version This guide assumes you are using PostgreSQL version 14 or later, which supports the necessary commands for PostGIS installation and management. Ensure your PostgreSQL server is up-to-date before proceeding. This guide ensures that PostGIS is installed and configured properly for a specific user, such as administrator , while avoiding common issues. 1. Ensure Superuser Access sudo -i -u postgres psql --dbname=financethat 2. Create a Role for PostGIS Management CREATE ROLE administrator WITH LOGIN PASSWORD 'your_secure_password'; GRANT ALL PRIVILEGES ON DATABASE financethat TO administrator; 3. Install PostGIS To install PostGIS on Ubuntu, first ensure you have the required PostgreSQL version installed. Then, use the following commands: sudo apt update sudo apt install postgis postgresql-14-postgis-3 Replace 14 with your PostgreSQL version if different. After installation, enable PostGIS in...
Post a Comment

Highcharts: A 10 minutes overview.

A Norway-based company 'Highsoft' offering charting library written in pure javascript. Its a major addon to web applications requires interactive charts. Currently they're supporting many chart types including line, area, column, bar, pie, scatter, bubble, gauge, spline, areaspline and polar etc.

Already Highcharts is providing a descriptive demo page considering all examples (Highcharts Demos). The pupose of the article only to understand maximum aspects in a view.

Features :

Compatible with all major browsers, it also provides features like DateTime support, Export (PDF/ PNG/ JPG / SVG), Print and Zoomablity etc.

Installation:

Its a single file downloadable from (https://www.highcharts.com/). Also packages through npm and Bower are avalable. We may load file on our domain or use CDN version.

Load files from your own domain (Insert in html head)

<script src = "/js/highcharts.js">

CDN Version (Insert in html head)

<script src = "https://code.highcharts.com/highcharts.js">

Highcharts general elements are worth to understand. Then next step is formatting. It helps to mould highcharts as per our requirement.

Below are few very important queries, while working with Highcharts.

How to format Legend?
How to format x-axes?
How to format y-axes?
How to format column?
How to format tooltip?
How to format y-axes stackLabels?
How to colour the columns?
How to add event on columns?

In below image all questions are answered.
Also view complete example in jsfiddle.

Also we'll discuss other aspects of highcharts soon.

Comments

  1. Arun PrasherJuly 17, 2020 at 10:07 PM

    https://stackoverflow.com/questions/48748550/google-chart-horizontal-scrolling

    ReplyDelete

Post a Comment

Popular posts from this blog

Managing Python Projects with Pipenv and Pyenv: A Comprehensive Guide

Image
In the ever-evolving world of Python development, managing project dependencies and Python versions can become a complex task. Tools like Pipenv and Pyenv have been created to simplify these processes, but understanding how they work individually and together is crucial for efficient project management. This comprehensive guide will delve into the functionalities of Pipenv and Pyenv, highlight their differences, and demonstrate how to effectively use them in your Python projects. Table of Contents Introduction to Pipenv Key Features of Pipenv Pipenv General Commands Pipfile vs requirements.txt Managing Dependencies in a Django Application Creating a Pipfile and Pipfile.lock Example Pipfile Explained Automatic Updating of Pipfile and Pipfile.lock Setting Up the Project with Pipenv Introduction to Pyenv Key...
Read more

Differences Between List, Dictionary, and Tuple in Python

In Python, lists, dictionaries, and tuples are all built-in data structures that store collections of items. While they share similarities, each has its distinct characteristics and use cases. This post provides a comprehensive comparison. Comparison Table Aspect List Dictionary Tuple Definition An ordered collection of elements. A collection of key-value pairs. An ordered and immutable collection of elements. Access Method Index-based access ( my_list[0] ). Key-based access ( my_dict['key'] ). Index-based access ( my_tuple[0] ). Mutability Mutable: Elements can be added, removed, or changed. Mutable (for values): Keys/values can be added, modified, or removed, but keys must be immutable. Immutable: Elements cannot be changed once assigned. Order Guarantee Maintains th...
Read more

Implementing Throttling in Django REST Framework.

Implementing Throttling in Django REST Framework to Manage High Traffic and Prevent Abuse Introduction In high-traffic applications, it’s essential to protect server resources and ensure fair usage among users. Throttling is a method used in Django REST Framework (DRF) to limit the rate of requests, helping prevent abuse and manage load. In this article, we’ll explore how to implement throttling in DRF, including ways to apply it to specific views and dynamically whitelist IPs. What is Throttling? Throttling controls the rate of requests an API endpoint can receive from a single client. It’s a valuable tool for: Preventing abuse by limiting request rates for each user or IP address. Managing server load by avoiding high request volumes that can overwhelm the application. In Django REST Framework, throttling is easy to configure with built-in classes like UserRateThrottl...
Read more