Aaron

My feedback

  1. 3 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Azure Database for PostgreSQL  ·  Flag idea as inappropriate…  ·  Admin →

    Thank you for your interest in Azure Database for PostgreSQL.

    Monitoring solutions that don’t have to be added as an extension are possible alternatives. Workable solutions query the server’s statistics through a low-privileged user role. Possible examples are pghero, pgwatch2.

    Please do let us know if POWA specifically is needed and any additional comments.

    Thanks,
    Rachel on behalf of the Azure Database for PostgreSQL team

    Aaron commented  · 

    It doesn't have to be POWA, but it looks like any monitor needs superuser to do anything useful. pghero won't suit my needs and pgwatch2, while looking impressive, requires superuser access for the more advanced monitoring. See https://github.com/cybertec-postgresql/pgwatch2#steps-to-configure-your-database-for-monitoring

    Aaron shared this idea  · 
  2. 872 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    7 comments  ·  Azure Cosmos DB » SQL API  ·  Flag idea as inappropriate…  ·  Admin →

    There are multiple responses to this suggestion.

    Support for SQL-like syntax for UPDATE, DELETE and INSERT INTO are not on our road map at this time.

    However, the underlying functionality for an UPDATE, SET is essentially a PATCH. This functionality we are actively working on. See this User Voice item here to track for future updates. https://feedback.azure.com/forums/263030-azure-cosmos-db/suggestions/6693091-be-able-to-do-partial-updates-on-document

    Thank you for your suggestion.

    Aaron supported this idea  · 
  3. 138 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    11 comments  ·  Signup and Billing  ·  Flag idea as inappropriate…  ·  Admin →
    Aaron supported this idea  · 
  4. 61 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    10 comments  ·  Azure Database for PostgreSQL  ·  Flag idea as inappropriate…  ·  Admin →
    Aaron commented  · 

    For those who have concerns about the time it would take to migrate (like me), Microsoft mentioned at Connect this gem https://www.attunity.com/products/replicate/attunity-replicate-for-microsoft-migration/ I will be investigating it for my needs, and thought I would share it here.

    Aaron commented  · 

    For some background, I have a two VM setup in Azure (Master with warm standby) and I am looking for a way to migrate to Azure Database.

    Aaron shared this idea  · 
  5. 783 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    31 comments  ·  Azure Cosmos DB » SQL API  ·  Flag idea as inappropriate…  ·  Admin →
    Aaron commented  · 

    Create a UDF
    --------------------
    function regexMatchUdf(input, pattern) {
    return input.match(pattern) !== null;
    };
    -------------------
    SELECT *
    FROM c
    where udf.REGEX_MATCH(c.Property, "1234.*" )

  6. 3,838 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    128 comments  ·  Azure Cosmos DB  ·  Flag idea as inappropriate…  ·  Admin →

    Reopening this user voice item as our support for Skip/Take (Offset/Limit) was only limited to single partition queries.

    Update.

    The newly released .NET SDK v3 now includes support for x-partition queries using Offset/Limit. You can learn more about v3 SDK and try it and provide feedback on our github repo here.
    github.com/azure/azure-cosmos-dotnet-v3

    We will also be back-porting this functionality to our .NET v2 SDK. This work will begin shortly and we anticipate it to be released in September.

    Once that is released we will mark this feature as complete.

    Thank you for your patience and votes.

    Aaron commented  · 

    It's been 3.25 years. How long does it take to implement this? We want to switch from RavenDB, but CosmosDB just has too many limitations.

  7. 53 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Azure Cosmos DB » SQL API  ·  Flag idea as inappropriate…  ·  Admin →
    Aaron supported this idea  · 

Feedback and Knowledge Base