#postgresql #markdown #string #cases #pluralize

pg_str

Adds str functions to Postgresql via an extension

2 releases

0.2.1 Jan 31, 2022
0.2.0 Jan 31, 2022

#1296 in Database interfaces

26 downloads per month

MIT license

8KB
122 lines

Postgresql String Extension

A better way of handling string manipulation and transformations in Postgresql.

Function api and behavior is inspired by those available in the Laravel web framework: https://laravel.com/docs/8.x/helpers#strings-method-list

Installation

git clone git@github.com:abumni/pg_str
cd pg_str
cargo pgx package # run cargo install pgx first
sudo make install # adjust Makefile if using different version of postgresql than 13.

This puts the binaries and sql into the right folder location. Next you need to create the extension in postgresql:

psql
> create extension pg_str; # installs functions in a schema named 'str'
> select str.markdown('# Hello '
|| str.snake('pg str')
|| '- ~~using programming language for str manipulations~~ 
- **do it all in postgresql** ');

API

  • [] after
  • [] afterLast
  • [] ascii
  • [] before
  • [] beforeLast
  • [] between
  • camel
  • contains
  • containsAll
  • [] endsWith
  • [] finish
  • [] headline
  • [] is
  • isAscii
  • [] isUuid
  • kebab
  • [] length
  • [] limit
  • lower
  • markdown
  • [] mask
  • [] orderedUuid
  • [] padBoth
  • [] padLeft
  • [] padRight
  • plural
  • [] pluralStudly
  • [] random
  • [] remove
  • replace
  • [] replaceArray
  • [] replaceFirst
  • [] replaceLast
  • [] reverse
  • singular
  • slug
  • snake
  • [] start
  • [] startsWith
  • studly
  • [] substr
  • [] substrCount
  • [] substrReplace
  • title
  • [] toHtmlString
  • [] ucfirst
  • upper
  • [] uuid
  • [] wordCount
  • [] words

Dependencies

~21–35MB
~704K SLoC