Anton Nielsen

@InsumSolutions @marwachouch Three tips in one :) Here is the accompanying blog apexdebug.com/monitor-page-p…

Today on Instant Tips: Weighted Page Performance reporting...in Dev, in UAT, and, oh yeah, in Prod. with @c2anton and co-host @marwachouch. Join us at 12:05 pm EST! buff.ly/3UOqhnQ #APEXInstantTips #orclapex

@OliverLemm @orclapexworld How about a function that returns the query and adds where 1=2 If there aren’t any query criteria. (Unless I’m missing the point.)

Using an Interactive Report which shouldn't give any results when opening this page the first time, what would be a good solution? Using a page item inside the "where" clause doesn't help. Do we have any attribute wich can be set that the query should be executed? #orclapex

@plamen_9 @haydenhhudson Very good but with subtle mistakes. For example, we described how to call different template components from one column but in the second summary it describes it the other way around. Overall, it would save a lot of typing and just require a little review to straighten out.

I did an experiment yesterday - I tried to summarise a YouTube episode of #orclAPEX Instant Tips using only free AI tools. Curious about the result - check the link ✨ #LLM #AI #MicrosoftEdge #Copilot @c2anton, @haydenhhudson - how accurate was it❔ blog.apexapplab.dev/summarising-an…

I don't know if I mentioned these here before, but I updated both of these recently #orclapex: This one should be interesting to a lot of people apexdebug.com/writing-fast-q… This one is pretty specific and a little boring apexdebug.com/quicksql-yes-s…

@jeffreykemp I wonder how many people know realize how powerful it is. I knew about it but it didn’t click until this week.

@c2anton I've been using the PL/SQL Code feature of the DML process for a while now, love it (esp. that it works very similarly for interactive grids). The default is Region Source, and the Table/View option is useful to redirect the DML to a different table or view.

Tomorrow's APEX Instant Tip is a best practice hiding in the shadows. It should change the way most of us develop in APEX. I haven't learned something so fundamental about APEX in a long time. #orclapex youtube.com/watch?v=W8wuld…

@jeffreykemp Ah, thanks! I often swap them…I have to think to get it right.

@c2anton Great tip! Probably just a mis-speak - when you mentioned Oracle Forms, you said it uses optimistic locking, whereas it actually uses pessimistic locking. As you correctly said, it takes a lock as soon as the user starts editing the record.

@richsoule @fdernoncourt @oracleace @richsoule is about to review it. /joke /not a joke

You know you might have a bad data model when… Good answers or jokes are fine but let’s mark jokes as jokes. @fdernoncourt @oracleace #Kscope23 #datamodeling

@nlitchfield @richsoule @fdernoncourt @oracleace Hmmm...wow. I'm going to have to think about this. Maybe I drank too much CoolAide while I was at Oracle in the 2000's when Larry just wanted "all of your data" in the Oracle database.

@richsoule @fdernoncourt @oracleace you have CLOB/BLOB data stored in your database. It's in the wrong place (maybe 8 times out of ten) /good answer

I should log an #orclapex bug, but twitter is easier. Bug, and workaround below apexdebug.com/ora-00904-dval…

I encourage you (y’all) to join live and let me know if everyone already knows this and I’m just late to the party.

@richsoule What is a strain sensor? And what happens when it acts up?

The fun of race car ownership. The Strain Sensor was acting up… we turned it off and on again. Currently all good, but will it last? 🤔

@mortenbraten @richsoule The highlighted sentences don’t attempt to answer the question of when the builder should be allowed in production. There is a huge range of how we use a database. I’m interested in discussing the vulnerabilities of having the builder in production. I’ll work on that :)

@richsoule @c2anton I appreciate the discussion, and agree with the conclusion, but his blog post is mainly about #orclapex in "production" as a sort of sandbox for "super users" (or "data scientists" or whatever). Not really comparable to what I'm talking about regarding the Runtime Only env.

As alluded to... apexdebug.com/do-you-develop…

@krisrice @mortenbraten I should stay off Twitter. Now I need a blog post…too long for a tweet. Perhaps I should have started here: focusing on an individual definition of “develop” will miss the broader themes of “appropriately protect the data” and “appropriately protect the computing resources.”

@c2anton @mortenbraten My line is my artisan crafted sql/code/plsql that is pipelined/tested/scanned/... should not be changed without change control/version/control/full pipeline tested before deployment

Hey #orclapex developers, Do you use the «Runtime-Only» version of APEX for your test and production environments?

@mortenbraten Where do you draw the line? What is the most you will allow without calling it developing? It’s not so easy to answer. But if you can’t answer that, then you can’t even say if you allow development in production. For me, it’s now “if” but “how much.”

@c2anton So if I go into Gmail and customize the layout of my inbox, I’m “developing” in Google’s production environment? I think I *do* define development differently than you 😆

@krisrice @mortenbraten It’s not _my_ production environment. It’s Oracle’s production environment for demonstrating the power of APEX :)

@c2anton @mortenbraten Terms state not for production use.

@mortenbraten If you have a single IR with 15 columns that might have filters, that’s 2^15 (32,768) possible dynamically generated queries. 32K different explain plans. No way people test them all. If you haven’t tested it, then you are developing in prod.

@c2anton Yes, apex.oracle.com is a good example of an environment where it makes sense to "develop in production".