Showing posts with label limit. Show all posts
Showing posts with label limit. Show all posts

Feb 28, 2023

Discussing with Bing chat AI

Google Bard is not open to public yet, but Bing has its chat enabled to public (after registering to a waiting list)

Here are some of our conversation bits:


Straight to the point, asking Bing how it compares to chatgpt (chat.openai.com) the current leader in the field of AI chat.

First bing is showing what he is doing in the background, which is good, it also is showing that its purpose is to perform internet searches, and will provide links (hyperlinks inside its response)

My second question was about google bard (the competition) and chat bing responded that it is open to the public (which is not true)

As a rule of thumb, it is good policy to never trust an AI response without checking.

Lastly I was badly surprised that there was a limit in the conversation, maybe to prevent people to corrupt the AI by training it the wrong way?

The conclusion is that, it feels like the future of internet searches is going to be AI
It feels right to discuss with a search engine this way, because we (human) have been acquiring information this way since the dawn of time.
No doubt, Google Bard is going to be doing more or less the same, and we will be able to get assistants in the near future, knowing everything about us...

This could be a good thing, unless of course ... this falls into the wrong hands, and then it is used by a dystopian government, but let's not think about that...


Dec 5, 2022

Z-library down past Nov. 4 2022

Z-library was a database of e-books and scholarly articles operational from 2009 to November 2022.

The site was an important resource for many people, most of them college students.

The website was shut down on Nov. 4 2022 after the U.S. federal government seized its domains.

The domain has been seized, but Z-Library website is still available via Tor and I2P network.



Apr 13, 2017

SQLite: showing a random record from a table

Random record

If many occasion developer want to get a random record(s) from a table, because they are programming a quizz, or a game - it turns out there is no native instructions for that in SQLite
but you can use this workaround:

SELECT
*, random() as R
FROM Table
ORDER BY R
LIMIT 1 ;

Why it works

It insert a random number (R) for each record and then using the order by there is going to be a selection of the smaller number (R) - you can even change the LIMIT to get more than one record - let say 3

SELECT *, random() as R FROM Table ORDER BY R LIMIT 3 ;

Subscribe to: Posts (Atom)

Popular Posts

  • A little pseudo painting using ArtRage2 - "Spring" is the word !
  • What is it lately, this unexplainable need to change everything that works ? What about this idiom " if it ain't broke, don't ...
  • After I gave a shot at ArtRage2 bundled with the Wacom tablet, I took the other cd that was in the box - and installed .... Photoshop Eleme...
  • Hannah Wagner (better known by her stage name Miss Hannah Minx; born Oct. 1990) is an American vlogger known on Youtube for her Kawaii ...

AltStyle によって変換されたページ (->オリジナル) /