lovasoa

16 ms·

181.
by lovasoa 3y ago
Maybe I'm mistaken, but I think someone who is already using a relational database through an ORM can learn enough to make powerful queries in an afternoon. Let's see what we need: - SELECT a,b,c FROM table WHERE condition : 1
182.
by lovasoa 3y ago
SQL is much more powerful than most people think, and taking an afternoon to learn everything you can do with it is a great investment. After you do that, you will probably not WANT an ORM anymore, finding that it makes your code less reada
183.
by lovasoa 3y ago
The title is a reference to the famous "Attention is all you need" paper. https://arxiv.org/abs/1706.03762
184.
by lovasoa 3y ago
It's back online; it was just a log file that grew too large.
185.
by lovasoa 3y ago
I am not complaining. What I am saying is that the current experience for most users is the following: I want to compute a sha1 hash in postgres. I make a google search, I click the first link. It says I should run `digest('mystring&#x
186.
by lovasoa 3y ago
I was recently reading the documentation for pgcrypto to implement user authentication in SQLPage: https://www.postgresql.org/docs/current/pgcrypto.html The page contains the documentation of many functions, all o
187.
by lovasoa 3y ago
I will add an example to the README with an INSERT statement to make it more obvious what SQLPage can do. For the header, I don't think that would be necessary. SQLPage would route queries to .sql pages to the SQL parser and queries to
188.
by lovasoa 3y ago
Hi, and thank you! I could see it happening. Of course it would be in addition to sql, not to replace it. First, prql would need to support insert and update statements, though.
189.
by lovasoa 3y ago
Re-reading your comment, I realized what you seem to have hit was a bug in SQLPage ! Simple pages without an explicit 'shell' component were always supposed to work, but they were not tested ! I fixed that in v0.6.8 https:/&
190.
by lovasoa 3y ago
Thank you for this heartwarming comment ! My github sponsors page is opened at https://github.com/sponsors/lovasoa You can also leave your email on https://docs.google.com/forms/d/1t91PI0vF5Hy
191.
by lovasoa 3y ago
I'll try to include more of the technical contents from github on the landing page, without making it too obscure for neophytes.
192.
by lovasoa 3y ago
Thank you ! If you've built something with it, I'd love to get your feedback, and see your pain points.
193.
by lovasoa 3y ago
Thank you ! That's the main feedback I've had about the landing page. I wanted to make it clear, but as non-technical as possible to convey the value proposition and avoid scaring decision-makers away. But I missed my target: rea
194.
by lovasoa 3y ago
Yes, the idea is that you first make a query that returns a single row with a "component" column, and potential other top-level parameters for the component. This is translated to some HTML that displays a piece of user interface
195.
by lovasoa 3y ago
I'd love to get your feedback if you use it ! Both positive and negative.
196.
by lovasoa 3y ago
If you do create an app with SQLPage, I would love to get your feedback, here on contact at ophir dot dev. And if you do not manage to create what you wanted, I would love to get that feedback too !
197.
by lovasoa 3y ago
Cool project ! It seems to target a more technical audience than SQLPage though, with a bit more required to build an app than just SQL. It takes more time and skills to build something, but as a result, you get more control and customizati
198.
by lovasoa 3y ago
This feedback is gold to me. Is there any way I can get in touch with you when I've made changes to see how that would work for you ? Can you list the step you took, starting from opening the website, and where the first pain points we
199.
by lovasoa 3y ago
This is a very good point, and I think I have a hard time explaining how it works technically without it sounding more complicated than it actually is. The diagram is a good idea, I'll do it. For a simple explanation, what do you think
200.
Show HN: SQLPage – Build Dynamic Websites with Just SQL Queries(sql.ophir.dev)
45 points by lovasoa 3y ago|27 comments
201.
by lovasoa 3y ago
Because he's an artist, not a programmer. But I have to admit that, after finding the video on hacker news, I was quite surprised when he opened Photoshop too
202.
by lovasoa 4y ago
Did you report them to the University?
203.
by lovasoa 4y ago
GitHub Copilot X is currently a representation of GitHub’s vision for the future rather than an available product offering of GitHub Copilot. As we continue to design, test, and build features that fall into the GitHub Copilot X visi
204.
by lovasoa 4y ago
I think tokio is the gold standard in rust: https://tokio.rs/
205.
by lovasoa 4y ago
https://github.com/lovasoa/SQLpage Project Description: A website builder that uses only SQL. A single binary that renders .sql files as web pages. Lets data analysts turn any database into a custom CRUD website. What
206.
by lovasoa 4y ago
To see the magic: curl -I https://danq.me/wp-content/no-code-webpage/ | grep -oP 'base64,\K\w+' | base64 -d
207.
by lovasoa 4y ago
Related to https://no-ht.ml : A few years ago, I wrote a small js library to convert HTML to unicode: https://www.npmjs.com/package/html2unicode
208.
by lovasoa 4y ago
I don't think sharing your Google analytics tag was the cause. If Google de-ranked unrelated sites using the same Google analytics id, we would see black-hat SEOs using that against their competitors. This ID isn't a secret.
209.
by lovasoa 4y ago
Hey, I am the maintainer of sql.js. I was in contact with them, and I do not think they are working on a npm module, but I offered them to work on the existing "official" sql.js module.
210.
by lovasoa 4y ago
100$/month for a site that runs random people's code seems great ! Do you mind sharing some details ? What does your architecture look like ? How many "vals" do you have, and how many executions per day ?

More ›