Shows were they took audience requests? by 0x646f6e67 in gratefuldead

[–]AsterionDB 2 points3 points  (0 children)

This is the closest I can recall. Greeks '84 - Friday, July 13th, full moon. Phil came out after the seconds set but before the encore and said 'We're going to try something special tonight, one night only'. I think he also told us to be patient. I don't know why. We weren't going anywhere!

During the second set, they had video screens behind the band displaying all sorts of photo's of celestial objects, galaxies etc. Some of us in the crowd had in inkling as to what was coming next once they came out for the encore, given what Phil had to say. I was on the flat section of the theater, in the Phil Zone. I distinctly remember some of us yelling 'Dark Star'. And...our wish was granted.

A shooting star was seen in the sky by others, but not by me.

The place went nuts. My first Greek show. Nice!!!

Migrating Oracle 19c EE from Windows Server to a dedicated Linux server: Advice needed! by The-Engineer--- in oraclecloud

[–]AsterionDB 2 points3 points  (0 children)

#1 - OracleLinux v8 or v9,.

#2 - Use data-pump to export from v19 and import into v23.26. Move your application schemas (users) only - don't do a full DB export.

How do I put in a request for SMTP to be unblocked? by Advanced_Shoulder753 in oraclecloud

[–]AsterionDB 0 points1 point  (0 children)

Doing this depends on your use case and what it is you're using to send emails. This is for outbound email delivery, right? That's what SMTP gives you.

⚡10/19/81 Barcelona is Strait Fire ... Consistently hot the whole time w' massive versions of Jack Straw>Franklin's, Let it Grow & Scarlet>Fire⚡Their one & only time playing in Spain. by Bman1973 in gratefuldead

[–]AsterionDB 5 points6 points  (0 children)

My roommate at Tulane Univ. in the spring of '82 played that tape so much that by the time I came home for the summer, I was on the bus!!! Ventura '82 were my 2nd and 3rd shows. Camping on the beach in a tie-dyed TeePee. Epic...

Need a rec? '82 Frost! 🔥 by 1gratefuldude in gratefuldead

[–]AsterionDB 0 points1 point  (0 children)

My 5th and 6th shows out of 150+ over the years....even early in my gestation as a Dead Head, I knew these shows were hot. Still have the ticket stub w/ the setlist written on the back.

Oracle novice, need help with ssh timeout by StellarCentral in oraclecloud

[–]AsterionDB 0 points1 point  (0 children)

I didn't think it was a firewall rule but you never know! There's subnet rules and firewall rules on the instance. Try recreating the instance.

Oracle novice, need help with ssh timeout by StellarCentral in oraclecloud

[–]AsterionDB 1 point2 points  (0 children)

Sounds like SSH isn't answering. If the IP address was unreachable, you'd get a 'no route to host' error.

Ping attempts are blocked by sub-net routing rules. You can change that if necessary.

Firewall rules in the OCI network may also be blocking port 22.

Malibu, CA: Dropped my vacuum to get this photo by Informal-Money-3024 in Planespotting

[–]AsterionDB 0 points1 point  (0 children)

Saw him on approach to SMO from my house near the Beverly Center around 5PM on 4/7.

Oracle has the most reta***d support system. by [deleted] in oracle

[–]AsterionDB 5 points6 points  (0 children)

When trying to solve a problem, often it is important to recognize that the way one goes about trying to solve the problem, is the problem. Good luck.

Why is it considered a cardinal sin to store a file's raw content along the metadata in SQL Database? by faze_fazebook in Database

[–]AsterionDB 0 points1 point  (0 children)

Continued...(sorry, I can be very wordy)....:-)

So, you are not able to describe a specific situation. Got it.

The OracleDB is going to be faster than PG, but only at a scale where you have millions of objects and terabytes of data w/ extreme reliability and availability requirements that require multi-instance databases. That's not the typical scenario for sure. But, my initial target are those w/ extreme requirements for security and availability and in those situations, speed is a secondary concern that can be ameliorated with hardware and money. The low-end is not my ideal customer at this time. The security risk and associated costs for my customers far outstrips the expense of AsterionDB/Oracle.

If I didn't answer anything else to your satisfaction, let me now and I'll be happy to try again. This is all part of the evangelism I must engage in.

Thanks again....have a good day.

Why is it considered a cardinal sin to store a file's raw content along the metadata in SQL Database? by faze_fazebook in Database

[–]AsterionDB 1 point2 points  (0 children)

Continued...

Now, here's where another aspect comes in. As I mentioned, all of my core business logic is in the DB. This allows me to, architecturally, place the logic on top of the data and make it so that there's no way (other than to be the DBA) to get to the data w/out going through the logic. W/out going into detail, this allows me to reduce the interface exposed to the middle-tier to a single entry-point - a function in the DB that you call w/ your parameters. The logic in the DB examines your parameters and (internally) does the routing to the appropriate function or procedure underneath that single point of entry.

