# point

Published articles for point.

This is one page of public article previews, not the complete archive. Follow Next page to continue. Summaries are not the original full articles.

## PostgreSQL Data Types: Point

DevFeed: [PostgreSQL Data Types: Point](<https://devfeed.tech/articles/postgresql-data-types-point-34597.md>)

Original publisher: [Read original article](<https://tapoueh.org/blog/2018/05/postgresql-data-types-point/>)

Author: Dimitri Fontaine PostgreSQL Major Contributor; Author

Published: 2018-05-07T08:46:17Z

Content type: tutorial

Language: en

Sources: [Dimitri Fontaine](<https://devfeed.tech/sources/dimitri-fontaine.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [datasets](<https://devfeed.tech/topics/datasets.md>), [Structured-data](<https://devfeed.tech/topics/structured-data.md>)

Tags: [article](<https://devfeed.tech/tags/article.md>), [data](<https://devfeed.tech/tags/data.md>), [point](<https://devfeed.tech/tags/point.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [sql](<https://devfeed.tech/tags/sql.md>)

### AI overview

A tutorial introducing PostgreSQL's Point data type through the download, loading, processing, and normalization of GeoNames geolocation data. It uses SQL and discusses handling problematic quoting and reference data.

### Source excerpt

Continuing our series of PostgreSQL Data Types today we're going to introduce the PostgreSQL Point type. In order to put the Point datatype in a context where it makes sense, we're going to download a complete geolocation data set and normalize it, thus making good use of both the normalization good practice and those other PostgreSQL data types we've been learning about in the previous articles of this series. Buckle-up, this is a long article with a lot of SQL inside.

## Hardening Craft CMS Permissions

DevFeed: [Hardening Craft CMS Permissions](<https://devfeed.tech/articles/hardening-craft-cms-permissions-31269.md>)

Original publisher: [Read original article](<https://nystudio107.com/blog/hardening-craft-cms-permissions>)

Author: andrew@nystudio107.com (Andrew Welch)

Published: 2016-12-05T05:42:00Z

Content type: tutorial

Language: en

Sources: [nystudio107 | Articles on modern web development.](<https://devfeed.tech/sources/nystudio107-articles-on-modern-web-development.md>)

Topics: [Content Management System](<https://devfeed.tech/topics/cms.md>), [Security](<https://devfeed.tech/topics/security.md>), [Authorization](<https://devfeed.tech/topics/authorization.md>), [file](<https://devfeed.tech/topics/file.md>), [POSIX](<https://devfeed.tech/topics/posix.md>), [Unix](<https://devfeed.tech/topics/unix.md>), [Server](<https://devfeed.tech/topics/server.md>), [nginx](<https://devfeed.tech/topics/nginx.md>), [Livewire](<https://devfeed.tech/topics/livewire.md>)

Tags: [cms](<https://devfeed.tech/tags/cms.md>), [craft](<https://devfeed.tech/tags/craft.md>), [file](<https://devfeed.tech/tags/file.md>), [file-permissions](<https://devfeed.tech/tags/file-permissions.md>), [getting](<https://devfeed.tech/tags/getting.md>), [hardening](<https://devfeed.tech/tags/hardening.md>), [important](<https://devfeed.tech/tags/important.md>), [insights](<https://devfeed.tech/tags/insights.md>), [laravel](<https://devfeed.tech/tags/laravel.md>), [nginx](<https://devfeed.tech/tags/nginx.md>), [permissions](<https://devfeed.tech/tags/permissions.md>), [point](<https://devfeed.tech/tags/point.md>), [posix](<https://devfeed.tech/tags/posix.md>), [provisioning](<https://devfeed.tech/tags/provisioning.md>), [right](<https://devfeed.tech/tags/right.md>), [security](<https://devfeed.tech/tags/security.md>), [server](<https://devfeed.tech/tags/server.md>), [unix](<https://devfeed.tech/tags/unix.md>), [view](<https://devfeed.tech/tags/view.md>)

### AI overview

A tutorial on hardening Craft CMS by configuring strict Unix file permissions that allow required webserver operations while limiting unauthorized modification and containing potential security exploit damage.

### Source excerpt

An important part of hardening Craft CMS from a security point of view is getting the file permissions right

## Unexpected bug cascade - or how seemingly missing bugs in MSVC builds reveal actual bugs

DevFeed: [Unexpected bug cascade - or how seemingly missing bugs in MSVC builds reveal actual bugs](<https://devfeed.tech/articles/unexpected-bug-cascade-or-how-seemingly-missing-bugs-in-msvc-builds-reveal-actual-bugs-33037.md>)

Original publisher: [Read original article](<https://reactos.org/blogs/unexpected-bug-cascade-or-how-seemingly-missing-bugs-msvc-builds-reveal-actual-bugs/>)

Published: 2015-12-27T00:00:00Z

Content type: article

Language: en

Sources: [Front Page on ReactOS Website](<https://devfeed.tech/sources/front-page-on-reactos-website.md>)

Topics: [bug](<https://devfeed.tech/topics/bug.md>), [MSVC](<https://devfeed.tech/topics/msvc.md>), [gcc](<https://devfeed.tech/topics/gcc.md>), [Code](<https://devfeed.tech/topics/code.md>), [function](<https://devfeed.tech/topics/function.md>), [ide](<https://devfeed.tech/topics/ide.md>), [export](<https://devfeed.tech/topics/export.md>)

Tags: [breakpoint](<https://devfeed.tech/tags/breakpoint.md>), [bug](<https://devfeed.tech/tags/bug.md>), [code](<https://devfeed.tech/tags/code.md>), [crash](<https://devfeed.tech/tags/crash.md>), [export](<https://devfeed.tech/tags/export.md>), [free](<https://devfeed.tech/tags/free.md>), [function](<https://devfeed.tech/tags/function.md>), [gcc](<https://devfeed.tech/tags/gcc.md>), [msvc](<https://devfeed.tech/tags/msvc.md>), [null](<https://devfeed.tech/tags/null.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [os](<https://devfeed.tech/tags/os.md>), [point](<https://devfeed.tech/tags/point.md>), [react](<https://devfeed.tech/tags/react.md>), [reactos](<https://devfeed.tech/tags/reactos.md>), [win32](<https://devfeed.tech/tags/win32.md>), [winapi](<https://devfeed.tech/tags/winapi.md>)

### AI overview

This article examines how different MSVC and GCC builds exposed a cascade of bugs while investigating a crash in wget.exe. It covers KDBG breakpoint and single-stepping behavior, an MSVC export-resolution issue involving msvcrt.dll and libntdll, and a crash caused by passing a NULL buffer after _vsnprintf returned -1.

### Source excerpt

I was looking into CORE-9105, a crash in wget.exe, but I couldn't reproducde it, so I asked Daniel whether he was using an MSVC build or a GCC build. He used a GCC build and I was using an MSVC build. So I tried with a GCC build and the bug appeared. So I looked at this thing with kdbg. And there the first bug showed up. Bug #1: KDBG and break points I set a breakpoint at a position that I wanted to step through and KDBG stopped there.

## The Čech Complex and the Vietoris-Rips Complex

DevFeed: [The Čech Complex and the Vietoris-Rips Complex](<https://devfeed.tech/articles/the-cech-complex-and-the-vietoris-rips-complex-40386.md>)

Original publisher: [Read original article](<https://www.jeremykun.com/2015/08/06/cech-vietoris-rips-complex/>)

Published: 2015-08-06T09:00:00Z

Content type: article

Language: en

Sources: [Jeremy Kun](<https://devfeed.tech/sources/jeremy-kun.md>)

Topics: [data](<https://devfeed.tech/topics/data.md>), [datasets](<https://devfeed.tech/topics/datasets.md>), [Point cloud](<https://devfeed.tech/topics/point-cloud.md>), [Computing](<https://devfeed.tech/topics/computing.md>)

Tags: [approximation](<https://devfeed.tech/tags/approximation.md>), [cech-complex](<https://devfeed.tech/tags/cech-complex.md>), [complex](<https://devfeed.tech/tags/complex.md>), [computational-topology](<https://devfeed.tech/tags/computational-topology.md>), [data-mining](<https://devfeed.tech/tags/data-mining.md>), [data-science](<https://devfeed.tech/tags/data-science.md>), [dataset](<https://devfeed.tech/tags/dataset.md>), [homology](<https://devfeed.tech/tags/homology.md>), [linear-algebra](<https://devfeed.tech/tags/linear-algebra.md>), [mathematics](<https://devfeed.tech/tags/mathematics.md>), [persistent-homology](<https://devfeed.tech/tags/persistent-homology.md>), [point](<https://devfeed.tech/tags/point.md>), [points](<https://devfeed.tech/tags/points.md>), [simplicial-complex](<https://devfeed.tech/tags/simplicial-complex.md>), [vietoris-rips-complex](<https://devfeed.tech/tags/vietoris-rips-complex.md>)

### AI overview

This article introduces computational topology for analyzing the shape of data. It explains how point clouds can be converted into simplicial complexes so homology and persistent homology can identify qualitative features such as connected components and holes, with some resistance to noise.

### Source excerpt

It's about time we got back to computational topology. Previously in this series we endured a lightning tour of the fundamental group and homology, then we saw how to compute the homology of a simplicial complex using linear algebra. What we really want to do is talk about the inherent shape of data. Homology allows us to compute some qualitative features of a given shape, i.e., find and count the number of connected components or a given shape, or the number of "2-dimensional holes" it has.