php – What is an efficient way to create, temporarily store, and search user-created database tables?

I am working on a web project, creating a tool that allows the user to submit some small amount of data (a ~30mb text file), from which I want to create several thousand database entries that can be searched through.

The database entries will then be searched through depending on the user’s search parameters.

Right now my idea for implementing this is to accept the text file onto my server –> process the data within the file using Python –> create a MySQL database table from the Python output –> search this table with the user’s parameters –> delete the table when the job is finished and the data is outputted.

The problem that I foresee is that each time a user creates a submission, a new table will be created, so I will need to have some way of cleaning these tables up (deleting them) after they are no longer needed. On top of that, if I want to store user jobs, my database will get cluttered with hundreds and hundreds of tables from user submissions, so I feel like my architecture/design is totally wrong.

I haven’t implemented the database/backend fully yet but wanted to know if there was a more efficient way of creating, storing, and searching ‘temporary’ tables. My experience is with PHP/MySQL, but if anyone knows of a better way to do this, I would appreciate the info.

macos – In the mac app Music I can go to the Music Store but how do I search for an artist or a song

I’m using the on my iMac running Catalina. When I enter the Apple Music Store how do i search for an artist or a particular album or song? I hope this is not a stupid question, but I’ve looked everywhere for a search box. I have found a way but its convoluted and doesn’t work all the time. If anyone knows how to search on the App Music Store using the Music app please let me know? Thanks. Do i have to load iTunes?

python – How to store the value of the calculated variable within a function to another variable outside it?

I am new to Python programming, and trying to calculate the heat of an enclosure with the user-fed values (Height, depth and width) in entries (Tkinter GUI interface). I have defined a function to calculate the area for every different type of the enclosure. However, I am not able to to fetch the value of final result and store it outside the function (I tried using global variable too. But it didn’t work). Below is my code:

def AreaofEnclosuretype (AreaResult, Height, Depth, Width):
    H = (Height.get())
    D = (Depth.get())
    W = (Width.get())
    selection = v.get()
    if  selection == 1:
        result1 = 1.8*float(H)*(float(W) + float(D)) + 1.4*float(W)*float(D)
    elif selection == 2:
        result1 = 1.4*float(W)*(float(H) + float(D)) + 1.8*float(H)*float(D)
    AreaResult.config(text="Area of enclosure is %f" % result1)

Furthermore, I can display the value of calculated Area within the master window. How do I fetch/extract the value of the the calculated variable result1 and store it as another variable ?

applications – Unable to restore a deleted app from App Store Connect

I had deleted an app for our beta bundle ID from App Store Connect a few months ago. Now I am trying to restore it. But I am getting the following error.
enter image description here

Can anyone help me in understanding this or let me know how to restore it back?
Because I really don’t want to create a new beta bundle ID now.

I don’t know if this is helpful, but here’s the API response when the restore call is made:

  "errors" : [ {
    "id" : "35b33baf-xxxx",
    "status" : "409",
    "title" : "An attribute value is not acceptable for the current resource state.",
    "source" : {
      "pointer" : "removed"
  } ]

Thanks a lot.

security – Using the same user store for Identity and Authorization

Is this considered bad practice?

I have an IdentityServer with a user store implemented in AspNet Core Identity.

The Identity server acts as a Federation gateway.

Let’s say I have a range of different clients registered. Some of these has own user stores,
Umbraco etc, and users are autolinked=created in the clients own user stores. Other clients are self-developed APIs. Would I create a user store for each or could the IdentityServer user store be used? Or is this bad practice?

olap – Best way to store multidimensional data for querying and computation

I am looking for the most suitable way to store multidimensional data on application backend.

Use case:
Application that allows users to complete tasks.

  1. dimension – Users (Thousands expected)
  2. dimension – Tasks (Thousands expected)
  3. dimension – Date (Thousands expected)

Data querying examples

  • The user should be presented with a table to submit tasks.
  • The user can acquire points for his completed tasks. Upon changing the value in a task cell the acquired points should be recalculated.
  • We should be able to generate responsive leaderboards and graphs.

I would suggest storing the data in a relational database.
Each of the dimensions would have its own table and all of them would be connected via a relation table where the multiple dimensions would be referenced with foreign keys. If a task would not be completed it simply wouldn’t be present in the relation table.

Is this a approach sufficient? Scalable? Is there a better approach?

mac appstore – Why aren’t apps like Gradle, Carbon Copy Cloner, Android Studio, etc. in the App Store? How to “safely” install them?

To keep things simple, I’d like to only install apps from the official AppStore. But, I’m frequently finding that the apps that I need are not on the AppStore such as Gradle, Carbon Copy Cloner, and Android Studio. It is what it is, and I install them, but what’s the deal?

Why aren’t some legitimate MacOS apps in the AppStore?
What do expert Mac users do when they need apps outside the AppStore?
Is the only solution to use checksums to validate that the downloaded files are the correct files?

javascript – How do document databases (like mongodb) store data behind the scenes?

For a couple of reason which need not be mentioned here, because they are rather complex, I need to program my own NoSQL document database in node.js. However, I am quite confused as to what is the best way to store this data.

I’ve searched around on google, but most information is on how to use a database, not how to program one. The following questions were a blank on google:

  1. To me, the name “document database”, and the fact that the smallest unit of data is a “document”, implies that each one would be stored in an own file. Is this correct?

  2. Also, how are collections grouped together? Is each collection a folder of documents? Or a manifestation file pointing to different documents in a collection?

  3. How should relations between documents be implemented? Is it compliant to the term “NoSQL database” to even have a concept of relations?

  4. Should a NoSQL database contain a way to create schemas for documents, or should NoSQL databases be free-form and schema-less?

I would greatly appreciate it if anyone can answer these questions!ūüĎć

How To Use Social Media Marketing For ECommerce Store – Social Media Marketing (SMM)

Would you like to stay ahead of your online rivals in 2020 and get more sales? You must practice the best social media marketing strategies that will help you drive unlimited traffic on your website. More traffic means more possibilities of sales.

There are different social media sites such as Instagram, Twitter, Facebook, etc. You can promote your store products using right social media marketing strategies to hike your sales.

Explore more info: How To Use Social Media Marketing For ECommerce Store