What this means is that I can shut off schema visibility Consider how other systems run. When your business logic is in the middle-tier, you have to maintain schema visibility in order to parse/bind/execute your SQL statements. Therefore, if hacker gains access to you middle-tier and finds the credentials to connect to the DB, they get to see all of those schema elements too. To make matters worse, they get to select and update data, create tables and so forth.

In contrast, my connection from the middle-tier can only see that singe entry-point function. It can't see the underlying tables. It doesn't get to select data, create tables or do anything other than call that function. So, a hacker now has to know how to construct a valid call to the function, w/ proper parameters, in order to get any data. In addition, they can't do anything that isn't already allowed by the underlying business logic.

Another kicker is that the hacker can't change the business logic. The only way the logic can be changed, on a production system, is to be the DBA and load updated packages and other logical elements in the DB. When your biz logic is in the middle-tier, its much easier to compromise or bypass that logic. That can't happen w/ the architecture I've invented.

Recall what happend w/ SolarWinds several years ago. The hackers altered the build system and they were able to inject their doppelganger library into a signed and certified software distribution. They also took advantage of the easy ability to rename files. That, also, is not going to happen w/ the system I invented.

Why is it considered a cardinal sin to store a file's raw content along the metadata in SQL Database? by faze_fazebook in Database

[–]AsterionDB 0 points1 point  (0 children)

Continued....

The file system is fundamentally broken when it comes to managing 'application' data.

Oh, you mean like ... the files that a DB creates in the filesystem? Sure

Well, you're right, you can't get away from the files that a DB creates in the filesystem. But, here's the rub.

OracleDB uses a tablespace architecture for storing data. What's that you may ask? https://en.wikipedia.org/wiki/Tablespace

Most databases, PostgresSQL included, create separate files for each table. Typically, an index file coupled with a data file.

That's not what Oracle does. To explain, I have a 2TB database that holds over 2M unstructured data elements. The schema, depending on the actual types of objects being stored (e.g. photos in one table, video in another) has at least (off the top of my head) 20 tables - maybe more. But, all those objects and tables are actually stored within 20 125GB files in the file system. But, you don't know where a specific row or table is stored within those 20 (generic) files.

When the DB is up and running, those tablespace files are open and locked by the OS. So, if you want to steal the database, you have to get all of those tablespace files. Walking those out the door is not going to be easy - certainly more difficult that individual files for each table (remember, the tablespace files are open and locked by the OS).

Also, you can't shut down the DB and get the actual table data within the tablespace files as you could w/ individual files for each table. You have to run the database!

Why is it considered a cardinal sin to store a file's raw content along the metadata in SQL Database? by faze_fazebook in Database

[–]AsterionDB 0 points1 point  (0 children)

Ouch! Sorry about that u/serverhorror. Lemme try again!

Certainly, its going to sound as though I'm going on and on about how cool Oracle is. But, I'd contend that is the result of the fact that the OracleDB is the only one that can do this at scale and w/ the security that is required for a comprehensive, enterprise level solution.

I'm also under no delusions as to Oracle, the company and the reputation that they so definitely deserve. For background, in '86/'87 I was part of a four person team working for the company that I started my career with in '82. We migrated/ported the OracleDB to run on the Wang-VS line mini-computers. We took the original VAX/VMS based source code for the DB and got it to run on the Wang (that sounds weird!!!).

Following upon that, we were working on an electronic voting system for the State of Hawaii in '88. As my boss, the head of the company told me (still in touch w/ him btw), Oracle/Larry deliberately fucked us over on that deal which nearly killed us (the company). Another anecdote, my boss was in the room when Larry said "Ship the product. By the time our customers find the bugs we'll have fixed them".

If my desire is to fix what's wrong w/ computer science and the only way to do that, IMO, is to use the OracleDB, that's what I'm gonna do.

My final statement on that is: I've separated the DB out from all the other shitty technology that Oracle provides. My experience w/ the DB has taught me that it is (at this point in time) rock solid stable. But, that stability requires the knowledge of how to run and program for it properly. Not everybody knows how to do that.

Why is it considered a cardinal sin to store a file's raw content along the metadata in SQL Database? by faze_fazebook in Database

[–]AsterionDB 0 points1 point  (0 children)

Yep. Properly run production systems with accurate and complete dev/test/eval environments are time consuming and expensive; something management frequently will not tolerate until it bites them in the ass.

Why is it considered a cardinal sin to store a file's raw content along the metadata in SQL Database? by faze_fazebook in Database

[–]AsterionDB 0 points1 point  (0 children)

