pg_str

Crates.iopg_str
lib.rspg_str
version0.2.1
sourcesrc
created_at2022-01-31 02:35:56.610341
updated_at2022-01-31 03:47:50.045621
descriptionAdds str functions to Postgresql via an extension.
homepagehttps://github.com/abumni/pg_str
repositoryhttps://github.com/abumni/pg_str
max_upload_size
id524323
size7,914
(publicmatt)

documentation

https://docs.rs/pg_str

README

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
Commit count: 5

cargo fmt