Can I write portable SQL statements?

I am wondering if it is possible to write SQL statements that are 100% interoperable with most or all databases including:

  • MariaDB/MySQL/Percona
  • Postgres
  • Microsoft SQL
  • Oracle
  • SQLite

(Eg, can I just follow a specific SQL standard? Eg, is there something similar to POSIX compliance standards for SQL?)

If so, are there any linting tools available that I can use in a git post-receive hook to reject SQL usage that doesn’t follow such a standard or non-compliant SQL code without having to try to commit the code on all DBs?

Portable Hole vs Bag of Holding vs Handy Haversack – differences other than size/weight?

I’ve got a kleptomaniac in my group who’s constantly picking up entire armfuls of junk to bring back to town or squirrel away for a rainy day. I want to gift her some kind of carry-all to assist in the junk-holding, but scouring item lists has turned up three different potential options, all of which seem roughly similar other than their respective total volumes.

  • Portable Hole has a 3.14 x 10 x 9ft^3 (~270 cubic feet) space with no weight limit
  • Bag of Holding has a 3.14 x 1 x 4ft^3 (~12 cubic feet) space with a 500lb weight limit
  • Handy Haversack has a combined .75 x 4 x 4ft^3 (~12 cubic feet) space with a combined 120lb weight limit (I think, I am very bad at math)

My intention is to reskin one of the items as a tapestry that’s being used as a cloak by a puma. (Isn’t D&D great?) I want them to be able to put things into the tapestry and also retreive them at will later. Other than that it’s pretty flexible.

Am I overlooking a difference between the Portable Hole, Bag of Holding and Handy Haversack that would make one item significantly better suited to this purpose than the others? If size and weight are the only relevent parameters then it’s an easy enough choice but I can’t help but shake the feeling that I’m missing something.

Is Bitlocker secure enough for portable storage devices?

I have recently lost a U drive, which contained some important information. Fortunately, it was protected by Bitlocker. I felt the compulse to ask exactly how secure it is. Most answers on this site related to Bitlocker seem to be about built-in storage on a computer. This answer says there was a possible cold boot hack. Is it more secure to protect a U drive with Bitlocker, since you cannot use that kind of hack on a U drive? Also, that answer is 6 years old. There must have been some new developments. With the current technology that Bitlocker uses, do I need to worry that the information on my U drive could be decrypted?

A permanent portable Magic Circle

So, a Wizard just got their hands on the Planar Binding spell line, and wants to start utilizing it. Said Wizard also likes to be self-sufficient AND is invested in their alignment – which means they don’t want to ask other people for help and REALLY don’t want to start casting spells of opposed alignment. But in order to Bind a creature of the same alignment, you have to cast a Magic Circle spell of opposed alignment, which even carries an opposed [alignment] descriptor.

After thinking about it for some time, I’ve realized that the best way to do this by-the-book is to have a magic item that specifically works as a Magic Circle that’s turned inside. The question is if there’s an item like this already or if I’ll have to make a custom one.

I know that there’s the Binder-only Seal of the Spirit in Tome of Magic that serves a similar function, but it works strictly for Vestiges.

Lightweight Portable CPT brand

Company Profile
Taizhou Dixin Investigation Instrument Co., Ltd (formerly Wenling Dixin  Investigation Instrument company) is a professional factory specializing in the research and development of CPT equipment. Since its establishment, our company has been appointing professional technicians of after-sales to do the follow-up services for different investigation fields in different regions, and to collect feedback from on-site use.
The products are continuously upgraded and innovated, economical and reliable CPT equipment are developed which are suitable for variety investigation fields in different regions.
At present, Dixin has obtained a number of patent certificates of utility models and inventions from State Intellectual Property Office. In 2014, our company was rated as a scientific and technological enterprise of Zhejiang Province. We have high-quality and economical products with various features, and high-quality on-site tracking services, which are favored by institutions of geo-technical investigation all over the country. At present, we are proud to become not only the largest manufacturer of CPT equipment but also the top selling of CPT equipment in China.
The company establishes its advantages in “independent R&D, lean manufacturing, and integrity management” and forms its own core competitiveness, which help the company develop rapidly. The company has always pursuing the development principle of “reputation first, quality first, customer first, personnel-oriented”, and it will continue to innovate and improve quality to meet the demands of users better.Lightweight Portable CPT brand

Does assembly language get translated to binary code? If so, is assembly language portable across machines?

I’ve tried to find the answer through Google but I’ve come across conflicting uses of terminology, so I just wanted to be absolutely clear.

Here is my understanding: High level code written in a high level language (C I think is one of the lowest-level high level languages) gets translated to assembly code by that language’s compiler.

That assembly code then gets translated to machine code (aka binary code aka hexadecimal code) by something (not sure what does this translation).

Does that mean that assembly code, but not machine code, is portable across computers? Or is assembly also not portable, and the only thing portable is code written in a high level language?

Problem with portable ubuntu graphics driver and resolution

So I setup Ubuntu 16.04.5 LTS 64bit on an external HDD to use with both my home computer and laptop.

Home PC:

  • GTX 1660 Ti
  • AMD Ryzen 5 2600

Laptop: Macbook Pro (late 2013) with i5 processor and Intel Iris Graphics.

When setting up ubuntu I didn’t install any third party drivers since that was recommended on the guide I followed for portable setup.

Macbook works fine without any drivers, but on PC the monitor is shown as builtin display and I can’t change the resolution to anything other than 1024×768. I tried using xrandr for adding new modeline but it didn’t work saying the maximum resolution for the display is 1024×768.

So I installed nvidia driver (430.50) manually from Nvidia’s website and now ubuntu recognizes my monitor and I can change the resolution. But now it causes problem on Macbook.

When I boot it on Macbook after installing nvidia driver, after entering password on login screen, it gives a black screen and few seconds later returns to login screen.

Tried blacklisting nvidia driver when booting on Mac but it doesn’t work.

So I want to either:

  • Change the resolution on PC without nvidia driver
  • Use the nvidia driver on PC but disable it when booting on Mac

Been googling for two days but couldn’t find any solution that works.

Need to make a portable Ubuntu with only 1 pendrive

I have been using Ubuntu for a while. I find it very convenient to plug my pendrive into any computer and then use it like my own. Installing Ubuntu on a pen drive required 2 pen drives..i was wondering if there was a better way, using just 1 pen drive (for eg: make a bootable virtual disc and then run that on a VM and use that to install it on the pen drive. Is this possible? Can someone direct me to a place where i can find the steps?

Thank u!

portable monitor isn’t detected after sleep

I have a dell xps 13 9380 running 19.04 Ubuntu. I also have a zenscreen mb16ac portable monitor. The portable monitor connects to my laptop via usb c as a display and to get power.

Initially, when I plug the monitor in, my laptop detects it and everything works, but when my laptop goes to sleep or suspends, and i wake it back up, my laptop no longer detects the monitor, but it’s still powering it.

The only way to get it to detect the monitor is if I unplug and plug the usb port back in. I’m not sure why this is happening.

How can I get my laptop to detect my portable monitor when it wakes up? I don’t want to keep unplugging and plugging in the cable every time ubuntu sleeps or suspends.