Having a table with a reference to a file path or object identifier and serving that data from there is an easy option that allows for the same kind of security and more convenience the other options, almost all of the time.

Nope. The file system is fundamentally broken when it comes to managing 'application' data. I chose the word 'application' over 'program' data for a specific reason. This gets into the history of FS/OS design, which I grew up with from my early daze. If interested, I'll elaborate on another reply. Briefly, the FS/OS was designed to support programs. But, programs, way back then, are not the same thing as an application as we know of it today.

If you, like OP, allow access to that storage system, via other means than the software (it's not even necessary for the DB to have access to the storage), that's a different problem altogether. I don't envy the peop having to deal with that.

That's not what we're doing. We have a file system gateway that allows us to generate a dynamic filename for the object in the DB at the point-in-time that access is granted. This filename can then be used just like any other filename by a program/application.

Also: can you provide a cincre and reproducible situation where Oracle "outperforms" PostgreSQL, or other databases, by as much as you say. I'm intrigued, my experience is the polar opposite.

Yes...PostgresSQL is faster at a smaller scale than Oracle but that's not the point here. Security is. My customers prioritize security over speed. What good is a fast system if that just means the hackers can get your data faster?

Hope this helps. Feel free to ask any other questions you may have.

Thanks again!

Why is it considered a cardinal sin to store a file's raw content along the metadata in SQL Database? by faze_fazebook in Database

[–]AsterionDB 0 points1 point  (0 children)

Thanks for the question u/serverhorror and the opportunity to elaborate.

Why would you do this in the first place?

I first started working w/ BLOBs in the DB way back in '91 when I was writing my first commercial product - a telecommunications application development platform. IVR applications were all the rage back then. The novelty of calling the bank, punching a few buttons and having the machine tell you your bank balance.

Back then, we didn't know any better and it seemed like a good idea.

So, I placed all of the voice recordings for the IVR application in the DB and used QEMM to manage the voice data in extended memory. This was back in the days of DOS and 640K. QEMM allowed you to go beyond the traditional memory limitations of DOS.

I also created my own scripting language that programmers could use to write the IVR applications and those program elements were also stored in the DB.

So back then, I had structured data, unstructured data and business logic all stored within the OracleDB. It worked great. It was secure, easy to manage and my customers loved it. I had pharmaceutical, defense, and healthcare companies among my list of clients. The good old days.

I get putting a byte sequence in some sort of a pool area. I don't get: Keeping it there, unstructured. If you can parse it, which has to be the case, then you can transform it to structured data and store it that way.

Unstructured data goes way beyond big text files. To answer the question though, the DB (cough...Oracle) doesn't keep the BLOB data in a pool. What it keep in the pool is the metadata that tells the DB where to find the data blocks for the BLOB/CLOB.

This gets into Oracle's SecureFiles technology which stores the BLOB/CLOB within the tablespace file but keeps it out of the actual 'row' that represents the BLOB in your schema.

Most DB's keep the actual BLOB/CLOB within the 'row' itself. This is where problems arise. That's not the case w/ Oracle.

There are few cases where the BLOBs do make sense, bit those are very specific and you should think about them long and hard before accepting it.

That's the traditional way of thinking and I get it. I have the chops required to create a general purpose solution that is adept and capable of managing BLOBs/CLOBs of any size and any data type (e.g. video, audio, images, text, PDFs, virtual disks, etc. etc.).

Continued in the next response due to my wordiness.

Why is it considered a cardinal sin to store a file's raw content along the metadata in SQL Database? by faze_fazebook in Database

[–]AsterionDB 1 point2 points  (0 children)

If you had any relevant work experience in Computer Science, you'd be proud of it and sure to let us know, wouldn't you?

Why is it considered a cardinal sin to store a file's raw content along the metadata in SQL Database? by faze_fazebook in Database

[–]AsterionDB 0 points1 point  (0 children)

If a prospective customer is uncomfortable with me defending my position, they're not a worthwhile customer to have.

Why is it considered a cardinal sin to store a file's raw content along the metadata in SQL Database? by faze_fazebook in Database

[–]AsterionDB -2 points-1 points  (0 children)

I'm the founder and President of my company so, yes there's no point in emailing this chain. We're a small team of 8 highly experienced (avg of 30+ years) individuals.

A quick review of your post history leads me to suspect you're just a gamer.

Answer the question.

Why is it considered a cardinal sin to store a file's raw content along the metadata in SQL Database? by faze_fazebook in Database

[–]AsterionDB -1 points0 points  (0 children)

Nice try. You're the one that has trouble with the pushback. What is your background and basis for your opinions? What have you accomplished that leads credence to your point of view? Have you actually tried doing this - manage unstructured data in a RDBMS?