circa | my library set for c99

I'm integrating with external system.

From it I have 3 files:

• customer_data.csv
• address_data.csv
• additional_customer_data.csv

Order in each of them can be random.

There is:

• relation one to many (customer_data => addresses) but I am interested only in one address with specified kind.

• one to one (customer_data => additional_customer_data)

Goal:

Merge files together and put it in one index in Elastic search.

Additional info:

-each file has circa 1 million records

-this operation will be done each night

-data is used only for search purposes

Options:

a) I thought about:

1. Parse and add to ES first file

2. Do the same from next and update document created in point one

Looks very inefficient.

b) another way:

1. parse and add first file to relational data base

2. do same with another fields and update records from point one

3. Propagate data to ES

Can you see another options?

I know the question about display:inline not working has been asked multiple times for varying circumstances, but I can't find my problem. It works but doesn't work, even in the same paragraph. I'm using a tooltip, which works great on desktop and mobile. Here is the page: https://coachcaudlecares.org/llltest.html Here is the css:

I have inherited the support of a SQL server database hosted in Azure.

There are 5 - 10 WPF applications installed on individual users' desktops which access this database.

The users all have personal PCs (ie. not centrally managed by the organisation) with dynamic IPs because of residential broadband.

The application connects to the database directly with an ADO connection.

There is a single user name and strong password (circa 40 characters) used by all instances of the application.

The unencrypted credentials are only stored in a password safe, not GitHub or anywhere else etc.

The connection string is strongly encrypted and that is what is stored in the app.config and decoded in the working memory of the application at runtime.

The database has TLS security turned on (ie. encrypted at rest). PII data is stored in the database as well as bank accounts details (nb. financial details are stored in additionally encrypted columns)

Database access has been granted by white-listing all IP addresses:

Is this setup acceptable from a security point of view? If not, what needs to change or what can be done to improve it?

This question is similar to two other posts I've found, Is Azure SQL secure when using it for a desktop program? and How can I allow unknown users to access my SQL (Azure) DB?

I believe my question is different enough to these because the answers there basically fall into two camps 1). 'whitelist all IPs' and 2). 'introduce a middle tier'.

Whilst I'm experienced at building WebAPI services, I do not see that introducing a middle webservice tier using HTTPS fronting the database necessarily makes it more secure (tell me if I'm wrong).

Ideally I'd like to keep the current architecture for simplicity but satisfy myself that the setup is acceptable from a security angle.

Amongst the stuff I have inherited in my current role is an ancient Perl CGI web application (circa 2002). The connects to an Oracle database. It appears to be using an equally ancient LDAP server to resolve the Oracle database. Formerly, everything here used the LDAP service to retrieve the TNS connection definition. We have migrated everything else to use a simpler DNS name based connection string. I want to do the same for the Perl code.

But I can't find any references to the LDAP server in the Perl code.

I can establish a direct correlation between an HTTP request being made (and hence the perl code executing) and a connection to the LDAP server.

Looking in the code, the DBI constructor looks like this:

My dataframe has a max of 2 variations of each string e.g if the string is 'USD' then sometimes another entry with 'LDUSD' is present also...the entries without 'LD' are always present.

I need to apply x[0:2]+'_'+x[2:] but ONLY if the column contains an exact match of x[2:].

It must be done this way to ensure the change only happens to the relevant entries, as there are also various items which include either 'LD' in their default name e.g ('EGLD','LDO','SLD') or include the current x string e.g.('TUSD','USDT').

I have looked for a solution for this problem for hours and looked through a lot of posts on this site as well, but I could not find a solution. I'm using python 3.9.2

I’ve stumbled upon a bug about multi touch.

It seems that, from the latest Android 11 update, my app cannot get consistent coordinates inside a view.

Tested with S20+ on Samsung lab.

Let’s say i touch a view on its very top left point. A MotionEvent is spawned and event.getX() and event.getY() returns 0.

BUT… if i press the screen with 2 finger, one in a random screen area and one on the same top-left pixel of the previous view… the latter gets

event.getX() -> 300 (circa, depending on where the View is inside the screen) event.getY() -> 400 (same)

Is it a bug or i’m doing something wrong? This didn’t happen with any Samsung phone with Android 10 or any non-Samsung phone

Any workaround?

Is there any way I can concatinate string, numbers and symbols, using the open() write function, to 1) Multiple lines, and 2) max lenght of chars, say 6-maxlenght. I have two questions regarding a Python program I've written, that in theory should generate a list of somewhat strong passwords, automating a usually tedious process, I know Mozilla does this automatically, but this program is just something I've written for myself to learn the language and CS in general.

So, here is the whole code, stripped of a few personal comments, also, is the return generatePassword() redundant in the if/else statement on line 23 and 26?

""" begins here """

Things could be not easy to understand at first sight, but step by step...

This is beginning of my circa 50000 rows Dataframe df_answers_clean

After using len(set(df_answers_clean['Race'])) I get 98 unique positions, which is too much for my future classifications. I made a example - list of the 25 positions of them are below: