interrogate | concept tool for identification of cryptographic keys | Cryptography library

Suppose you have a Partition Function, and you are dynamically adding and removing Range Boundaries to that Function, using ALTER PARTITION SPLIT RANGE and ALTER PARTITION MERGE RANGE.

You can interrogate sys.partition_range_values to establish what the current range boundaries are.

It appears that no matter what you create, split and merge the ranges in, that sys.partition_range_values table will always show that the boundary_ids (and equivalently the partition ids, in other sys tables) are in ascending order of the boundary values.

Is that actually guaranteed?

Can I be certain that boundary_id 1 will always be the left-most boundary of the Partition Function?

Let's assume I have a struct like this:

I know this question has been asked before and most of the answers warn about doing so or suggest a solution for MyISAM but I'm using InnoDB. I'm trying to generate an Invoice or Bill for the user for him to give out to me (Business plan requirement) !

The thing is that in my country the reference of the ID of the bill for the same person should be ordered or he will be audited for the missing bills. Like for example he gave me one bill with 0001 and the second one is 0005. He will be interrogated for the missing 4.

So I need to have a custom auto-increment per UserID.

User 1 - idUser= 1 ,idBill = 1

User 1 - idUser= 1 ,idBill = 2

User 2 - idUsr = 2 , idBill = 1

Some threads suggested using triggers while others warned about table locks. I personally not familiar with triggers so I steer away from them since they require maintenance.

I am using Java and MySQL.

I'm a relative Postgres newbie, though have some basic experience with MSSQL.

I have a table on PostgreSQL (PostGIS, it's spatial) that contains about 10,000,000 polygons. The machine it's sitting on has 64gb RAM, 16 cores and a 1TB spinning HDD. This is only of the only tables in the database at the moment. Because access to the table is infrequent (perhaps once every few hours) I'm noticing that the table will not stay located in RAM, as I would expect with MSSQL. Instead, the table seems to be released from memory and sit on disc in an active state. This is leading to 100% HDD utilization for 15+ minutes when I want to query / join / interrogate / etc. When the table seemingly appears to be in memory subsequent operations are notably faster (seconds rather than minutes).

Is there a way to ask Postgres to keep a certain table in memory, or have the scheduler / whatever bits of postgres that perform the smarts keep the table in ram, rather than letting it go to disk then having to recall it into memory when required?

I have spatial indexes (and a couple of other columns that often require filtering / sorting indexed), so when being called from memory it's quite fast.

This same issue also seems to massively affect JOINS, because they too require the table to be read first. This is a separate issue for me, but seemingly affected by the same root problem. Disk IO bound.

My DB settings are as such - so generally I'm not inhibited by available memory / ram, so far as I can tell.

Edit: Table is 26gb

I'm using React Router v5.

I've got a situation where I need to support the following use case.

I've got React component that is accessed via /project/1234. However, I also need to access this same React component via both /project/1234/hello and /project/1234/goodbye. Again, all three of these routes need to navigate to the same React component.

The following code doesn't work since, as I understand it, if I navigate to /project/1234/goodbye, react-router will interpret this as me passing 'goodbye' as the value of the :hello param, so if I interrogate the params programmatically using react-router's useParams() hook itself, I'll have the wrong param values.

I am looking to implement Hangfire within an Asp.Net Core application.

However, I'm struggling to understand how best to prevent the user from creating duplicate Hangfire "Fire-and-Forget" jobs.

Say the user, via the app, creates a job that does some processing relating to a specific client. The process may take several minutes to complete. I want to be able to prevent the user from creating another job for the same client while there are other jobs for that client still being processed by Hangfire (i.e. there can only be 1 processing job for a specific client at any one time, although several different clients could also each have their own job being processed).

I need a way to attach additional meta-data (in this example, the client id) to each job as it is created, which I can then use to interrogate the jobs currently processing in Hangfire to see if any of them relate to the client id in question.

It seems like such a basic feature that would prove so useful for such scenarios, but I'm coming to the conclusion that such a thing isn't supported, which surprises me.

... Unless you know different.

Hangfire looks great, and I'm keen to use it, but this might be a show-stopper for me.

Any advice would be greatly received.

Thanks

I have a problem where I need to produce something which is naturally computed recursively, but where I also need to be able to interrogate the intermediate steps in the recursion if needed.

I know I can do this by passing and mutating a list or similar structure. However, this looks ugly to me and I'm sure there must be a neater way, e.g. using generators. What I would ideally love to be able to do is something like:

How can I loop thorough a record one character at a time? I want to interrogate records in a ASCII file one character at a time looking for and replacing non-printable characters. I tried using the Loop Condition with no luck. Thanks in advance for any help.

So I have looked through many of the answers already posted in StackOverflow, and I cannot seem to find one that applies.

First, let me explain my Xamarin Forms App. I have the traditional solution structure (.Net Standard 2.0 class library with the Andoid and iOS application projects). The application I am working on is part of a suite of application which share a large amount of code (header, footer, error handling etc) via an additional .Net 2.0 standard class library. In this class I have a viewmodel for exception handling as well as a standard header content view used in all applications that are part of suite.

Within the header I show an error icon in the header area that the user can click on to report the errors etc. when the exception processor adds an exception. I bind the IsVisible property of the image control for the error icon to a property in the exception handling viewmodel. Every time my a page displays (all pages use the shared header), the get for the property in the viewmodelthe IsVisible property bound to is called. So it would appear the binding is configured correctly.

The problem is that when I add an error via my exception handling view model and then attempt to notify the UI that the bound property has changed, the PropertyChange event objet - defined as follows: