# \#postgresql

**URL:** https://metaruby.com/tag/postgresql/17.md

[Latest](https://metaruby.com/latest.md) · [Categories](https://metaruby.com/categories.md) · [Tags](https://metaruby.com/tags.md)

---

## [Kirillshevch/pg\_drive\_backup](https://metaruby.com/t/kirillshevch-pg-drive-backup/1323)

<div class="topic-metadata">

**Author:** [@kirill\_shevch](https://metaruby.com/u/kirill_shevch)\
**Replies:** 0\
**Last updated:** [October 30, 2017, 1:19am UTC](https://metaruby.com/t/kirillshevch-pg-drive-backup/1323 "2017-10-30T01:19:39Z")

</div>

https://github.com/kirillshevch/pg\_drive\_backup - Simple solution to make encrypted with ccrypt PostgreSQL backups and storing on Google Drive API

---

## [Anyone know of an in-depth guide for database indexing?](https://metaruby.com/t/anyone-know-of-an-in-depth-guide-for-database-indexing/1093)

<div class="topic-metadata">

**Author:** [@MatiasFMolinari](https://metaruby.com/u/MatiasFMolinari)\
**Replies:** 0\
**Last updated:** [June 19, 2017, 5:38pm UTC](https://metaruby.com/t/anyone-know-of-an-in-depth-guide-for-database-indexing/1093 "2017-06-19T17:38:31Z")

</div>

I’ve been looking for an in-depth guide on database indexing that includes performance benchmarks and possibly anti-patterns. Most guides stop short on comparing indexed vs non-indexes performance, but I’m looking for s…

---

## [Rails & Postgresql case insensitive data fields](https://metaruby.com/t/rails-postgresql-case-insensitive-data-fields/498)

<div class="topic-metadata">

**Author:** [@kofno](https://metaruby.com/u/kofno)\
**Replies:** 3\
**Last updated:** [May 2, 2016, 7:27pm UTC](https://metaruby.com/t/rails-postgresql-case-insensitive-data-fields/498 "2016-05-02T19:27:19Z")

</div>

I didn’t know about citext fields in Postgres. Here’s a nice solution for when you need a case insensitive unique field.