วีดีโอ

For now I have a blog post: hartenfeller.dev/blog/apex-24-1-template-component-improvements

I haven't played around much with OCI myself but I guess you can do that with a loadbalancer like described here: medium.com/oracledevs/add-custom-http-request-or-response-header-to-oci-load-balancer-7eb7861e168c Let me know if you find a solution :)

Thankyou

Thanks @bhavinadhvaryu8549 ! I created a pre 23c/ai example here: gist.github.com/phartenfeller/93ba48aeea3b9c55879ff2689f9e6790#file-query-pre23ai-sql

@@hartenfellerdev Thank you so much for your prompt reply.

Thanks! You can take a look at this for pagination: th-cam.com/video/pjV3rCBBT_Q/w-d-xo.html

Hi! I am not sure if I understand correctly. If you want to filter rows you should add a WHERE clause to your query.

@@hartenfellerdev I have a bit different data set where I have player. My only intention is to get URL with track name as per your example not with ID. I understand the point will see WHERE clause just like "function searchTracks" not exactly but some what. right? Will get back if needed.

I have one also linked in the description: sveltekit-demo.hartenfeller.dev/

You are welcome! Do you have any ideas/requests for future videos I can do?

@@hartenfellerdev Hey! Thanks a lot for the video, it was very enlightening. I hope you keep doing many more. I do have a few beginner questions: 1) If I were to use Svelte + LiveView (Elixir), would push notifications in a PWA be made any easier (more automated, less steps)? 2) Also, I'm not sure I understood and this is a recurrent doubt of mine: does the user need to have their app open in order to receive the push notifications, or is it just like in any native app? I'm asking because I need to build a project that relies completely on push notifications (users should be notified just by having the app on their home screen). 3) Last one: whenever I try to add a shortcut to a page on my android homescreen, I get an icon showing my browser's icon (chrome, for example), but I noticed it wasn't the case for your app on your video. How can I make it look like a native app icon?

Thank you! I don't know LiveView so I can't tell. The underlying flow would be the same but it can be that there are out of the box solutions making this easier to implement. The underlying operating system receives the notifications so the page does not have to be open. But the browser itself should run to display the notifications. You want to add a web manifest to the website. Then the browser icon will not show up. I have a video for that too: th-cam.com/video/ywXXOvfKoYg/w-d-xo.html

Thanks for the feedback! Check out this video where I build an app from scratch and also use a relational database: th-cam.com/video/iO4VUbQ6ua4/w-d-xo.html

@@hartenfellerdev Thank you very much...

@@hartenfellerdev if we do movie_comments @insert and there was no comments table in the DB... will it create one automatically and populate it with new comments? That way we could let the svelteserver dictate normalized schema for all UI elements with graphQL syntax which is insanely good. OR do we have to pre-define the tables in our DB and their columns before we can write to them with json relational duality? If we have to know the schema first I think its pointless because then we already know SQL and can join together a view query_json_comment_input and call it from sveltekit to populate it. BUT if we don't know the schema and get duality_json_comment schema to create new tables that didn't exist when we write a user input that would speed up development so much.

​@@emonymph6911 The table structure has to exist beforehand. Oracle provides some tools to migrate from JSON schemas to relational: docs.oracle.com/en/solutions/migrate-mongodb-nosql/migrate-data-mongodb-oracle-nosql-database-cloud-service2.html#GUID-616464AC-0B27-4808-8537-2DAB409BC380 I doubt that you can implement APIs that have - perfectly match the pages required document structure in one API endpoint - knows how to write changes back by just getting a document back without instructions - with change overrides protection - with all filter, order by, pagination etc. tools in the same time to create a duality view. Sure you can self-implement all of it but it would be lots of manual code...# I also think it is a bad idea if the SvelteKit backend can create tables and columns as it likes. Some developer might miss an already existing col/table then you have duplicates etc. If your data is an important asset for your app/business treat it with an appropriate care. Designing a tight fitting schema is way less work than having to fix bad data in the long run...

@@hartenfellerdev Thank you, your comment is really good. Could you please correct me on my thought here. Why do you feel this would be harder? Assume we have 3 tables: users, movies, comments. Then we create a view from them storing each json object in its own row. so its read same as duality view. CREATE OR REPLACE VIEW comments_input_view AS SELECT c.comment_id, json_object( 'movie_id' VALUE c.movie_id, 'title' VALUE m.title, 'genre' VALUE m.genre, 'release_year' VALUE m.release_year, 'comment_id' VALUE c.comment_id, 'user_id' VALUE c.user_id, 'username' VALUE u.username, 'comment_text' VALUE c.comment_text, 'comment_date' VALUE c.comment_date ) AS comment_json FROM comments c JOIN movies m ON c.movie_id = m.movie_id JOIN users u ON c.user_id = u.user_id; then we can fetch it in sveltekit with just this 'SELECT * FROM comments_input_view' import { json } from '@sveltejs/kit'; import { executeQuery } from '$lib/db'; // Path to your db utility file export async function GET() { try { const result = await executeQuery('SELECT * FROM comments_input_view', []); return json(result.rows); } catch (error) { console.error(error); return json({ error: 'Database error' }, { status: 500 }); } } what's the old way missing out on? i feel like the json_object() with joins is a lot easier to write when we know the tables in our db.

Thanks for the kind words! Great I always wanted to try out Tauri, great to hear thtat it works with SvelteKit!

I host this myself on a Linux root server. Serverless needs its own architecture and I want to keep things simple. Oracle Cloud has an "always free tier" where you also get a VM: docs.oracle.com/en-us/iaas/Content/FreeTier/freetier_topic-Always_Free_Resources.htm Alternatively, you can also get a cheap VPS. That's how I started, and trust me, I learned so much more while administering a Linux server than clicking around in a cloud UI.

Hey, thanks for the feedback. Do you know any resources on how I can achieve better layering?

Hmm, maybe check if it works if you put the file into the lib folder like I have: github.com/phartenfeller/sveltekit-1.0-sqlite-demo-app/tree/main/src/lib/assets/img

Found it. German umlaut in filename, I usually don’t use such things.. but that what it was. Thx 🙏 anyway

Great! That this causes an error is kind of "unverständlich" and "unverschämt" :)

Nevermind... just passing 'data' as prop did the trick. It's kind of confusing though to me, a guy native to the realm of Java.