Best practice for organizing DDL SQL files

I am developing a postgres database with the following approximate number of entities:

  • 60 tables spread across 7 schemas
  • 20 functions

What’s the best practice for organizing all the DDL SQL?

I currently have a single SQL for the table definitions, another for the views and yet another for the functions. But two of these files have grown to over 1,000 lines each and become unwieldy. That said, there are relationships between tables in different schemas and one file makes these easy to manage.

Would it be better to organize the DDL by schema? Or finer grain still, at the entity level?

I am using JetBrains DataGrip and would appreciate that the solution still enable Intellisense and error checking. The SQL is stored in git.

Some problems importing *.hdf5 files in MA12.2

I’m attempting to Import datasets from a *.hdf5 file into Mathematica 12.2 in Win 7.

After looking at the syntax in the Wolfram Documentation Center and displaying the StructureGraph, I had no problem importing some of the datasets, from various levels, using Import["file.hdf5",elem]

However, the one dataset I’m really interested with, just gives me $ Failed, with no additional explanations. Suggestions?

I can look at the data in this dataset using an app called HDFView. It looks fine, a spreadsheet similar to those in the datasets that were imported.

using Import[file, {{"Dimensions", "DataFormat"}}], I do notice one thing that is perhaps a problem? The format of one column is "bitfield". Using HDFView, this column includes values of either 01 or 00. Is this the problem and can it be solved?

Two of the other datasets in this files I also can’t import, but at least I get a warning message:

LibraryFunction::fpexc: Numeric data containing a floating point exception (NaN or Inf) encountered.

When looking at these datasets with HDFView, they indeed contain some NaN values. Is there a way to import them?

Modeling a “Bob” in Dresden Files

I’m running a Dresden Files game, and I think my PCs need a Bob. Because I need a mouthpiece and exposition engine.

But the description of Bob in Our World is skimpy at best, equating him to just a Lore check at +5.

I’m comfortable creating the story of our Bob equivalent. But how does the relationship with the PCs get modeled in-game? And has anyone used the existing Powers / Skills to create something like this in more detail?

My thought was to introduce the artifact / character and then allow the PCs to swap an existing Aspect for one related to it at the next opportunity. That Aspect will let the players use our “Bob” for Declarations, for effects, etc..

And if they don’t, then I have all the control over Bob. I say when he speaks, and when he won’t. What he knows and what he doesn’t.

Bottom line: If they don’t incorporate our Bob into their Aspects, then he’s my plot device, my mouthpiece. If they do, he becomes a way for them to tell their stories and solve their problems.

Sound fair?

Data being edited in .opvn config when vpn app http gets .opvn files from my host. Adds my wordpress site code and removes the config

I have a VPN app that pulls .ovpn files from a folder on my website /home/mywebsitename/public_html/remoteovpn When I add the .opvn files to this folder and my app pulls them from https request. You can go to the files in the browser link, you can see them and read all the config no problem even dl them. But when my app pulls the files it gets the file names and makes the .opvn files, but edits the files with my website wp theme data, not the .ovpn config data. I can’t figure why it is doing this. Any help would be appreciated been trying for 2 days

VPS with CentOS 7 and cPanel with wordpress theme

Formatting code in .wl and .m files from the command-line?

I use an external editor (Sublime Text) to edit my .wl and .m files and run them with WolframKernel from the command line. This means everything I do is outside of Mathematica. Is there a way I can format a file using something like the official code formatter where I input the code in the file through the command line as standard input and receive the formatted text as standard output (something like cat /my/file.wl | formatting_util)? Thanks for reading.

Link Extractor saved files are blank

This is really weird because I just scraped like 1800 URLs that found 20X that number of internal links. All of the links are in the TXT file

Then I try to scrape ONE URL,¬†, and it finds 70 internal links but when I open the TXT file, there’s nothing there.

I also disabled my proxies (they were getting a “socket error # 10054”) and then I tried to scrape the homepage of The Onion as a test.

Same problem, it says that 33 internal links were found but nothing saved to the file.

And I tried using my three ProxyMesh proxies, my StormProxies that I just bought today, and no proxies. Every time it says it’s saved but the file is empty.

Any ideas?

Also, is there a way to save scraped data with a more descriptive name? It’s really difficult to find files when the file name is just a long string of numbers.


how to make sure your wordpress is clean of any old files from previous themes so you can install a new theme

with no issues from past themes/plugins. The goal here is I am planning to install a premium theme for my existing WP site and use Divi Plugin So far I’ve tried contacting Bluehost but they just did a ‘scan’ or something so I don’t know if they understood what I meant. I’m relatively new to WP. Tinkering for about 2 years. I’ve tried google searching and irrelevant articles pop up. When searching this site I got 0 results. Hope I’m articulating my question well.