Extension Request: Nanoid

Steven_Recarb · August 28, 2023, 12:29pm

Hey folks! I was wondering if it would be possible to support nanoid-postgres as an extension: GitHub - viascom/nanoid-postgres: Nano ID for PostgreSQL. We’re in the process of migrating away from UUIDs, and this would save us from a bunch of user-land code. Thanks

Mahmoud · August 29, 2023, 10:19am

Hey @Steven_Recarb, welcome!

We already support pgcrypto, so you can copy the contents of this file and run it in the Neon SQL editor.

github.com

viascom/nanoid-postgres/blob/main/nanoid.sql

/*
 * Copyright 2023 Viascom Ltd liab. Co
 *
 * Licensed to the Apache Software Foundation (ASF) under one
 * or more contributor license agreements.  See the NOTICE file
 * distributed with this work for additional information
 * regarding copyright ownership.  The ASF licenses this file
 * to you under the Apache License, Version 2.0 (the
 * "License"); you may not use this file except in compliance
 * with the License.  You may obtain a copy of the License at
 *
 *   http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing,
 * software distributed under the License is distributed on an
 * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
 * KIND, either express or implied.  See the License for the
 * specific language governing permissions and limitations
 * under the License.
 */

This file has been truncated. show original

Does this solution work for you?

chris-visser · September 13, 2023, 10:34am

I’ve tried this code, but I need to be superuser. How can I do that?

vadim2404 · September 13, 2023, 10:48am

It’s related to the LEAKPROOF option when creating the function. If you remove this parameter, the function will be created.

chris-visser · September 13, 2023, 10:51am

Shouldnt I be able to simply add this parameter? And what would be the impact for the DB? I understand its PG specific, but my knowledge on this is limited thanks for the quick answer btw